Search results

That works just fine- thanks! Dave

Is there a way to make some records in a table read only? Thanks, Dave [12 days until retirement!]

tblClassSurvey is the table I want to update from the form

I want to take a field from an open form and change a value in the underlying table based on that date- Table.tblClassSurvey.period.setvalue=Forms!frmTabSurvey!CompletionDate The form field is a ShortDate The table field is just the yyyy-mm datepart Thanks, [Down to 2 paydays left before...

FIXED! The problem was reserved chars in the field names. But having followed all the uggestions in the post, it now runs like the wind. It worked fine with a single user but no when more than one. I have been using reserved chars in Access since 1996. I know to bracket those fields and it...

Double-checked for indexed fields; Changed all Subdatasheet Names to none; Created a persistant form; Created registry entry for "Sharing Violation Notification" Tables are on the LAN- Front-end on individual PCs on their C:\Drives After all the changes today it still runs much too slowly to...

Got the persistant connection working and the form is now hidden [missed one comma].

There are only a few hundred records in the db

What if you omit "acNormal" from the parameters? No Change Still trying to get the persistant to work-

gemma-the-husky Adding the sharing violation entry had no effect-

I am going through the suggestions offered- When I create the form for a persistant connection I used the code: DoCmd.OpenForm "frmPCBE", acNormal, , , acHidden When opening the new form it is visible??

I finished my work [I thought] on my latest 2007 database. As soon as a second user fired it off response time went WAY beyond usable. I split the database with the BE on the network and installed separate copies on three local desktops. Performance didn't change one iota. When a second user...

Bob, as soon as you posted I realized tat I have a module already- just copied that into the current project and it worked fine. Thanks, Dave

Trying to capture the user name in an append query- using RB: Environ("UserName") in a query row errs out Help, Please? Thanks, Dave

I need to open a form and display the last record created. I tried this: DoCmd.OpenForm "frmLocalRecords", , , "TrackingNumber=max()" but all it does is crash the application... any help, please? Thanks, Dave

Thanks, I will go read up on DMax. Dave

I need to open a form to the newest record - the largest TrackingNumber. What is the cleanest way to do this? Thanks, Dave

Thanks again, Bob. 7 paydays left :) Dave

The syntax I asked about here in this forum, for a filter, won't work with my if statement- What I am trying to do is run code if the case status is any status except closed OR with no date in the date completed field. This code won't run correctly: If "[CaseStatus]<>'Closed' or NOT...

The best way- so I will work on the table and just add a new entry. I added the code that I tried so you folks would know that I had tried to make it work on my own. I have been working on this database for a little over two months. My questions are getting closer together becaus I am down to...