new form

  • Thread starter Thread starter PAULBOL
  • Start date Start date
P

PAULBOL

Kinda new to ms access so please be patient. Purchased a softwar
package to do job costing, the major selling point was it wa
“written” in access and we could do some custom forms, reports etc.
After linking to the existing tables we made some rather nice querie
and reports, so far great. Now we are trying to make a form to ente
information to the existing tables, we can make the form work but no
in a user friendly way. Here is the problem, there are 2 fields
record_id and job_no that are not autonumber fields but are set t
“required and no duplicates” what I would like to do is upon openin
the form is

1) all fields blank except record_id would be one number mor
than the last record in the tabl

2) job_no field would be one number more than the last record in th
tabl

3) customer name field would have our most used customer name an
address in the blanks and the customer name field would have a dro
down option with the rest of the customers

4) a button of the form to enter the info into the table and reset th
form

maybe this is not possible but any help would be appreciated, I hav
bought several books on access and searched numerous forums, tha
made the quires and reports possible but the forms seem to be muc
more of a challenge. Many thanks for the hel
 
PAULBOL said:
Kinda new to ms access so please be patient. Purchased a software
package to do job costing, the major selling point was it was
"written" in access and we could do some custom forms, reports etc.
After linking to the existing tables we made some rather nice queries
and reports, so far great. Now we are trying to make a form to enter
information to the existing tables, we can make the form work but not
in a user friendly way. Here is the problem, there are 2 fields
record_id and job_no that are not autonumber fields but are set to
"required and no duplicates" what I would like to do is upon opening
the form is

1) all fields blank except record_id would be one number more
than the last record in the table

2) job_no field would be one number more than the last record in the
table

3) customer name field would have our most used customer name and
address in the blanks and the customer name field would have a drop
down option with the rest of the customers

4) a button of the form to enter the info into the table and reset the
form

maybe this is not possible but any help would be appreciated, I have
bought several books on access and searched numerous forums, that
made the quires and reports possible but the forms seem to be much
more of a challenge. Many thanks for the help
Click to expand...
 
Sorry, not sure what happened there...

It looks like what you would need is an unbound form that saves the
data only when you click the save button. Typlically Access adds it as
you enter it. What you would need to do, it to run a couple of queries
when you load the form to find the last numbers and then increment them
and display them. When you click the Save button, you would then run
another SQL query to insert the data into your table(s). This would
probably need to be done using VBA (Visual Basic for Applications) I
would be happy to work with you one on one over email to help you
accomplish this, or alternatively I work as a freelance Access
developer, and could probably build you the solution for $25 depending
on how complicated it it. Either way, if I can be of assistance
contact me at mike(at)echovue.com or on my web site - echovue.com

Hope that is of some use to you.

Thanks

Mike
 
Back
Top