OK, I am new and tasked with making a dispatch database.
We have customer numbers such as 100443.002
in that the .002 is the delivery address and the 100433 is the specific
person or company.

I have a form that contains a subform that is set to datasheet view.  I
have removed the parent and child links so I could see the entire
table.  What I would like to do is that as the user navigates through
the data on the main form I would like the subform to select that same

I have a large number of Word documents which I need to transfer to Access
database. These documents have many bulleted lists. When I import them the
bulleted lists show in reports as a "dot then a square", and in web pages as
a "dot then a tab space" but text flowing onto the ...

I set the "Validation Rules" and "Validation Text" on a form and it works
fine if data is entered into the field. If the Tab or Enter key is pressed
on the empty field, the validation rules are ignored. These fields are
mandatory and I can use the lost focus to write code but ...

Is there a way to get the navigation buttons only to be shown when a specific
criteria it met?
Sometimes I want them to be shown and other time not.
How can I accomplish this?

I have a form that automatically opens when the database opens. Does anybody
know how to get to the database control window. I can see it sticking out
from behind the form (doesn't take up entire screen) but i can edit the
design and queries that need to be. I previously used one ...

I've read a few posts that explain how to capture the windows username,
but I'm having trouble getting this into a form.
I've added the following code to a public module:
Option Compare Database

Hi and TIA!  I have several apps developed using A2K and now my client is
planning to upgrade to Access 2003.  I'm assuming I should open the apps in
Access 2003 and save them as 2003 db's.  Is this true and if so is there
anything else I need to do to ensure the transition goes ...

Is this even possible.  To be able to have a subform where the Master field
on the main form is linked to the subform via 1 child field OR another?  So
the table for the main form, can be matched to 2 different fields (one or the
other).  Can this be done with only 1 subform?

I wish to sort by different fields at the user's discretion by using buttons
as headers and clicking the button sorts ascending or desending if it was
ascending previously.
I have the following code

I think this is pretty simple. I want to have my form function so that
they i type the record value in the field of a primary key, all the
other fields update with the corresponding value, and everything should
be editable... I'm new, and Obviously missing something in my form

If I want to set up two forms that have basically the same information is
there a way to copy one to set up the other without recreating a whole new
form?

 I have an option group on my form with 2 option buttons.  Then I have a
combo box that I need to use to look up a current record on my form.  What I
would like to happen is that when I select the 1st option group button I need
it to link to the combo box and enable it.  An when ...

I have a form and a report based on the same Query. The users can use Filter
by Form to filter the records displayed on the form, and I would like to
pass the same filter to the report so that the report lists the same
(filtered) records. Since I don't know which fields the user ...

I need some code that I can create a calendar for users to select the date
from like used in meeting portion of outlook or other scheduling programs.  
If any one has this I would be very greatful.  My email is
Ralph.Celento@nellis.af.mil Thanks in advance!