Search results for query: *

We have a MS ACCESS database in shared directory, there are over 10 users to use it. One user try to open this database, get error: "Can't open Accounts.mdb. It is in use by other user" but other users have no problem to open the database at the same time. This user have 'Access...

In the below queue, I use a format function. The query read like: ********************** select Format([setup date],"mmmm dd yyyy") from accounts *********************** I got error: function isn't available in expression in Format([setup date],"mmmm dd yyyy") How do I...

Within my mail merge document, For example, Each account has 1 or more managers(maybe up to 40 managers). The document template is as below:( <<next record if>> means if the next record is not blank, then add next manager's name) ****************** <<manager>> <<next record if>> <<manager>>...

I defined objWord as word.document when I set objWord.SuppressBlankLines = True, I would assume the blank line in the merged word document will be suppressed. in fact It is not. What does .SuppressBlankLines means?

Within my mail merge document, For example, Each account has 1 or more managers(maybe up to 40 managers). The document template is as below:( <<next record if>> means if the next record is not blank, then add next manager's name) ****************** <<manager>> <<next record if>> <<manager>>...

I have a word document, having mergefield called <<manager>>, It will show in the document few times. Can I set bookmark on this mergefield <<manager>>? How can I do it?

The Access DB is used in 12 users shared environment. I have a macro which run code to insert record into table. Since multi users could run the macro at the same time. Is there any way, that I could give messge to the user &quot;Please run it later&quot; if the other user is running this...

I create a module function to run a query. ************************ Dim Db As Database Dim RST As Recordset Set Db = CurrentDb Set RST = Db.OpenRecordset(&quot;qryTEST&quot;, dbOpenDynaset) ********************** the query 'qryTEST' has a parameter, like select * from account...

I have a queryA select AccountID,name,Manager from Account where AccountID = '007' the results is ================================ AccountID Name Manager 007 TEST Joe 007 TEST Mary ================================ In fact what I like to have is: if this...

Let's say, I have a file named &quot;test.xls&quot; located in directory D:\Project . Within MS Access, at first step of my macro, I want to delete this file S:\Project\test.xls . What is syntax for this or what is the command I need to use.

I try to merge word document from ACCESS. Every thing looks good. but because my access database have security set up. so everytime I start to run macro to start mail merge, It pop up a window to ask you userid and password. I wonder is there any way I could hard code in the VBA code. My...