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

This is just a independent query in MS Access, Yes I did use 'AS Setup_Date' select Format([setup date],"mmmm dd yyyy") as Setup_Date from accounts One thing I noticed if I check a reference 'Microsoft data Formating object library', then I can run this query. The database exists a...

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?

Any ideas on this? or I couldn't do this.

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?

Any thoughts on this??

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

Any ideas?

Those info will merge into a word document. If manager field, I need the 2 managers name in one place within one page, otherwise the word document will be merged to 2 pages Any means, I need to write a query that could merge 2 records to one record.

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