Im trying to compare a date in the where part of the sql.  The reson for this
is to pull up a recordset based on the date on the form.  Thank you in advance
Here is my code:
Dim cn As ADODB.Connection

I have a button run SQL to update a small local table that holds user
settings.  Every time it runs though, it gives me the Yes/No dialogue:
"You are about to update 1 row(s)" "Once you click Yes, you can't use the
Undo command to reverse the changes.  Are you sure you want to ...

I am trying to create an Access database to record our employee timecards and
compute wages and overtime.
Our timesheets are a little confusing because we are a tour company and our
guides and work 1, 2, or 3 tours per day, with time off in between.  So I've

I would like to add an object (TerminalRate) into my Form. However, this
object does not exist in my field list. This object exist in a table called
system. How can I reference this in my form.

I need to count the number of results of a query in VB Code.  I'd like my
code to look something like this:
if numresults(query1) = 0 then
  msgbox "You are missing information.  Please fill out the form completely."

I have nested datasheets inside a subform control - that is, there is a
main form, with a subform control, and in that is a form that is only
allowed to run as a datasheet, and it has a subdatasheet. What's not
good is that the verticle scrollbar for the parent datasheet does not ...

 I have a form/subform setup where on the main form there is a field called
terminate.  when this field is set to false, i want the subforms to allow
additions/deletions/updates etc.  but when the field is changed to false i do
not want additions/deletions/updates to occure.  i ...

How can I delete a record in a subform from a button on the main form?
What do I need to do?

I have a main form, with a subform in it. The subform pulls a recordset from
a table and displays it, blah blah blah.
When I close the main form, I have a specially designed close function for a
few extras, but I need to add one thing. I want to check if any of the

Does anyone know if there is any way to set up an input mask that won't allow
the user to put a carriage return into a text field?  They have to be able to
put as many alpha characters or numeric chars as they like.  Or if anyone has
a better way to do this, I'd appreciate it.

Need more help in my database, this time probably an easy task :
I input digits into a field called [Input] in one form. I have made a button
that open a different form with a filter where a field from the new form
called [PhoneNo] is similar to [Input] from the previous form. This ...

I'm trying to learn better code - the code below in a subform Open event
works but i want to improve it -
Also i haven't been able to get it working when the Where code is text vs.an
integer

I have accomplished this several times, but something must be different
about the latest two cases.  And it is intermitent at best.
I have a main form that opens.  On the on_load, ( I have tried on load, on
open, on current, and on activate) I set the record source of the sub form ...

Hi, I've got a text field that can accept 255 characters. I'm using text
because I want the field to behave in queries.   I would like users to see a
countdown of characters as they are keyed in i.e. str=255-Len([Description])
& " Chars left"

I have a form with 3 subforms. How do I change recordsource on subform3
after update of combobox on subform2
Mainmenu
SubForm1