While creating a table, in code, using 'CreateTableDef' and
'CreateField', is it possible to set the format of Date/Time fields to
'ShortDate' or 'ShortTime'?
Martin Dashper

A friend mentioned that he had received a copy of a Works database
(filename.wdb) that is basically a contact list and budget for a club.  He
doesn't own Works, and does not know how to open the file.  I tried to
retrieve it via Access and was not successful.  Anyone know if ...

I have a form that shows info for a single table. One of the controls
is a combo box that lists all the existing values in that field in that
table, using this SQL:
SELECT [Ads small version].Publication

1. Just to explain:
I have a form in my database called "Move To Production" which displays
all the "Requests" that the manager would like to move into production
off of a query. So the form design only looks like one line of

I admit first that I am not very good using SQL.  I am new to Access,
but I am trying to pass a selection in a list box as criteria for a
query.  This list box is set to Multiselect "None", so I only need to
pass a single selection to the query.  The list box is populated with

Your help will greatly be appreciated.
Have a query based on 4 drop down combo boxes in which the results are
displayed in a list box.
The user clicks a clear button to remove all combo box selections.

I have searched the groups but didnt get it work.
I am trying to filter a form with three criteria:
1.BATCH NO SHOULD BE BETWEEN XX AND XXX
2.DRAFT NO IS NULL

I'm working on a pretty simple database and i'm trying to attach a hyperlink
to a file for each record.  Basically, the user enters data and attaches a
link to the associated file with the data.  The original files are stored in
a folder on the computer hard drive.  

I have a table "customer"  which has a one-to-many relationship with
table "addresses".  The primary key of "customer" is an autonumber
field.  I have a form that displays the customers, and allows you to
add a new customer.  Also on this form is a command button that uses

I'm hoping someone will be able to help me.
I have a master/detail form that works fine.  The detail is in a
datasheet view and shows about four columns of a 100 column table.
I've created another form that contains the remainder of the fields

I have a form with fields like -
Order No.
....
OrderPackList, etc.

I am trying to embed the following query into my code:
   strSQL = "SELECT * " _
          & "FROM tblDespatch " _
          & "WHERE SalesOrderNumber = " & lngOrderNum & ";"

I have created a database that runs over a big net work some times I get a
message "Could not update; record locked" I have found a solution which is
as follows
Dim cn As New ADODB.Connection

godo day all,
    I have an frminvoices, frminvoicedetails subform, and
frminvoicepayments subform.
    When I initially create an invoice, I add the records through the

The following function is used to fill a combo box from the values of
two text boxes.  This function is called from the Record Source Type
property on the combo box.  But it doesn't update on next record or
doesn't work in data entry mode.  I looking for a way for the user to