Search results

On which event do I attach this code? TIA, Dave

I have a form with 4 tabs. I want to save every time a user changes pages. Not sure how to code that? TIA, Dave

That works :) Thanks Dave

Why does this code not branch when the user chooses no at the msgbox? ******************************************** Private Sub Command6_Click() 'Already A survey for this employer? If DCount("*", "qryCheckForPreviousSurvey") > 0 Then MsgBox "A survey for this account number already exists...

apr pillai... that works really well. I have always used the on no data event, and couldn't find the syntax, so did a search on the board and saw your post. I used your idea and it is GREAT! Thanks, Dave

Well dang! Thanks for the input and the link :) That gives me the info I needed for the fix. Funny I haven't seen this before after 15 years of code- guess I have just been lucky until now. Thanks again! Dave

This is a new one for me. I have a form with 4 tabs [Access 2003]. The first two pages contain historical data about companies, filled with queries. The 3rd and 4th pages contain some derived data, some compiled data and some massaged data, mostly from the first two tabs. The 3rd and 4th tab...

Thanks to all- DCrake that is what i used to use- thanks! Dave

That is how I set it up- but nothing happens after the 8 chars are entered....

Ooops... spoke too soon- it is requiring me to hit tab or enter to 'finish' updating the field. Any other suggestions? TIA Dave

Thanks, Bob. Not the way I remember doing it but this should work just fine :)

I have a field on a form that requires exactly 8 chars- when the user has entered all 8 i want to auto tab to the next field... haven't used this for several years and can't even find a reference to it :) TIA Dave

Found this post- and it even works!

I know this is an option for the entire database- is there a way to set this through VBA for ONLY two fields on a single form? TIA, Dave

Sure did :)

I had a few unplanned minutes today- your code, as usual, works perfectly..Thanks!

Thanks, Bob. I will work on this tomorrow.

I have a table that contains all the archived table names. This set of tables names all have the same name, followed by the date it was archived. ie "Random 1/1/2007" I built a form that displays those names. When the customer picks a specific table how do I open a form to display just the...

I found a simpler way using just a query........ http://articles.techrepublic.com.com/5100-9592-5047664.html Thanks, Dave

I am still lost. I set up the events as suggested- nothing happens, the box is empty when you click the dropdown. I then tried to use the suggestions in the properties for the form and the field. The dropdown is still empty. I then tried both together and still nothing. I guess I need more...