I know there are several ways to programatically export, like
docmd.transferspreadsheet, but I want to export data from a form.  I however
do not want the file button available to my users.  I thought this might work
DoCmd.DoMenuItem , acfilemenu, acExport, , acMenuVer70

I have a listbox that the user uses to select participants from for courses
that are held. The user clicks on the names of the participants and then uses
a button to migrates those attendents over to a participants listbox. I have
been asked to provide the ablity to use the ...

I know I asked this already and the general response is use a pop-up
calendar, I would rather not. How can I click on the Activex Calendar and
have it transfer the date to a text box ?
Thanks

Using Access 2000 I'm trying to convert excel files to access with this code:
Private Sub LoadNewWorkOrders_Click()
Dim strPath As String
Dim strFileName As String

I have a combo box which i use as a search field.
Correct me if i am wrong. Using the code below i am able to select the
record from the combo box and it populates the corresponding values to all
other controls on the form and subform. When i use the default record select

I am trying to create some kind of command button where if a user needs to
add a new record, he/she can use info from another record displayed on the
current continous form to populate their new record.  I am stuck on how to
proceed to grab some of the fields from a record that ...

Using the jet database (not my choice), I'd like to know it anybody has any
ideas as to how to determine what/when tables are being updated. In
SQLserver I could set a trigger, but not Jet.  
The reason is that I'm linking two back-end database together and I need to

Hi
This is the first time I've done this so I hope I've included everything
needed.
I'm using Access 2002. I want to open a form  (UnitData) at a specific

I have a need to use Global variable in a query.
What's the best way to use it?
I have
select custcode, name from table1, table2

I have a bound form which has several text boxes, each box is for a date.  
When the form opens, the Open event (through 5 IF statements) counts &
increments the number of these boxes that have null values.  I have a
variable for this count.  I would like to display the value of ...

I have a continuous form (with no subforms).  If a user enters an invalid
length for the Account # in the [txtAcct#] field, I want a message box to pop
up and tell them what is wrong.  I then want it to put the cursor in that
field so they have to fix it before going on.

I'm creating an invoice form that has a main form (frmInvoice) based on a
table (Order Entry5).  On it I have a subform that groups together records
with the same Order Number.  I would like to be able to add the same batch
number to all of these grouped records at one time.  Is ...

I have a form in which I am scheduling speakers it called “Speaker Assignments”
I am trying to use DLookup to retrieve information from a Table called
“SpeakerInfo”  I have created a unbound text box called “txtSelectSpeaker”.  
What I want to do is enter the  last name of the ...

I have a combo box which searches records in the table. When i type in a
record that is not in the database it prompts a message. The problem is once
I get the message then all the values in text boxes should become null and
clear out. how to do this. At present the values from ...

An application (which I am not familiar with) was written in Access 2002.
There is a form with a subform where double-clicking on a row is supposed to
go to another form using the information from the selected row in the subform.
The user's Access has been upgraded to Access 2003 ...