I have a subform (datasheet) that will be used to enter the length
(hh:mm:ss) of mobile calls.  I then want the values in that field tallied up
and the total to be used as the value for a control on the main form.  So I
have created a text box called txtCallDurTtl and set its ...

Hoping someone can help me, I am in the learning stages of SQL and VBA.  
I've been using Access for quite some time now (since 1998) and have limited
knowledge of SQL/VBA.  Thus, HELP.
I created an unbound form, full of text boxes (named txtPO1_1/2/2005,

Trying to implement the fancy tooltips from Stephen Leban's site, I ran
into a little problem...
Basically, it's due to the fact that the Access listbox control doesn't
have their own windowhandle exposed so Stephens code uses a couple of

What would be the best way to secure data on forms? So that no one
accidentally erases or modifies a record.
I thought about using 'Edit', 'Save', 'Cancel', 'New' buttons.
But how would I mostly effiently code this?

I am having a problem figuring this out. Any help?
I have a table with the following info..
serialnumber
ESN

I have a Main form named frmContracts.
It contains a Tab Control named TabMain.
One of these tabs contains a subform named (frmformwork) which is also a
tabbed control.

When we reached the end of "activation," we noticed that our e-mail address
was inaccurate.  We therfore did not get confirmation from microsoft about
whether or not Office was activated.  How do you tell?  What happens if I try
to activate again?

Hello;
I wasn't sure where to post this so I'll try here too...
I am trying to figure out how to use the results of a select statement as one
of the values in an insert into statement...I am unclear on the syntax...

How would you go about determining if the current record on the form is the
firstrecord?

I have combo box on a form with the following setting
the row source =
SELECT Vend_address_Q.VEND_SHRT_NM, Vend_address_Q.ADDR_LN1,
Vend_address_Q.CITY_NM, Vend_address_Q.ST_PRVCE, Vend_address_Q.CNTRY_NM_T,

I want to keep a log of who used my database and when. I can record the user
name in the txt file but the date is written to the file as a series of
question marks eg “??? ?? ?”
Dim f As Long

I have a txt field where they user can enter a number.  I have the format
property set to General Number.  So it they enter a letter, it tells them it
is an invalid value.  But I don't want them to get that far.  As soon as they
hit the alpha on the keyboard, I want to either not ...

I am trying to generate reports by quarters and FYD by using an option
botton.  The person will select the certian option the select two certian
style of reports that will generate.  I have set up all the queries and
reports for each option.  In the report button I have created a ...

I have two users, using same front end, that try to update the same record at
the same time. The last one in gets the runtime error message '2448', 'you
can't assign a value to this object'. I understand why I get the message,
record locking is turned on and the record is locked ...

Hello again;
Got another one driving me nuts!  Here is what I'm trying to do.  I have a
table that keeps a history of Contact Dates.  On my form, I have a combo box
which is resized so the it simply looks like a down arrow next to the history