Search results

Hello All, I've built and implemented an Access 2010 application for a corporate client. It's entirely menu driven, with no user access to the navigation pane. It's split with multiple BEs on a share drive and the FEs on individual PCs (distributed via Auto FE Updater). Two hundred users...

Hello All, Our database was corrupted so that I can't open it. Had to restore from previous night's backup. What I want to know is which user may have left the database in a Suspect state. I understand that the log file contains this information but I don't know how to access it if the...

Hello All, I have an unbound form with an associated report. When the user hits the 'print' button on the form/screen, the report is launched in the background. In the On Load event of the report I populate the report fields from the forms field as so: Me.txtAddrMainLine2 = "NAME " &...

Hello all. In Microsoft article 291264, it says "In a run-time application, the front-end and back-end databases must be stored in the same folder." Is that really true or am I misconstruing the article? I want to use runtime clients with a split back end on a share drive. Thanks.

Hello all. We run multi-user Access 2010, split, on the root of a Windows 2003 share drive with a mix of XP and Win7 clients. Seeking opinions. There's an older MS article (889588) that recommends 8.3 file naming convention for faster performance. Given that Access now has 4-letter...

Hello all. Using Access 2010. Trying to convert global variables into Tempvars. The first set of globals I converted work fine. I refer to them in code as so: TempVars!lngProviderProgramAutoID = Nz(Me.PRV_PGM_AutoID_Programs, 0) And similarly: TempVars!stTeamMember1 =...

Hello all. We have a 2003 mdb running with about 20 users who have Access 2003. It works fine but we're changing to a new application that's more secure and that runs on Access 2010. The question is, can we go ahead and upgrade the users' PCs to Access 2010 now, and let them continue...

Hello all. I'm getting this error on DoCmd.RunSQL stSQL statement: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. (Error 3129) My stSQL is program generated but Debug.Print shows this as the resulting string for runSQL processing: INSERT INTO...

Hello all. Anyone know how to disable the annoying VB Editor message that says: "This command will stop the debugger"? Thanks in advance.

Hello. Wonder if anyone can advise how to turn off the dynamic compile editor when doing routine coding. I cut & paste a lot. When I go to copy something in order to paste it into an unfinished VBA statement, I don't want to get the annoying compile error. Thanks in advance.

I have Access 2007. Developed a system for client base that runs some 2003, so created the database in 2003 format. The system mostly works fine for the 2003 folks but some issues with subforms. The filtering doesn't work and a subform will lock up after a user uses nav bar to scroll right...