I'm using the Microsoft OLE DB Provider for Microsoft Jet
(Microsoft.Jet.OLEDB.4.0) to retrieve data from an excel spreadsheet.
(I know, I know... But I don't have control over the source data.) I
think this might not be possible but I'll give it a try.

i have a form that has required fields and i have a delete button, created by
the wizard, that has this code for onclick:
Private Sub cmddeleterecord_Click()
   On Error GoTo Err_cmddeleterecord_Click

I'll need help on what todo with this information in table...
There has to be a unique on one column (Item ID, for inventory purpose)
but in many cases that ID is not known... thus, many empty records for
that column exist in a table.

I know that subject probably did not adequately explain anything so here
goes...
I have an access file that needs to be transposed from its current format to
a new format so that I can then export as a flat file to be imported into a

I already figured out (the hard way) I need to convert all my date
parameters into USA format before executing my stored procedures where
dates are used as parameters.
(Format(StartDate, "m/d/yyyy hh:nn:ss AM/PM")

I have  a table of the structure below:
Delivery     Product
101           A
101           B

I have been using an old version of MS Access [Ver 1.10] and recently
bought Access 2000 because I had to upgrade to play on my laptop which
has Win XP. The Access 2000 program installed properly but I cannot
open the old database files. When I try I get the error message, "This

Is it possible to append records to a space delimited text file, using
Access 2000?

How many records can Access handle without obviously slow ?
will Access be affected by concurrency of too much users edit the database ?
Thx ~

I'm trying to get Access to create reports which will be sent out as
letters to a mailing list, these letters would be personalised for each
recipient, so that should they have a particular option (tick box)
selected then they get a particular passage of text inserted into the

I have a simple form that takes in a UPC code of an item and after I
enter the record, I would like to do an inner join to get a couple of
fields from another table that is joined on the UPC code and then print
a receipt. Do I do this with Visual Basic procedure after the insert

i have a form that is used to enter 4 values in a tblmonthlyunits.  they are:
salesperson (text), monthandyear (date in the format mmm-yyyy), department
(text) and units (gen. number).  i have a search button on this form that
opens a 2nd form, formsearchmontlyunits, where a user ...

I am trying to call a macro using a command file by using Windows
Scheduler.  I am able to run the command file and the macro runs
without issue if I doubleclick on the *.cmd file.  When I try
scheduling the job to run via scheduler it appears that Accesss opens(I

I'm trying to display in a continuos form some *.jpg. I have a table
with the file path, (a photo of a person). Display these photos in a
single form is very easy, just using changing some properties at the
"current" event. But if I do it in the same way in a continous form

I already figured out (the hard way) I need to convert all my date
parameters into USA format before executing my stored procedures where
dates are used as parameters.
(Format(StartDate, "m/d/yyyy hh:nn:ss AM/PM")