I have a form with hyperlink fields in both the header and detail sections.
The hyperlinks in the detail section are bound to the form's data source (a
query) and they work fine.
The hyperlinks in the header are unbound, don't work, and are filled with

I have a form that contains a tab control.  I would like to insert a
hyperlink on the first page of the tab control that will move to a different
page on the same tab control.
Any ideas?

I have a table with a yes/no field and on a form I want to search by that
field.  If I set the textbox data to value and put yes, No the textbox
displays Yes or No as it should but the search fails.  If I put -1, 0 as the
values,  the search works as it should.  Isn't there an easy ...

I have a form (frmMaintenance) with a checkbox on it. I want to be able to
change the default by looking at a table (tblSys) and setting the default
value by getting that value found in the table. The description field will
either contain =Yes or =No depending on what I am doing ...

I have a database which has a table with rates which change periodically.
What I want to do is pull the rates from the tblRates table into a tblJobs
when I create a new job with the frmJobs.
I know that I can do this with an append query, however some of the

After some research I have found the maximun number of controls for the
life of a form is 754.
I do not currently have 754, but I have added and deleted a number of
controls and have reached that "magic" number apparently.

When I close FormB I open FormA with an event procedure triggered by the
'Close' event of FormB.  Works fine.  The problem is that when I switch from
the View mode to the Desigh mode FormA opens as if I had closed FormB.  How
do I prevent the unwanted opening.  Will selecting a ...

I'm unclear on the declarations for coding of MS Graph
I've seen
Dim MyChart As Object
Set MyChart = Me.ChartName.Object

I have a data entry form that displays in datasheet view.  I have a checkbox
field called Issue.  When the Issue field is left UNCHECKED I want a date
field named Completion Date and a checkbox field named FollowUp to be
disabled so no data entry can be inputted into those fields ...

when i close a form without the previous form still open it brings up an
error and asks the user to debug is there an if statement that when the user
closes the original form that checks to see if the secondary form is still
open and closes it down  

Hope everyone had a nice Holiday. I have an InsertFile command that works
well and inserts the user selected file into a field called FileName.
However, I want to make sure that the file name does not have any spaces in
the name. If it does, I would like to disallow the entry and ...

I use this method to create a new field in a table. This field had
yes/no datatype. The "fieldname" is the name of the new field i want t
add in the table.
AppendDeleteField tdfApp, "APPEND", fieldname, dbBoolean, 1

I am using ver 2003.
I have a continous form which contains information regarding vendors bills
and i would like to create a check box (or a print button) which when
selected prints out a statement / report which shows the bill. Not only would

I have a subform on my main form.  The main form header is tblHeader and the
subform is in the detail area using tblMain.  After update of the combo box
on my main form, the subform changes based on the value in the combo box.
This works just fine, but when I save the record, the ...

Has anyone seen a good input mask for email address that will catch input
errors like "," instead of "." etc?
Thanks BRC