Search results

Hi - Sorry for not responding sooner - got side-tracked doing something else. I try your suggestion. The save button will ensure that the user checks and saves theis work. Thanks, again!

Hi - I have a data entry form with a form/subform. The main form has a drop-down to select a device number, then the subform has the details to add for that device to the table. When the form opens, the cursor defaults to the first field in the subform. If the user upon opening wanted to go and...

Yes-that did it. Thank you very much for your help.

From the switchboard I have to run the data entry, a chart, and a report with meter totals by machine. There is no problem running the chart and the report. Since the data entry is a form/subform setup, and needing a cursor default on the subform, this setup needs some extra code for that button...

Hi, thanks for replying. I did set the tab order so that the field to have the cursor be at is first. From the switchboard, I can bring up the data entry form but I have to click in the form, then I can enter my data. When I go into the form from the switchboard, the default tab is not...

Thank You very much for you help. I will keep going through the db and maybe something will jump out at me.

I am not able to save the database in any other format but 2010.

Hi - Here's the db. Again, if you open the frmMeters form, the tab shows up on the date field, the first field in the subform. Running this through the frmMenuSwitchboard (the first button) - no tab. Thanks.

Actually, after entering the form from the menu form, the tab function doesn't work in the main form. When I used it, it was moving down the left column of database objects. I would have to actually click in the main form to start data entry.

I just tried using Sub Form_Current instead of Sub_Form Load in the subform code, but that isn't setting the cursor.

Thanks for replying. When the form/subform is first opened (Sub Form_Load), I do a SetFocus on that field.

Hi - I have a data entry form, consisting of a form/subform. I use a front end menu form to select doing the data entry, by clicking a button. I updated the subform so that upon opening the form, the cursor appears in the first field in the subform, and then the user tabs through the fields to...

Hi - I am creating a temporary database which will only be needed for a month or two. Is there a macro or can I create a macro to delete the entire database on a certain date? I've seen something with Excel where a workbook was setup with a macro to self-destruct on a certain date. Rather than...

Used option 1. Thank You very much.

Good Evening - I have a report which contains meter counts for machines listed by machine number and shift. This is based on a query that prompts for a date range. The report lists at the top a total meter count by shift, only 2 lines, then the grand total of that. Next is a subreport which has...

Thanks, Missinglinq - I looked through all the macros, and cleaned my computer screen, but didn't find a stray '.'. So I deleted the data entry button, copied and pasted one of the report buttons, edited that, and now the new button works. Glad that's cleared up. Thanks, also, to vbaInet for...

Hi - Yes I did recreate the menu item, then the switchboard, but that message still shows up. There is no problem with the data entry form itself working. I am able to update the table with it. This is a form/subform, could there be something with that setup? No issue with the other switchboard...

Good Morning - (Access 2010) I have set up a switchboard menu to run a data entry form and some reports. When I click the button to run the data entry form, I get the "Microsoft Access cannot find the object '.'. After I click OK to remove this message, I am able to navigate the form with no...

I did some more digging and came across a thread that you were one of the responders in -(ions) who was creating an "infinite loop". The point made there was that the AfterUpdate event won't fire unless you actually enter something into the control. I was using a DLookup to get the unbound...

Yes. I tried both the After Update for the form and for just the control (the unbound control) and the bound field doesn't get updated on the form, and when I close out the form and check the table, the value does not appear in the table.