I have been hunting for this and can't seem to find it.  I would like to put
a command button on my form that finds the closest match to what the user
types in even if it's not found as an exact match.  The field I am finding is
a text field, 10 charicters long and has a right ...

I have an image on a subform that does not refresh when records are
changed on  the main form (to which the subform is linked).
I am not sure how to refresh the image.picture control when the event
procedure running the code is on the form (not the subform).  Can

My Problem is that i havent touched Access in years and now i got to solve a
little problem.
Im constructing a data base that all the information entered into this is
through a Scanner gun the user is not going to be close to the keyboard.

I have a continuous form containing records after running a query..
Now I want to create a pushbutton that, when pushing, automatically
sends a report, based upon this recordset, to my boss.
Creating the report itself is no problem, but how to send it?

I am trying to use
  Me.RecordsetClone.FindFirst "ContactID = " & lngContactID
  Me.Bookmark=Me.RecordsetClone.Bookmark
methodology to move to a record with no response. The underlying recordset

I have following situation:
I created a continuous form based upon a query.
All records are selected if a date field fals between 2 different dates.
The records are displayed correctly.

Can you nest on tab controal on another
I have too many tabs on my form

I have some code in my subform. I am would like to run an if statement like
below. If on the main form a check box is checked then... However my syntax
is wrong and the code cant see my main form object. Can anyone help.
If Forms![frmPO_Lookup].Form!ckref = True Then

I have a form that has a Tab control on it, and on each page of the tab form
there are a number of questions with yes and no check boxes. The intent of
this form was to be used by the user to record the selections off of an Audit
form. I would like to code the close event on this ...

I'm trying to create user dialog form to update some records at once.
When user is trying to print the records,I prompt them to assign a
permanent information and then run an update query to update the
records.But it causes writing conflicts since the records I'm trying

This Access Db has >250 Forms.  Most have an item with a specific descriptive
named object that is no longer necessary and needs to be replaced with a
different descriptive name.(i.e. "pagerNo" to "eMail").  This can be easily
done in the vba code objects attached to each form ...

Using Access 2007. I know how to open the program, but I am having tough time
writing code to check if the program exists on the users computer. I want to
check to see if the user has Office Word, and if so, then open the program.
If not, cancel this step. Anyone have a code for ...

I am using the Me.Requery command in my code. It works great except when I
have a long list and I am the end of the list. Every time the Me.Requery
executes it takes me back to the first record. Is there a way to refresh my
query data and leave me on the current record?

Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull([Forms]![frmPKMiscellaneous]![sfrmPKPKMSPhysicalAttributes].
[Form]![ProfileType]) = True Then
     Beep

I am using the mousehook code to disaple the scroll completely. Is there a
way to allow users to scroll up and down through a form that is longer than
a page w/o scrolling through the records?. Right now, with the mousehook
code, its completely disabled.