I have a form that has several fields, one of which is called Pro_ID.  I
would like to use whatever number is entered in that field to run a query
that fills in the rest of the fields with information associated with that
Pro_ID.  Any ideas as to how I can achieve this?  Thanks.

I have a simple question.
I am exporting a file to excel.  My table/query has field1 that is a check
box.  When I export it, it shows as TRUE or FALSE.  Not very user friendly.  
Is there a way to modify what is outputted to excel without having to create

I am developping an application with VBA & Access. I created a form
containing 15 subforms  controls (one above the other) , and I am
trying to make the subforms controls look good and all equals.
These controls are supposed to show each one a subform nammed

I use a private function to load some initial data onto a form with a list
box control.  The listbox control should be filtered based on two unbound
controls: tAgent and tCode - these controls are loaded with data from the
private function.

I suspect that I'm missing something simple here, but I can't figure
out exactly what.
I have the following code in the Form_Error event of the menu form
(frmMenu) which is set to open automatically via Startup options.

I need to calculate the sum of values entered by the user in a subform.  the
record source for the subform returns 1 field,  [Type].  I have added an
umbound control "Penalty" in which the user enters a number for each record
in the subform recordset.  In the footer of the ...

Is this correct in refering to a table in an external database?
Thanks
DS
Me.TxtVoids = Nz(DCount("VoidID",

Hi to everyone,
to check the proper case of my data string I'm using the module I
found at this web-site: http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Proper%20Case%2
0Function'
It's working very well but I'd like to add in it the possibility to

Will someone check my code and correct it?  Please?
I am deleting the current record on a form; key field is text type.  I know
the following is missing apostrophe/quotes but I haven't figured how that
works.

Good Evening
I am basically trying to fill 3 fields postcode, ward and UPRN on a form on
the afterupdate of a combo box which a users selects to create an address.  I
was using dlookup but this was so slow taking 30 secs to find and return the

Using Access 2002, I have a unboard text box on a contacts form for the
contacts department. For uniformity I want to ensure the user always enter
data, for example, in the form 'Health and Safety' instead of 'Health &
Safety' i.e. replacing '&' with 'and'.

I have searched the newgroup as well as MS site and cannot find the answer
to this.
I have the following code in the BeforeUpdate of my field on the form.
Private Sub cboTimeComplete_BeforeUpdate(Cancel As Integer)

Access 2007.
This is driving me crazy and I'll have a difficult time explaining, but here
goes.
Using a one-top-many between 2 fields:

What would the code look like in Access 2007 if, in VBA code, I wanted to
open a recordset of a table called "ACCOUNT" and update a field named
[address].

I'm still using 2003 and have several ADP apps. I've read conflicting
opinion whether Access 2007 supports ADP project files.
Does anyone running Access 2007 know for sure if ADP projects are supported?