Ho bisogno di aiuto. Devo inserire un bottone collegato ad una query
in un grafico pivot ma non ci riesco. Qualcuno mi sa aiutare??

I don't know how to create a directory?
I have a syntax error on the createFile line and I am trying to create the
excel file if it doesn't exist.  This is urgent.
If you can help, thanks in advance.  Janis

I have a couple questions:  First, there is a syntax error on the createFile
line????  What I want to do is create an Excel file.
The second question is how do you create a directory?
Please help

I have an access database linked to sql server database. The name of the
tables are:  dbo_Student, dbo_Score etc. There are altogether 20 tables. How
does one rename the tables programmatically by taking out the dbo_  prefix
from each of the tables. Thanks.

i can open an excel book from access vb.
i can insert a row at the beginning of that book.
how do i put a specific value in cell 1 of that inserted row?
thanks for your help

OK what im am working on is a set of forms. Each of the forms is linked to
the same table, and each form has different columns from said table. So You
enter a name and date on form one and hit next and you should be looking at
the questions for the record you just entered. But what ...

The .MoveNext takes me to the deleted record.  How do I get rid of this
record?  I thought the .delete also removed it from the table, but it doesn't
until I close the table.
Here is my code....

Each month we have to create a database that is meant as a refresh from
another database soure.  As part of the qa to ensure that the Access database
was created correctly we verify to ensure that the tables within the database
have the same field definitions as the prior ...

I am having a problem creating a function that count the number of holidays,
from a table, that appear in a date range.  I have Dim'ed BegDate and EndDate
as universal variables in a separate function.  I have used code that I have
seen in various other posts.  Will someone ...

I would be very grateful for help in debugging this sub routine which is
supposed to add a record to an SQL table. Running this gives me Error 3219
(Invalid Operation). The error occurs at the line that includes "Set myrs =
.OpenRecordset"

Can anyone look at my code and tell me what's wrong?
It all works fine until the last step which is docmd.transfertext exporting a
variable table name
At the end when i try to export my file, i get a run time error 3027 message.

I have been using a Public Variable in a Standard Module to save the hassle
of having to pass a variable (generated in one form but used in another)
between the two forms since the old form closes as the new one opens.
I use the variable (called WhereString) several times while I ...

Hi I have on a form something that resembles this.
A   B   C   Average
1   1    1     1
2   2    2     2

Hallo NG
ich habe eine Funktion geschrieben und möchte in einem Formular einen Wert
aus einem Recordset erhalten.
Ich habe in der Tabelle die ich mit dem RS öffne verschiedene Felder und je

On a form that the user is working with there is a control named 'ToCompany'.
When new information is entered into this field I am trying to append it to
a table named 'CustomerData' into 'CustomerName' (after update event).
DoCmd.RunSQL "INSERT INTO CustomerData" & "CustomerData ...