Can I store a variable in access (variable x), then write a word macro that
says "if variable x = "blue" then type "blue"?
If I can, please know that I don't even know how to store a variable in
Access, so I will really need help.

I have a database that houses about 15 reports.  Each of these reports has
about 6-7 queries underneath it.  So when I have to make a change...I have to
go backwards from the report source, to the query, to the query beneath that,
to the query beneath that, to the table beneath ...

I want to be able to use the DCount function with a variable.  I have
tried a few different things but I can't find the right formula.  Here
is what I have:
cntnumber = DCount("[TikSym]", "tblCurHold", "[SecIDauto] ='" _

I want to take the path of a linked table from one database and pass that
path to another so I can link that table there.  Anyone know how to go about
getting the path info from a linked table?

I have 41 tables. I would like to append the data in them to one table. I
don't work with arrays much, but would like to get around writing tons of
queries. Can someone take a look at this and tell me what I am doing wrong?
Public Sub FillArrayandAppend()

I am creating a custom ribbon and would like to limit the commands available
to a few report printing and exporting options.
How can I show a big button for Close Print Preview like on the standard
Print Preview Ribbon?

I  want to place a control on my form which will calculate the number of days
from now until a specific date in the future - always the same date in the
future, in this case July 5, 2008. Not sure how to achieve this. Help?
Thanks.

dear member,
I want to write result comparison table1 between table2 and result must
write in table2.
1-table1 has item1 and qty1

I have a CSV file that is updated overnight and stored on our website.  Since
I cannot link to this file in Access I'd like to copy it locally using VBA
and then link to the local copy.  This is so I can remain up to date without
having to manually move the file.

I'm trying to use a form on two different forms and return data into the
form that opened it.
How do i find what form opened another form?
Thanks.

Hi all you smart people.
I have an Access 2003 database.  We have a number of users that have Access
installed and we have a handful of users that are running this database using
the run-time deployment.  This has been working fine since mid-summer.  Last

The dates in a text field are all 6 characters long,e.g., 060107, 1019/07.
060505, etc.  Some dates also appear as 000OCT, 000AUG, 000SEP, etc.
I'm trying use sql code to extract records from a database.  The code is as
follows:

What code do I write when I want my main menu form to check for a file before
it opens if it cannot find the file it should not open ? for Ex. check if I
have the file C:\Windows\Sample.txt if it cannot find if it should not open

I need to refresh links to external Database on the start of Access.
This process takes time (10 - 15 secs). In meanwhile, I would like to
display spalsh screen  with some animation (kind of a progress bar). I have
worked out all the details of this aniamtion, the only probelm ...

I am attempting to Populate a Form (Project Log Q Summary), based off a query
(Project Log Q Summary).  The Query is based off a table (Project Log).  I
would like to have the user select a combo box (cboAuditorName), choose the
correct ID, and have every record associated with ...