Is there a way to invoke the standard Windows font picker dialog box in VBA?
I've used the file open/save boxes before, but never the font picker.
TIA,
Joe

I am exporting a table using the TransferTextMethod:
DoCmd.TransferText acExportDelim, "File Specification Name",
"Table/Query Name", "Path"
This works fine for exporting the extire table, but it overwrites the

when i click a button on my mainform ("Screening Log (Edit Only)") whose
purpose is to add a new record on a linked/child subform ("DaysView) which
increments the value of a control by 1 (to chronicle the Visits being entered
by users), it results in the following message:

I have a form in which I want to filter by two combo boxes. one is working
fine, but the other one is not.
"Hrs Status" is a calculated control. Here is the control source =IIf([Total
Hrs]>=40,IIf([Estimated Hrs]>0,"Done/Unapproved","Done"),"Missing")

I cannot get my form to allow the user to add q new record.
This is a continuous form.
I have set the allow additions to yes, but still not able to add a
record?

I hope some one can help me im not a good access VB expert i have found this
sample DB that uses AES encrypt but i need to change it a little to do what i
need but i don't know how. I'm sure for a VB expert it should take not more
then a few minutes to change it I will gladly ...

...[mdb] can't find.
This is strange! I have the following code:
If Not IsNull(Me.txtMSDSID) Then
id = Me.txtMSDSID

What is the syntax in Acces VB  for showing and hiding a form?
I've created free standing VB applications before. The syntax
was simple:
   frm_MyForm.show

Can I do this? Have multiple fields be returned in a DLookup function?
=DLookUp("[LastName]" & "[FirstName]","Offender","[SSN] = '" & [Forms]![Edit
Offenses]![cmbSSN] & "'")

I have a form with about 60 yes/no check boxes on it. I need to have
different yes/no boxes related to others. For instance if one box is checked
then another box cannot be checked, or if this box is not checked then this
other box cannot be checked. I need this to have some type ...

I've created a form, and can run it.  I'm having
a few problems, though.
How do I disable resize for the form?
At the bottom of the form it shows the control

I keep getting error message "Only comments can appear after End Sub etc..."
when I try to run this script. Would appreciate any help! Am not a VB
programmer.
Was given this script to use.

I need to do the following:
1) Count all of the [CALL_ON] = today's date.
2) Separately count [CALL_ON] = today's date AND ([CALL_RESULTS] = "Message"
or ([CALL_RESULTS] = "CO"

can any body please tell me the math function in acces for X^y (x to the
power of Y)
many thanks in advance

Is it possible to manipulate a msgbox in code? Instead of manually clicking
"OK", I would like to do it in code. Is that possible in Access97?
Jonathan Scott