Search results

I am using Access 2000 and have the following issue I need assistance with please. I initially had no primary key set on the table and the form and all the data from the tables showed fine in my form. However, I wanted a primary key to prevent a user from accidentally typing a duplicate Repair...

Thank you Oldsoftboss. The changes work like a charm!

I have created a switchboard and some additional forms. I would like the frontend of the database to display my forms in a maximized view when the users opens them. Can anyone advise me how to do this? For some odd reason when I make changes to the forms (example) resizing them my clicking and...

Yes that does make sense and was a huge help. Thanks so much. I was able to update the table using the formula you posted. I did notice that now when I do the data entry to the form using the "Date of Service" my "Contact Date" and "Date of Next Service" fields are automatically updated...

I created a form using a text boxes by using the field list icon and dragging the field I wanted to make into the text box onto the form. In the properties of that text box, under the format tab I set the format for "short date". Under the data tab in the properties of the text box I put in the...