Hi! I have a following problem:
I have a table called Dogs. It contains two fields, Class (textual,
represting dog class) and HasTail (Yes/No, representing if the dog has a
tail).

I was wondering.  Is the return of a null value covered.
Dim rs As DAO.Recordset
Dim rs2 As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT Count(*) FROM " & _

I would like to find last day of week from year and week information.
Are there any function available to get this?
For example, I would like to know the saturday of  year:2008 and week:
20.

I'm receiving a criteria mismatch on this statement.  It worked fine until I
added the ChkSepCheck=-1 part.
It's a true false field.
Set rs2 = CurrentDb.OpenRecordset("SELECT Count(*) FROM " & _

I have a field that contains the number of hours a customer has purchased
(CE). As they complete their hours, I would like the hours field to subract
the courseHours field and give me the hours remaining. Anybody know the code?
JoAnn

I have a form that contains a name, email address, and extension.  When I
select the name from the drop down box it will automatically update the email
address and extension based on the table which is the source of the form.  
The problem is when I tab off of the name the ...

I have a form with 15 controls on it but only want to tab thru the first 5.  
Can I delete the other 10 tab stops??
Thanks

I have a form that runs a sub to connect to a remote server with the
following script:
Private Sub MLP_Proc_Click()
' declare and instantiate the object variables

I use formatpercent to format my results which works. The only thing
is it considers as a string. 100% is smaller than 2 %, but not greater
than 99 %.
Are there any workaround to sort formatpercent results?

I have a query that I want turned into a table query. Is there away to
turn off the prompts saying do you want to post #,### records and just
do it. I'd like to make a macro do run this at night, but the prompts
are making that not happen for me.

I have an unbounded text box that users use to enter worked hours and a
button that will transfer the value to a control. How can I validate the
number in the unbounded text box to make sure the numbers are of increment of
.5? In few words, users can enter from 1/2 hour to full ...

I've been researching this for days, but obviously not getting an
understanding.  I have a form where the Autonumber (I know we should not use,
but I am told to do so) is using this code on a help desk form based on one
table Help Desk Tickets; here is the code I am currently ...

I have an form that uses a criteria query.  If the criteria query is not meet
the form opens blank. How can I trap this error.  So the form does not open
at all.
Thank You

I have form with a list box who's record source is a table. It is set to
multi select. When selecting multiple rows how can I hide the rows that are
selected (highlighted) without regenerating the record source?

Basically, I have a database, currently with only a one row entry in a table.
I also have a form, with entry fields for the specific column headers in the
table. What I ultimately want to accomplish, is basically an "entree sheet"
where I can constantly input data into the table ...