Search results

You are quite welcome! The folks on this forum have helped me tremendously and I am more than happy to make this small contribution!!

Put the following code in the form's On Open event: DoCmd.GoToRecord acDataForm, "formname", acNewRec This will take you to a new record at the end of the recordset. Then when you make a choice from the combo box it will populate the form with the details of your choice. Hope this helps! :D

Yes you can do it with two tables. Create a query that includes the two tables and base the form on the query. Make sure that the two tables have at least one field in each that relates the two like an id#. If you have not done this look up "relationships" in the help files to learn about how...

After you add all the fields to your form, from the toolbox toolbar (make sure the wizards control box is pressed in) choose the combo box tool and draw a box on your form. From the choices the wizard gives you, choose "Find a record based on the value I selected in mycombo box." Just follow...

I want to create a module with basic command buttons that I use on forms over and over, like Open, Close, Print, Save, etc. Can anyone point me to an example of this. I tried searching but did not come up with one. Thanks in advance! :)

Thanks Ghudson!! Man that link is excellent! I have had several occasions where I needed to use that Browse function and never knew how until now. It works great! thanks a bunch!! :D :D :D

Thanks Wayne...very cool! :cool:

I have a form that I use as a switchboard. On Open, it is sized to whatever size it was saved as the last time it was opened. One command button on the switchboard opens a query and when you maximize the window for the query and then close the query, the switchboard form is also maximized...

Open the Employees form in design mode then click the Code button to view the code behind the form. It's pretty well documented so you should be able to find what you want.

Need Help on Table/Form Design I have a data input form with 32 questions each worth 10 points,. The answer is selected in a combo box with choices “Yes”, “No” or “N/A” (not applicable). Once the form is completed the following formula is used to compute the percentage score: count(yes) / 320 –...

I believe it is a combination of both or either will cause the date/time modified to be updated. I know in 2000 you can display the Date Created and Date Modified in the Database window which will tell you when specific tables/forms/queries/reports, etc have been changed. I think you can do...

Something like this should work. SurveyDate.Format = "mmm yy" If SurveyDate > Now() + 60 Then SurveyDate.BackColor = 255 Else: SurveyDate.BackColor = -2147483643 End If

Excellent Pat! Snapshot it is!

No I did not see that as an option in the file type drop down. I do not know how to code to export to pdf...it will require further research but thanks for the suggestion!

When I export a report to an rtf file it does not display anything for the check boxes (yes/no fields). MSAccess2002; WinXP Suggestions? Thanks :D

I answered my own question: :o I called the function in the "QUIT" command button code that is on my switchboard and it works fine. Thanks again.

I placed this in a separate module however it does not work. I am using Access 2002, WinXP. Any suggestions?

Thanks for your replies! I knew I could count on you all! :D

Quickie: Do you folks recommend to set most databases to compact on close? If not, when would you NOT want to compact on close. Any other comments also appreciated. Thanks

Thanks Kodo! :D It works great!