Hey everyone, trying to figure this one out, any help is much apprreciated!!
I have a distribution table which has no key column (I know, I know, I want
one, believe me, but for many reasons they will not put one in).  I have a
form, no control source, on which there is a listbox ...

I used DoCmd.Transferspreadsheet method to import data from several Excel
files to Access database and run queries and export the queries to Excel
reports. Our MIS department set up a secure folder and a usergroup to access
the database through a Citrix server. Suddenly all ...

I wrote this query (in access03) and then went to sql view and tried top
copy and paste it into a button's on click event
DoCmd.RunSQL "UPDATE tblAnimalBleedsStatus INNER JOIN tblCatalogPartNumbers
ON tblAnimalBleedsStatus.CatalogNumber = tblCatalogPartNumbers.CatalogNumber

I have: an obsolete Excel file.
I want: to delete the file (using code in my Access database). The file name
is known, so there is no need to use a file browser.
Any suggestions?

Hey all,
I am receiving this error when i'm trying to run a routine that I didn't
create. I know this should be a sp on my sql box but I haven't got the
resource to do it right now.

I have what I think would be pretty easy issue to fix but I'm just brain dead
today I guess.  I have a function which produces a date.  All I need is to
see if that day is a holday.  I have a table that has Holidays.. tblHolidays
containing 2 columns HolidayName and HolidayDt.  I ...

This question relates to my question on Background processing.
Why do I need to relink the tables?
When I log to the Access DB and trying to open one of the linked tables
access asks me to log to the ODBC Server. After supplying ID and Password, it

I'm using Access 2007.
I have a button on a form that opens a saved Excel workbook. I need to copy
the text from a control on the Access form, then paste it into a cell in the
Excel workbook. How can i put this into code?

I have an event table with ID's 1-26
I'm using the following command in a query to print either Label 1 or Label 2
Type: IIf([EventID]<>4,"Label 1","Label 2")
I need to change this to be able to select additional Labels based on Event

I have to export a query to csv in order to get the data into out Accounting
System.  Our system is very sensitive and it needs the data in a csv without
the quotes around text fields.  How can I get this done?

Summary: I am reading default records from one SQLServer table and adding
them (with modifications) to a secnond SQL Server table.  I get only one
record added and then I get an ODBC 3146 error on the ".Update"
Here's my Code:

I have 60 reports to which I need to add the same procedures.  I got the
code below from an old forum post by Fred.  It allows page updating to run in
sequence in a chain of reports.  What I would like to do is write the same
procedures in the same events over and over in each ...

I have a database application that I need to update with a couple report
objects.  I would like to write some code to take care of the matter.  I
thought I would create a database with the corrected report objects and
export/import them to the database on the client machine.  The ...

I am using this:
    Shell "xcopy \location\*.xls \location /E", vbhide
to move some files before they get replaced by the new daily set.  The
problem is, when I shut down my pc at the end of the day I get messages that

i wrote a VBA code myself for delete function, but its not work and show me
error message "you cant delete the database object 'xxx' while it's open".
i want to delete a record in form.
this is the code i wrote: