Search results

Very good point. Thanks Pat for the clarification.

Ok some great lessons learned here for me. Here's the nuggets: 1. Use the embedded navigation controls for New Record, Next Record, Previous Record, instead of building it in code. 2. Do not use Enable = False for controls on a new record in order to guide the user to controls you want them to...

I give this a try tomorrow and report back. Thanks again!

To prevent orphans in this case, can I simply change the SubmittalID in the child form's table to Required Yes? The seems to work for me. When I input something into the child form only, prior to a record being created, Access throws an error at me. The only way to get out of it is to hit Esc...

Well....I'm still a hack, when it comes to developing databases. I'm just self taught but really appreciate all that you and others here on this forum have done by way of teaching me. Thank you for your patience and time! I had my reasons for enable = false as the default, but I can see your...

Ok. Here's what I think is a solid way to do this for a subform that is in a tab control and has three command buttons to 1. Add a new record, 2. go to previous record, and 3. go to next record. The subform has all controls enabled = false except two. (Submittal Number and Date of Submittal)...

Thanks Pat for the reference. I will definitely watch that. Question though. In general, when setting up control validation, (i.e. Before the record is created, you want to ensure the user inputs data into certain controls), do you normally set all other controls to enable = false? If so, do...

Very nice! I will try this out. Thank you.

I have a subform in a tab control that has some control validation. The problem I am having is that it fires on a new record. How do I fix this? The validation control module looks for the * tag to check which controls to look at. Currently only one control has a *. SubmmittalNum. When I...

Well...that's a bit tricky for me. I have a dynamic search that requeries the subform. I think I'll just leave the Count in the footer as that at least does not show the error. May I'll work in this another time. I did try this but didn't work.

It gives the exact same error. And does not give the 0 in the Count text box. ?

I have a continuous subform that I want to display the record count in a text box outside the continuous form. See below "Projects found". Note in the footer I made visible the text box "Count" In "Count" is =Count(*) text box name is txtCount. In "Projects found" is...

I figured. Thanks DBguy.

Is it possible to apply conditional formatting to a listbox? Or do I need to redesign the what's in the listbox to a subform?

Thanks CJ. I feel better now. Ha. I will not use the Compact on Close and I'll just compact it manually every month. Thanks for your help!!

True, if I have a new empty database that I import and then replace the existing BE database with it. But if I simply import again to the existing BE, it starts to bloat. My question is, why create a new empty database or a template, if you can just C&R the existing BE database after import...

CJ, I am importing roughly 80K-100K records from the single Excel file. (80-100K of rows and only 22 columns) Some records are new and some no longer exist. Thus, the reason to delete and import the new. I'm basically asking Doc the same question. Why not C&R the BE database after importing...

Doc, For this small BE database, why not just set the database to Compact On Close? Or maybe that's too much, since I'm the one importing the new file, just manually C&R after I import. I suppose since it's on the network so that would be a little risking, but I do back up the database BE at...

I can download the data, from the other online program, to either an Excel xlsx file or a data file CSV. The problem I had with the CVS file is that some of the cells contain commas. Of course that causes issues when imported as a text file. So I was down to the xlsx file. maybe there’s...

Thanks for the good explanation. I will dig into the FileSystemObject link. I'm just surprised that Excel and Access don't have a better solution for this.