I have a table (tblQueue) that consists of a composite PK of the fields
[Q_ID] and [TODAY]. In this table, When a new year begins I would like [Q_ID]
to start over again at 1 (This field is an AutoNumber field). Since I am
using a compisite PK will access allow me to do this? I ...

I am using Access 2007.  I tried to utilize the code at this site:
http://www.databasedev.co.uk/disable_shift_bypass.html
I created a control button and associated some code with the button.  When I
click the button I get the following message:

My second visit in one day to the fount of all knowledge ...
Access 2003/Windows XP, have a form/subform where the user can flag selected
items in the subform, then pop open a batch actions form, set parameters, and
run any of several batch actions on the flagged records.  All ...

I have an Excel(2000) macro that opens another Excel workbook and deletes
specific rows across several worksheets based on date field.  If I run the
macro from Excel only it works.
I had Access 2000 that I used a module to open the Excel macro sheet and

I am attempting to write an expression in a field that uses Datepart (y) and
2 user numbers and 3 user letters and 2 more user numbers as part of a Form
identification field. I can't seem to get the expression Right. An example of
how I would like it to look is as follows: ...

The following code produces the desired count of records when the
[PermitNumber] is <10000. It produces an error "type mismatch in criteria
expression" when [PermitNumber] is 10000 or greater. "most" is determined by
the length of the current Permit Number. Permit Number is a ...

dears,
how to make an (field control ) on a form bound control to non editable
after update?
please advise

how to use transferdatabase method to import an object from another password
protected databse , when i used the code it is importing the need but
prompting for password each time but i don't want the user to know the
password

Hello, subject explains it all. I'm interested in hosting a small form
created in VB.NET 2005, 2008 into an open instance of Access.
I've imported the OLB as DLL and referenced it, although I'm not sure how to
access an already open instance of Access. I've fetched the window ...

Is it possible to get the contents of an ADO recordset returned as XML
without first persisting it to file?
I would like to pass the contents of a temporary table in Access to a SQL
Server stored procedure string parameter via XML.

Hello all.  I've been unable to build a string to suit my purpose.  Here are
the details.  I have created a combo box, in the header of a form that is
unbound.  The purpose is to be able to search for an address when you don't
know all of it, maybe just the street...  the query ...

Hello, I am working on a DB and tried to back it up.  I made a copy of it but
when I open that copy I get an error saying that the VB in that application
is corrupt and I'm not able to open an tables, queries, or anything.  When I
try to investigate the error a little further it ...

I need to move data from Table 1 to Table 2 and can't figure out how to do
it. Perhaps someone can help me.
Table 1: has 3 fields
DealerID    Car       Color

I want to run the spelling command only for the textbox that has the focus.
Does anybody have an idea on how I can do this?
Thanks in advance
Michalis