I am trying to get a recordset (list) and I get the following error
Arguments are of the wrong type, are out of acceptable range or are in
conflict with one another.
Any Ideas?  The error is on the Rs.open.  I have used the same cn and rs

I am having a problem with a subform that's driving me crazy.  I have a form
"Correspondence", which contains several subforms.  One of these Subforms
"ProviderDetails" had a control on it "GrpPIN", which, whenever  I would
ebnter a value anywhere on the form, the GRPPin control ...

How do I run a SQL  query  in a VB program?
The query has the form
SELECT col1  FROM  my_table WHERE key_no = 1
It should return a single string, and I want to put the returned

I think there should be a simple solution to my problem. I have searched and
found similar questions and tried to implement suggested solutions, but to
date no success, so I am hoping you will be patient with me and help with a
question that appears to have been asked many times ...

I have a form into which users log data categorized by date and time. The
forms date field default value is set to =Date(). However, entries made on
our 3rd shift (10pm - 6am) after midnight need to belong to the previous
days date (the date on which the shift began). I would ...

I need to write a call back function for Access in VB does anyone know
where to start, cause I don't.
Thanks
DS

In Access (MS Office 2000), How can I set-up a form so that the Field is
initially blank, but for successive record entries, it retains whatever date
the user first inputted?

Does anyone know if there is an Access 2003 code builder (like the code
builder in Access 97) AddIn out there some place. If there is one, can that
person who knows where it is point me/us to it? The builder allows for quick
refs to controls on forms and reports etc, etc, etc.

I have an interesting question. How would you show a blank form every time,
althought the underlying RecordSource is pointing to a table? In other words,
I want to be able to always have the users view a blank form -- the
equivalent to "Add Record", even though the new records ...

I have a chart on a form that is based upon a query. It shows the number of
orders processed during the current day.
Is it possible to have this form periodically requery itself or am I doing
this the wrong way?

The following calculation is contained in the default value property of a
text box. The result of the calculation is not displaying in the form - why
not?
"=([Customer/Supplier Satisfaction System]![Quantity])*([Customer/Supplier

In Access 2000, I have a table with an autonumber/ primary key field.
Somehow, it has messed up its next number function.  When I add a new
record, the autonumber field is displaying a 27, when it should be putting
in someting much larger.

I'm trying to create a drop-down history list for a search field in a form.  
When a user makes an entry in this field, I want a list of the prior 10
'searches' that have been made in this field.  It does not have to be the
prior 10 entries from only that user, but all users.

Using Access 2003 - I have a combo box that works fine.  However, I would
like to add some text in it as a message for users to click there (ala the
"Type a contact to find" combo box in Outlook 2003).  
Is this possible in Access?

I am in the process of migrating the backend to MySQL and testing the
frontend with MsAccess 2000.  I need to check that all necessary data fields
are entered before I make the update on a subform by using the BeforeUpdate
event on a checkbox (Checkbox1). But the BeforeUpdate ...