I have the statment below that turns off allow edits so thatwhen I run
the commend acCmdFind I only see the find menu rather then find and
replace.
The search button is on the parent form, however there is a subform too

When should I use a list (in table properties: like
Ford;Mercedes;BMW;Audi )
and when should I use a lookup table??
And second question: IF I use a lookup table, should I always make a

I need advice about my decision to go with Replication in general.
This post was placed on the Microsoft Replication newsgroup, but
I really value the feedback that comes from this group as well.
I have a new client who want their Excel data moved to Access.

I haven't been using Access for a very long time and I forgot everything :)
I will be very greatful for help since I have been  fighting with this
problem for a few hours...
I have three tables: Medicines (ID_Medicine, ID_MedicineGroup,

For example, a database with three tables:
EMPLOYEE(employee#, empName, empAddress, empTel)
EMPLOYEE_ON_PROJECT(employee#, project#)
PROJECT(project#, projectStartDate, projectEndDate)

I use Access 2003 and WinXP.
I have a recordset declared:
Dim regValuation As Recordset
Later, I may, or may not, fill it (for a certain csql string) like

I have 1 table:  tbl_main
primary key is a field called JobNo
1 query:  qry_main   (this simply has all fields and just places the JobNo
field in ascending order).

I'm trying to setup a macro to be able to open up the windows explore box to
access the list of my c drive folders.
What action type would i use to enable the macro to do this ?
eg   c:\program files\abc

I am looking voor a database software tool which automatically
generates unique barcodes to each contact. I should be able to manage the
contacts by reading the barcode. The tools will be used to manage exhibitors
and visitors of a trade fair.

I have an unbound main form (one side) with a subform (many side).
The main form has a textbox control on it whose visible property is set
to false.  It's controlsource property is a reference to the ID field
on the subform (so the main form can tell which record on the subform

I will have to handle a lot of really 'nice' data in a LOT of Excel sheets. It is all about music files (Billboard top 100)
I am afraid there really is a sheet for every year ... (Don't know this for sure yet...)
I definitely need to get this data in Access and get it normalized. ...

i'm a beginner to access and i'm having trouble with autonumbers.
basically i have a list of restaraunts in a table. they are sorted ascending
by autonumber (1 to 283) although i would like to browse the form in
alphabetical order, but instead it goes in order of autonumber which ...

Under Access 2003 Developer Extensions there is an aplication which is
named Custom StartUp Wizard, with the posibility to make an MDB file
without any access to the internal code, design etc...... also it is
Not possible to import from other MDB it looks like same as a normal

Hi people,
newcommer here, i know a little ms programming but am new to sage,
Is it possible to connect to sage line 50  with ms access?
TIA

I don't want the user so see a message like "index or primary key can
not contain a null value".  Instead, I'd like to use a user-friendly
message box.
I have tried putting code in the BeforeUpdate Event to check if the