Search results

I have a database that is split between a front and back end. The BE is on a shared network directory. Each user has a copy of the FE on the local (C: ) drive of their computers. Users only have access to viewing pre-programmed reports. They are not changing objects. Some users are getting...

I'm wondering if this would make my Access 2003 application run more efficiently: In background, when a user opens the application, I would like to run a query that pulls pertinent data from a join of two large tables. I would like that query stay open throughout the session (instead of having...

I have a bound data entry form which works fine in Access 2003 but won't render in Access 2007, and gives the error message that there is a problem with the OnLoad event. The OnLoad event simply sets the focus to the first data entry field: Private Sub Form_Load()...

This should be easy... On opening a continuous form for editing existing records, I want the cursor to land on the first record without a specific field filled in, so that the user can update the field without having to scroll down to it. It appears that the code below is moving all the way...

I'm using a msgbox to ask the user if they want to save changes in a continuous form for editing existing records. If they don't want to save before going to the next record, I have the acCmdUndo line in the code. It doesn't save the record and it sends the focus back where I want, but it...

My form/subform represents a contract with multiple individual line items for amounts to be spent on different projects. The goal of this form is to add more line items to an existing contract. The main form displays the contract header information (for tblContract); the subform is for entering...