Search results

Mine, it turns out, was easy. I thought that all of my users had full rights to the directory. Turns out that the ones with problems had "read only" access. IT set up a new subdirectory for me that supposedly everyone has full access to, but I haven't done the work to move everything over yet...

Yes, turns out it's a rights issue. IT is being mildly helpful. I'll see if it works...

They can get in to the server if no one else has the DB application open. So I believe it's a sharing issue, not a rights issue. Agree?

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...

Thank you BobLarson and LPurvis for your thoughtful replies. I think I've interpreted them correctly, and I've been playing with both of these ideas: 1) an appended table in a linked side-end local DB 2) a bound hidden form with a recordsetclone call that opens on start-up For each user...

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 found the problem and it wasn't code related. The user, for some reason, got reset by IT to "read only" status on the network drive where the back-end DB resides. Since this is the only application user in the group working on Win 7/Access 07, I assumed it was an Access version issue...

More Information: Form won't load in Access 2007 Here's more information: It's happening on the two forms that create new records. The "update" forms seem to work fine. The first form gives me the error "2105 Can't go to the specified record". The second form gives me the error "2448 You...

Would that make a difference between Access 03 and Access 07?

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()...

Wow! That worked perfectly. Thank you so much. Ruth

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...

Perfect! Thank you Bob

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...

Hi Tim, I put in the code just as you say, but get the same result. I know that it's catching the error, because I get the msgbox. But once I click OK on the msgbox, the form closes. It doesn't take me back to the missing data box on the form. Thanks, Ruth Ruth

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...