I have a table with many columns. Two of them are VehicleNumber and
ShipDate. What I would like to do is sort all the data in ascending
date(ShipDate) but I also like to group the matching VehicleNumber
together at the same time(If they have same ShipDate; please note

When i load my Wise packaged software onto xp home I have an update
qry that will not fire until i close and reopen the computer.
As a test I have placed a button on a form and removed warnings. i get
the first message that i am about to append a record.and then thats

Is there a way to set up an import with the push of a cmdButton that 1st
asks "Please select the File" and allows one to browse for it?
Or, is there a way to prompt for the File Name to import?
Stumped,

I have a database of links to bitmaps, eg c:/pic/001.bmp, and I want
to display the pictures in a report. Is this possible at all?
Thanks for any info,
Tony Lennard

I'd like some suggestions on a db design.
The data source is pretty simple.  I'll be importing from an excel
spreadsheet.  There could be 4 to 12 rows, and there will always be
the same amount of columns as rows.

I'm trying to modify an existing db for someone who wants to set
appointments in a customer db. They want to prevent someone from
double booking appts.
I've developed a few lines of code to do this, but I keep getting hung

I've made an Access front-end using SQL-server tables. No prob so far. Now
I'd like to create some vbs-scripts, in order to do some updates to the
tables. Running from the Acces-db (vba) it works fine, after adding the
reference. However, from within vbs, it doesn't work at all. The ...

Is a split window possible for an MS DOS program and MS Access program?? If
so how???
When you run a DOS programn it covers the whole of the PC screen and if you
have other applications you cannot see them in the task bar and you have to

I've posted this message over at the ms-sql newsgroup – no luck.
Maybe some one here could help.
I have an Access application with linked tables via ODBC to MSSQL
Server 2000.

Just upgraded my old Access 97 DB to Access 2003.  It is on a shiny new XP
Pro box.  ON the new computer there is my domain administrator account and a
regular user account.  If I open the DB in the Admin account, everything
works fine.  If I open in the User account, I get a ...

I (think) I'm done designing a "Log in Sheet" for a database and need
to import the old Excel file that has ID numbers already -
How can I clear the autonumbering in the database so
1. the imported numbers will be the same as in the Excel file

I have spent all day trying to use MS sample code AddAllToList()
I have followed the instructions exactly but the combo box is always
blank.
If I change the RowSourceType to table/query I get a list (obviously

I am trying to use the following "Elookup" function on a query that gets 2
parameters from an open form.
?eLookup("[MatEst]", "qryWOLPCMatEst")
Returns the following error.

If I have a table of 50 records and I manually delete the last 25 and all
related records are cascade deleted, is there a way to get the next new
record to begin at 26?
Thanks!

Can anyone explain why the string
"C:\Program Files\WinZip\wzunzip" -t ZipFileName
does nothing[1] when run via the Shell function, but
cmd /c "C:\Program Files\WinZip\wzunzip" -t ZipFileName