Search results

You need to create the event. Sounds like you just typed that code in the events property. See if this makes more sense... Where To Put Code In Events

You need to post your code for us to decipher what is wrong. Include all the code for the event.

Since the front end should be on the users computer you can turn on the compact on close option for the front end. Compacting really depends on what you are doing with the data and how large the db bloats after you import data, delete data, etc.

You need to use a late binding method to build your emails through the Outlook object. Try the code I posted in this thread Outlook 2007 & E-mails instead of what you are using to avoid your problem. Do not forget to remove your reference to Outlook 11.

What is the exact name of your check box for the Two Buyers field? What is the exact name of your label and text field for the Second Buyers? It should be something like cbTwoBuyers and lblSecondbuyers & txtSecondBuyers if you are using a standard naming convention. In the AfterUpdate event of...

You should only need to perform the validation if the user tries to move off the current record or save the current record or close the form if all of your required fields are not completed. Slapping their hand if they jump to the wrong field before they completed a previous field is just cruel...

Searching the forum or google should help answer most of your questions. Here is an example I found with google... http://p2p.wrox.com/access-vba/42791-vba-check-box.html

Do it all in one form.

Refers to the Name of the current form that the code is run from. Try MsgBox Me.Name and if will display the name of the form that you run that code in.

I am not sure you can run another function in the same database while the query is proccessing. Access has a problem with doing more than one thing at a time. I would be interested in this if you get it to work for I have a database that outputs a huge pdf file in Access 2007 but the report...

Me.Requery will 'requery' the open form. DoCmd.Close Me.Name will 'close' the open form.

I would advise not to use the Form_Error event. Put all of your code in the events you are controlling and test for the know runtime error numbers to present your custom message based on the users error. Use a DLookup in the forms before update event to test if the number already exists.

Use the afterupdate event of the check box. A checked box has a value of -1 or True. An empty check box has the value of 0 or False. Use an If statement or Case Select to determine what fields to hide or unhide based on the users selections of the check boxes.

I advise you to not use an ActiveX calander control. Too many problems with the users PC having missing references to the control or problems with users having different versions of Access installed. Check this old link out > Pop Up Calendars

You can convert your macro to VBA using the Convert Macros to Visual Basic menu option. Here is the code I use to find a record in the after update event of a combo box... Me![txtAutonumber].SetFocus DoCmd.FindRecord Me![cboFindLastName], acEntire, True, acSearchAll, True, acCurrent, True

I believe the switch board data is contained in the Switchboard Items table.

Too late now but it is unfortunate that nobody thought ahead and used an online web survey where you could have downloaded the results into a spreadsheet which would have avoided the manual data entry and there will surely be typos and other data entry errors that you will need to account for...

Unless you are already doing this... I would use just one form for the data input and use a combo box to determine which farm in needed to filter the records based on the farm. Based on that choice, auto set the txtFarm text box [bound to a Farm field in the table] to identify which farm the...

Then there would be no way to open "another" file when a user opens a file from windows explorer. I must say this is an unusual request that does not make sense.

How/where are the users finding the jpg file to open?