Search results

The tab order doesn't work because it sets the tab order for each page separately, not the control, but setting the on lost focus event of the last control on the first page to the first field on the second page worked great! Thanks for the help!

Thank you Charity, this worked. I appreciate the help!

I'm also posting this in the Forms forum, so please don't waste your time reading it twice! I have a form to enter employee information using a Tab Control with two tabs. The first tab includes the employee's personal information, the second tab includes the employee's work location...

I'm also posting this in the VBA forum, so please don't waste your time reading it twice! I have a form to enter employee information using a Tab Control with two tabs. The first tab includes the employee's personal information, the second tab includes the employee's work location information...

I tried the first suggestion and it worked great. I don't know why I didn't think of switching the if statement around (duh!). Thanks for both suggestions! I did notice, however, that both replies use the IsNull function - that was my problem, I wasn't using IsNull. Thanks! [This message...

Hopefully this is not too trivial to post on this board, but it's making me crazy! I have a termination date field in my table and and a field on a form that is visible only if the employee is terminated (date filled in). My expression is as follows: If Me![TermDate] <> Null Then...

So simple and it works great! Thanks so much for the help!

If I have a text field that holds 5 numbers (12345) is there a function in Access 97 or a way to reverse the order of the data (54321)? Thanks!

Hi again, still having problems...I'm not even sure how to describe this one. I have a form with a subform, in which the subform is longer than the screen. The subform default view is "single form". As the user tabs through the subform, it will not move up when it reaches the end, the user...

Yes, thank you, that helped tremendously. I only hope one day I'll be able to post answers instead of questions!!

Thanks Jon, I will use your first suggestion of txtNum & "20" to concactenate the numbers. I'm not sure how to write the rest of the code. Thanks!

I have a form where the user enters a preassigned number. I want VBA to automatically assign a value to the primary key field that consists of the number entered by the user + 20 at the end. Example: user enters 12345 in txtNum field, VBA assigns 1234520 in txtNumID field. I have written the...

Thank you - I'll try this!

I'm working on a project in which I have to import a text file into a table. I'm importing the text using the following code in the button's on click event: DoCmd.TransferText acImportDelim, "TEXT", "tblExisting", "c:\textfile.txt", True, "" This appends the records to the table. My question...