I have the following text box control source of:
=[IFirstName] & " " & [ILastName] & Chr(13) & Chr(10) & [IPAddress] &
Chr(13) & Chr(10) & [IPDistrict] & Chr(13) & Chr(10) & [IPCity] & " " &
[IPPostalCode]

I've been  using a popup calculator (basCalc) that came with an Access
Developer's Handbook (Getz,Litwin,Gibert) for several years.  I often use it
in an amount field....double-click and the calculator pops up and the result
goes back into the amount field.  I'd like to be able to ...

If I set a combo box's value in code, how can I force the box to autoexpand?
 example:
                1. mycombobox has a value of 644 in its list.
                2. in code, I set

I had two tables that were many to many. So I split that up into 3
tables(1,2,3). Then I created some forms. Now I have a main form for entering
customers and a subform for the products they buy. I want my user to be able
to go to this main form and have the ability to add a new ...

I am designing a database containing admission and discharge dates of
patients.  A list box contains the options "admitted" and "discharged".  I
would like to force the user to enter a discharge date if the "discharged"
option is selected. How can I programme this into the ...

I can't remember how to link one subform to main form.
Main form had Box Number, Description.
Sub form is Contents by box number. Can be more than one content. (I set up
relationship that way.)

Hmmm... I sent this out over an hour ago and it still hasn't shown up.
Pardon the resend...
 I'm trying to prevent duplicate entries in a field of a continuous
subform (frmScheduledEvents).

I implemented a TreeView to my Bill Of Materials using the code sample in  
http://support.microsoft.com/default.aspx?scid=kb;en-us;209891  (How to fill
a treeview....)
I have it attached to the Form_Load event.

I am developing a slew of access apps that do extensive Long running queries
repeated in loops, unfortunately that code running makes access go into (not
responding) mode and locks up all GUI INCLUDING updates of the progress bar.
Does anyone has any links to sample solutions to ...

I typically write the error handling towards the end of development.
I saw this bit of code in a response from '69 Camaro, can I use this genreic
error handler marked with *'s at the end of the line for any/all events in my
subs?

I posted this in "access forms" rather than here. Sorry.
I have a form called 'Tabs'. On this form I have a two page "Tab Control".
On "Page1" I have a form called 'Bank'. On the 'Bank' form I have a field
called 'Creditor'.

I have a few list boxes that give various options.  I want the user to be
able to choose from different suboptions in another list box once they have
made the first choice.
I.e. if option 1 is chosen in the first list box then the second list box

I have a Main Form with an imbedded SubForm.  I am doing a DLookup in the
ControlSource using a TextBox in the SubForm to Display the SoftwareName.  
This works great (thanks to Rick Brandt) when I open the SubForm alone.  
However, when I view the main form, the DLookup doesn't ...

I have a Form.  I have two fields, and one is a Combo-Box built on a Query
and the other is a "hidden" field which I want auto-updated based on what is
chosen in the Combo-Box.  When a record is selected from the Combo-Box Query,
I want the other field to be updated with another ...

I need to create an email message using VBA from Access.  I want to create
the message and enter the 'To:', but let the user then enter the subject,
body, and send the email.  When I try the code below, Outlook is never
visible so the user cannot complete the message.  Can ...