I have to create an application that automatically writes
the values from a Form and a table to a table. I have to
do this in such a way that this automatic writing of data
is done once in every 24 hours and the values that were

I need to make a macro within EXCELL to put parenticies on text et. (2,000)

I am trying to run a macro on my database and it keeps coming up with the
following message:
'The database has been placed in a state by user 'admin' on machine 'ukpms'
that prevents it from being opened or locked'

I'm trying to copy using a Macro or any other way, data from a form to just
the clip board.  My user wants to just hit a button and have just the data,
not the field names as well, be copied to a clipboard so he could paste it
into his calendar.  I've created a macro that does ...

I'm trying to create a macro and the best i can come up with is as follows:
step 1 - Run Query (the action is "openquery" which will open a query which
is a "make table query"
step 2 - Transfer Text. This takes the table created by the make table

I have created a linked database containing several tables. I would like to
be able to automate the task of refreshing the tables then copying the tables
to create a local copy. Something to also note is that we are prompted to
login to the database we are linking to.

I need to fill out a word document with access.
I managed to do this by replacing certain [xxx] texts in the word documnet
with datas on my form.
But how can I send my query results to this word document as a table? I have

Hello again...Just a quick of the wall question...
Is there a way to force the program into full screen mode?

Hi!  I would like to add a button to an Access form that would open an Excel
spreadsheet (always in the "c:\jobs" directory) with a file name equal to the
value in a specific field on my form ("JobNo").  If an Excel file is not
found by that name in that directory, I would like ...

Hi!  I have a combo box with the following parameters:
    Name.................. Combo61
    Control Source..... JobID
    Row Source......... Job Query - By Mold

I have recorded a macro in Word to set a bookmark at the cursor
position.
I have assigned a key to this macro.
I have recorded another macro in Word to bring the cursor to the

How can I  insert a row in the table in MS- Access.

I have the following code written into an access module
Public Function RunExcel()
   Dim xl As Object
   Set xl = CreateObject("Excel.application")

Hopefully someone can help me modify an existing macro in Excel XP.  
My current macro is set-up to print-out a range of cells from a
hidden/protected worksheet that reflects information from a larger/detailed
worksheet.  For example, each row shown on the detailed worksheet ...

I received the following error message after an after update event of a
combo box on every change of this combo box. I need to set focus on the
subform so that user can input data right from there.
2110 microsoft access can't move the focus to the control Master Table