I am trying to convert a fairly large DB whose front end in programmed in VB, from 97-2002. However, I keep getting the error saying that the db needs to be in a compiled state before this can be achieved. I have compiled the VB code to produce a new exe, but I do not know how to ...

I'm new with Access.  Is there a limit to the number of
records you can have in the database?

I am trying to view my reports at 150% and have used the
following code at On Open
DoCmd.OpenReport "rptSubcontractors", acViewPreview
DoCmd.RunCommand acCmdZoom150

I am tring to insert some data from a form to a table:
INSERT BOOKING([Blocked Booked], [Teacher's Initials],
[Booking Date])
 VALUES(forms![SINGLE BOOKING DETAIL]![Blocked Booked],

I'm having trouble figuring this one out as I'm still VBA-dumb.  I've seen this idea here before but can't relocate it so I'm asking for your assistance
My form has a command button labeled "Delete".  When the user clicks the button, I would like to have the record no longer ...

As contributor “rkc” once pointed out to me, if I am to borrow code that someone else has written then I should at least understand what it does.  Copying, pasting, and modifying text so that the code works on a current db is one thing – really understanding how the code works is ...

Module 1 conatins 2 subs
Option Compare Database
Sub SingleAvailability()
End Sub

I wonder if anyone can give me a start on a database I am setting up
I have set up a table with staff names (first name and surname in separate fields) and details
From that table I have created a form, and a subform within it listing all training courses each member of staff has ...

Hi,
I am a new user of Access.  I am trying to set up and
inventory tracking system for the company I work for.  
I don't know how to set up the forms to track what

i have a query that extracts all users details from a table that are what i
call current users - i want to use a form to edit current users details so i
base my form on the query? so,  then - how does this info then get changed
in the table the query is based on?

Using Access 2002 on WinXP.
========================
I found a neat idea on a downloadable DB (clcontact2K.mdb from AAD
Consulting) for a Mail Merge run from a SwitchBoard.  I can see how it is

I have a button on a form, when pressed it generates an event. Whe the event is triggered, I would like to use a variable, that the user enters into a text box on the same form, to query a database. How do I do I reference the text box?
If you have time it would be handy to have ...

1. Just had XP installed and converting 97 database files
as I open them.
On some tables a column is inserted next to the primary
key fielsthat has a plus / expand sign which when clicked

Relating to my earlier post on suppressing record
scrolling on a form how do you decide whether to base a
form on a table or not?
If I have a form where a user will enter data that returns

Just looking for a good beginner reference book to allow
me to utilise the most of Access Data Project files, with
an SQL Server 7 Backend. Do I need to know SQL Server to
get by. My SQL knowledge is Intermediate and and my Access