I created a form using the form Wizard.  After creating the form I edited the
properties of the form.  I then added a list box.  The problem is, every time
I search or  click on a number within the box it edits The current record and
changes information.  Is there any way that I ...

I have a main form with a subform that may have a maximum of 3 records
(extension events). I have the subform set to a continuous form so all events
will show for each main record. When entering the first subform record Access
automatically opens a new empty record. Is there a ...

I have a database that is used to hire out equipment to employees. I have two
queries setup that show available equipment and unavailable equipment. When
hiring out equipment the user selects the equipment from a combobox. This
combobox is based on the available equipment query. ...

My database consists of information which is updated every quarter.
Forms will compare data from the present quarter to quarters past.  I
need a way to make the database save a copy of itself every quarter and
then be able to have a form refer to that data through a comparison.

I saw a post on here recently and thought I would tryo that calendar and it
works great. The thing I am trying to get around now is being able to drag
across multiple months. When I attempt this is stops at the last day of the
month.

I wrote a module that I now want to call and execute from a form.  
If I use DoCmd.OpenModule, how do i then run it and close it.  Feeling a
little silly asking such a basic question, but how do I do this?

I think I have a fairly common problem. In my database, there are a number
of tables all linked on a 1 to 1 basis with the main table. In the same
mannor, there are various forms for the different tables.
I am wanting to link all the forms and tables so that they work with '1

I would like to make the process of adding a hyper link to a record easier
and more intuitive. I know that to establish the hyperlink at the form level
I can right click the empty hyperlink box and choose hyperlink,edit hyperlink,
make a choice on what type of hyperlink from the ...

Here is what I need to do, just need to tie it all in with VBA for Excel
from within Access
I export my data into an excel spreadsheet, autofilter and arranfge column
widths, then e-mail to an exchange folder, all from VBA

I think this should be an easy one. I have a form with an ID field. On
update, I have an event procedure to open a new form and set a variable equal
to the ID value in the current field, but I can't write the code that will
set the ID field in the new form to that value. I've set ...

I have built a form, where you put start and stop dates and you then get
information base on those dates.  They are entered (on my PC) as 01-01-06 but
I have other PC's that use this form when they try to enter dates they show
as 1/1/6 and the information does not work.  Can ...

Hello Microsoft,
I have a DataEntry form that is set where the Properties/Format/Default View
is DataSheet.
This form is used to Paste information from an Excel spreadsheet and it does

I have a combobox with 2 columns (1 bound). It is used to display PlantID and
PlantName. PlantID is the bound column. When selecting the required PlantID
from the drop down both columns are displayed. When the selection has been
made, and the combobox is rolled up, only the ...

I was hoping to automate many of the options after the user selects
their .xls file via from the Form's side.
Perferably "Next" and then "Finish" (2001 Access)

I have the following code and it's not working.  Any suggestions?
Sub UpdateDB(numRecs As Integer)
   Dim i As Integer
   Dim sSQL As String