Recent content by payback

Have a look at - http://www.allenbrowne.com/ser-53.html Lots of good utilities and assistance available on his site.

This really works well for me. http://www.dbforums.com/6274786-post19.html

I agree with Joe. I have been developing in Access since 1997 (currently in Access 2007) and recently did a review of a client's needs looking at many options including opensource software. Although it is going to be hard to "teach an old dog new tricks", I have recently started to teach...

Have a look at the NOCOUNT option in the SQL documentation.

Have a look at this thread - thread181-1283568. I use it sucessfully every day.

Is it possible that the developer has hidden all these things? Try TOOLS -> OPTIONS -> and on the VIEW tab select SHOW HIDDEN OBJECTS

I use a locking table and appropriate code to - 1. Flag the record as locked when the first user accesses it 2. Keep it "locked" and let anyone else who tries to access it know that they can not 3. When the first user as finshed with that record, "unlock" it I know that Access etc. has its own...

Have a look at thread181-987955

Is this what you need? Function FindSnapshotReports(strSearchPath) As String On Error GoTo Errorhandler Dim msaof As MSA_OPENFILENAME msaof.strDialogTitle = "Save this Report as Snapshot Format" msaof.strInitialDir = strSearchPath msaof.strFilter =...

Will this achieve what you want? It is a Select query for a SQL database from an ADP. SELECT TOP 100 PERCENT ID, Description, ISNULL(Address1, N'') + ISNULL(N', ' + Address2, N'') + ISNULL(N', ' + City, N'') + ISNULL(N', ' + State, N'') + ISNULL(N' ' + ZipCode, N'')...

Another idea which I have used successfully. It was originally designed to specify a particular printer for warehouse picksheets. First when starting the Access application, I save the user's default printer. Then I ask the user to specify a particular printer that they want to use for the...

Sorry for the long time in replying. I have a table set up called Locking_Table. The fields are - ID Autonumber Table_Name Text Record_ID Long Integer User_Name Text When_Locked Date/Time In each form where I need it, in the form's Open event I have - 'Check to see if record...

Sorry, I meant VBA.

I use a lock table and prevent any users from opening a record that is already opened. It is written in VB. Let me know if you need some ideas.

Is your ADP using ADO (default) or DAO? You can have both if you want. Your recordset is using DAO syntax and you might have to either change that to ADO or set the reference to DAO also. What exactly is the error line? Apart from this type of problem and minor syntax like removing rs.edit...