Search results for query: *

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

...= "Save this Report as Snapshot Format" msaof.strInitialDir = strSearchPath msaof.strFilter = MSA_CreateFilterString("Snapshot Files (*.snp)", "*.snp") MSA_GetOpenFileName msaof FindSnapshotReports = Trim(msaof.strFullPathReturned) Exit Function...

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

...Dim rst As New ADODB.Recordset Dim strCriteria As String Dim msg, style LockRecord = False strCriteria = "SELECT * FROM Locking_Table WHERE TableName = '" & strTableName & "' AND RecordID = '" & strTableKey & "';" rst.Open strCriteria...

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

Look at my previous post. I note you are using ".range" but my working code does not. I also "select" the bookmark first.

Search in the Microsoft Knowledgebase for - +error +5941 +bookmark There are some results that could help you identify the issue. Also maybe not related but I select my bookmark fields differently i.e. With objWord.ActiveDocument If .Bookmarks.Exists("LetterDate") = True...

Have a look at thread705-1249866 - this works.

This is the code I created for sending data directly from Access into a word document without using the Merge. The purpose of this was to allow the Access application to not only have customer billing and payment transactions tracked but also customer correspondence. I have not included all...

Give me a few days to hunt it out and create a version without actual client data. Will try and get done this weekend.