Since Yesterday I can see my own post in this group, 2 user said that
they read me
Sorry for any inconvenience
Regards,

I want to create an internal batch number for our company. I want it to
consist of the month number, year as a letter followed by a sequential number
(auto number).
A = 2007

I have a combobox with the following code:
Private Sub Combo24_AfterUpdate()
   ' Find the record that matches the control.
   Dim rs As Object

I am using a sub form in my form.  I need to know if there is a way to use
information on the subform to auto populate a field on the form?  I have a
report name in the sub form, I want a validation question to populate on my
other form based on what the report name is.

I keep having this problem with using the "LifeCam VX1000" and Windows 32
bit Vista home basic. I updated the software and it said on the box that it
worked fine with Vista 32 or 64.
Everything that I use with the software for LifeCam VX1000 is working fine

the database opens with a switchboard screen and doesn't provide access to
all the database tools so I can make changes, open tables, etc. In Access
2000 and 2002 you would hold down the control or shift key when you opened
the database and it turned off the switchboard control ...

All the tables are on the server's BE.
Each user has a copy of the FE.
I'm using the following queries to get a value (table 1) based on the
currect form's InventoryID

Hey, I have made a macro that starts a sql commando that deletes a post in a
table. When running the macro, can I disable the dialog box popping up and
asking me if I want to proceed deleting the row?

Is there a tool for converting Microsoft Access Queries & Forms to ASP
so you can put it on the web?
We have an Access database with a half dozen tables, plus a number of
queries and forms.

Hello
I have a form and with 954 records on and sometimes want to filter to
certain records,is there anyway when i found a record and want to filter
again to another,not have to shut the form down and go back into edit the 954

Is there a "neat" way to delete records which are duplicates as defined as
equal in a particlular field.  I can do it with VBA but wonder whether it
can be done in SQL.

I always get this error "extra ) in query expression" when I run my query

I have a table with about 20 fields, one of them being "Analysis
Type".  There are 6 of these types.  I then have a form in my self-
made switchborad with 6 command buttons, all allowing the user to
choose which type of analysis he wants - which then leads to the

I have a field in my table called "Status' can I add another field to my
table that gives a date and time to when I changed the field  in each record
in Status, [Status] being a text field options Active;Finished .........
thanks for any help with this..Bob

-- How do I add the running totals from sheet I to sheet 2  what is the
formula for this please
Kind regards
Noel R