Search results

Hi all, I'm looking for a way to check whether or not Access is online with Sharepoint. I found a post here by drjohn61 that adds a dummy record and looks to see if the primary key is a positive integer. (A negative integer indicates Access is offline). The online status is indicated in the...

after some more searching, it seems that rs.Requery would be helpful...that would allow for a record to be added by using the current recordset, but not necessarily adding the record to the recordset.... i apologize for such a simple question...it just wasn't making sense.

thank you for your response... i am doing some testing, but the database i'm troubleshooting is doing some funny things....i'm just trying to figure out exactly what the .update method does (like re-execute the query from .OpenRecordset) to determine if this part of the module is the trouble or...

I have a question about the Recordset Update method in Access 2010 VBA using the DAO.Recordset. If I add a new record using the .AddNew method, where is the record inserted? At the end of the query regardless of the sort declared in the .OpenRecordset method? And if i add a new record that...

Mr. B., Thank you very much for your response. I will definitely incorporate your suggestions....it makes perfect sense! thanks again! devo

I have some questions about working with a split database. First off...i'm using Access 2010 and am planning to put the back end on a Network Accessible Storage drive and installing Access 2010 Runtime for my users. I can have as many as 10 users at once, with 3 of them needing access daily...

I'm new to Access VBA, but have dabbled a bit with Excel VBA...i've been reading quite a bit on the forum lately...so thank you everyone for asking the questions and posting solutions!