Hello...
I want to be able to click a button on a form and naviagate to the folder
where my jpg file resides and then I want to import that jpg file into my
database via the same process.  I already have a field set up of data type

If a combo box pulls from a table, is there any way to add an additional
option ("Add New", for instance) to the top of the combo box? Also a
separator line between "Add New" and the rest of the choices would be nice.

In Access 2003, I added a combo box to a new form (Combo0), set the Row
Source to a table and then added this afterupdate event.
Private Sub Combo0_AfterUpdate()
MsgBox (Combo0.ListIndex & "  - " & Combo0.Recordset.Fields.Item(0).Value)

Ok new problem...........
I am trying to mail merge from MS Access to MS Word. Searching the net, I
found people suggesting that making ms access and ms word (XP) work together
was problematic, so I followed a suggestion to base my mail merge document

Hi I have a small membership database.
I have a field called MNumber which is a unique number it is not the primary
key but  it does have an index set to unique so cant have duplicate values.
I have a button on the form that will create a random number and fill in

i have searched for this problem and found quite a few various different
answers, but the not one i want:
DoCmd
"ViewJobDetailsFrm",,,"JobNo=Forms!ViewJobsByCust!SearchJobsFrmSub.Form!JobNo"

I need to change the criteria of a query and then create a csv file with the
records that match the query. I have been trying to do this using the
DoCmd.OutputTo command. It would seem logical to use a whereCondition
statement to set the criteria for the query. Is this possible? ...

I have a database where the first page that appears when it is opened is a
blank data entry page where the user can input customer information.  I have
coded the page so that it always opens to a new entry by using:
"DoCmd.GoToRecord , , acNewRec" in the On Open properties.

Have form which contains code under the OnCurrent event: If a value in a
field is less than zero, make label font red. Works fine.
However, this form is a subform with Continuous view.
I set the subform size to only view 1 record at a time.

Here below is a sample of the data which I am trying to import using a macro.
This import of .txt data files. generates errors and I get a number of data
conversion
errors. What I'd like to know is why, since the data is obviously text. Then,

I want to reference a field within a form's recordsource but which is not on
the form itself.  In the past I have been placing invisible fields on the
screen but that has become too clumsy, too time-consuming and too annoying.
I just want to be able to programmatically update the ...

having a bad day .. i have a form with a command button.
when the command button is pressed the following happens
1 the last date of entry is retrieved from a table
2 a report showing the information entered for this date is displayed on

I have a filter 'myProdString' called from my Filter function as below.
Function myFilter()
   DoCmd.ApplyFilter "myFilter", myProdString
End Function

I have a subform, in this subform I have a list records.  I created a command
button to set focus on record in list and then send a key value to mainform.  
The value of the combo box on the main form does show the key value that I
sent from the subform but it seems not to ...

I have a VB form that on the onOpen event, needs to find out what the user's
group membership is. I have a command button that I want to set to
Visible=False unless the user is in the Admins group. However, I get a
strange error when I attempt to open the connection - "Cannot ...