I use to register the crystl32.ocx then put the active X control (Crystal
Report Control) on the form name it Report1 and write the following code
assigned to a button:
Private Sub cmdPrint_Click()

I want to assign a sequential series of numbers, 1,2,...n, to each
member of many sub-categories. I want to do this automatically with a
macro. For example, the numbers assigned to members of sub-category
"A" should begin with 1,2,3,4. However, later on, others will be added

I have a database that contains many tables with exactly the same structure.
They're a result of a monthly "snapshot" of the core data in another
(non-Access) application. Each table corresponds to an archive made on that
date, and they serve as an index into the archive files. ...

I have two tables.  One has nearly all the information I want but I need
addresses that are in another table.  There is matching field in both tables
that holds an ID number.  How can I input the addresses to the corresponding
record?  I thought I could do a make-table query but ...

Alright guys....Help me out with this one.
I am an avid Microsoft Excel user, who decided to utilize the database
functions of Microsoft Access.  I have all of the information that my
database needs in a table properly configured to release to me any

Does anyone know of any links to help new users to create a autofill form in
Access that shows step by step or video of how to do this.
I have a small database in Access with name, office, phone, fax and email.
I want to create a fax form where a combo box for name is pulled down, ...

I work for a noprofit that can not afford to get technology help. Our entire
membership system is on access database projects. I am trying to pull queries
that are our current membership base, minus any previous members ( only want
new members) as well as a query that pulls our ...

I have a customer order search form that pulls specific Customer orders.
Sometimes when I make a minor change to the customer order form, like add a
field, move a field, etc., my customer search pulls a blank order form. I go
back and put things back like they were, but I still ...

I'm using the query design view to take a list of buyers and usin
total, to count the number of times they appear...so far so good.  Th
query returns something like
buyerID1(1)

I have 2 tables, one called Plan, the other is StudentPlan
In Plan, there are 8 records, Each identifying a student "Track" and which
courses correspond to that track.
I would like to be able to populate the fields in StudentPlan automatically,

I  have set up an entry screen (form) to provide header information to print
on invoices.  The key field is also entered on this screen to extract the
rest of the invoice information from other tables. It looks like I have to
set up a one row table to accept this information, and ...

MSnewbie here, I am creating a database with customer information to include
name, address, phone, fax, etc.  I then want to create a form (e.i., fax
sheet) where I can locate from a list box (or other type of button required)
the name of the customer and the rest of the ...

I am making a strange database heres a quick summary
There is a parts list linked to a list of who we get them from
There is a module list which has a form for creating them linked to a
subform of components showing which components and adding up totals * buy

I am trying to set up tabs on a form. Following the directions on my Access
2003 Bible, I cut a form and paste to tab one, but the form shows up on tab
two also. I am definitely selecting the tab control on page one before
pasting the form. What am I doing wrong?

When you set the property Tab Stop in a control to No, should do anything
with the Tab Index.  I have several controls that I just want to show values
in but not for data entry.  I changed the tab stop to no but the index
numbers remain 0, 1 and 2.