How can i get a hold of all the fields in Access form...basicly all the
controls. I'm developing in Visaul Basic .Net framework 2.0.
So far i only know how to find the right form
(appAccess.CurrentProject.AllForms(x)) but i cant get information from its

Is there a way to populate a multiselect list box in this way.  With the data
coming from one column.
Alabama         Alaska          Arizona           Arizona
California        Colorado      Connecticut      Delaware

I have deleted an unnecessay combo box on my form and now when I open the
form I get a pop-up box with
Enter Parameter Value
tblMain.Distribution16

It appears that there is only one OutputFormat to choose to send
export a table to Excel and send it via e-mail, acFormatXLS. This
seems to be sending the file as Excel 95 and is giving some of the
recipients problems. Is there a way to specify to send the file as

I search thru cascading combo boxes and other similar questions and can't
find anything yet.  Some help please:
I have three combo boxes on a form: Type, Held, Model
I want the second's options to based on the selection from the first and the

I am converting an Access 2003 database to an Access Data Project using a
SQL Server back end.
I have a form that is bound to an Employee table and insert, updates and
deletes records.  My table doesnpot have Employee name, it is an extra field

I'm trying to display a note in a text box.  The line of code is simply:
txtNote.ControlSource = "=" & Chr(34) & ListNotes.SelectedItem. & Chr(34)
the problem is that anytime the note itself has a " in it, it causes an
error.  Are there any creative ways around this?

I have a date field who's format property is
    mm/dd/yyyy hh:nn
... but I can't seem to get an Input Mask to work with that.
I've tried

I have the following code in a vba code attached to a form:
   Dim rst As Recordset
   Dim dbs As Database
   Dim whatif As String

i have a table which lists pieces of equipment by manufacturer
tblManufacturer has a one-to-many relationship with tblEquipment
on frmEquipment i have a combo box, cboManuf, which selects Manufacturers
from tblManufacturer and then writes the ManufacturerID (a number) into

Im using Access 2000. I have a form based on a multi-table query.  I am using
Tab Control to show multiple tabs. All my tables are linked with RI and
Cascading. I'm using a unbound combo box to select the record for the main
form. One of the tabs i added a subform based on a ...

Hi! All we have working with "Audio Restoration" application, in that
application we need to develop .avi files noise clarification using  "audio
restoration" software. First we need to download .avi files from cam to PC
drivers, then we apply "audio restoration" software and do the ...

One more question. This formula works great, with the exception of, if
someone signed the paperwork prior to 9/2, it tells me their paperwork
expired 9/1/07.  I need it to tell me that if Kool Kidz signed before
9/2 that it will expire one year later; otherwise if signed on 9/2 and

I have a table called "Site List" with multiple fields, but only 2 fields
called Site Status and FSM that I'm concerned with.  I have created a query
to filter the Site Status on "Active" and have set the query properties
Unique Value to "Yes" as an FSM may have multiple Sites. ...

Like this:
I have a field in a table is type date, and i want to make calculation by
week in form, so is possible to filter all the date by week and make
calculation in them?