I added a combo box on a form based on tblAssigned that
draws from tblPersonnel.  I want to be able to draw from
tblPersonnel the names that a particular asset was
transferred from.  Since the tblPersonnel has two fields

As an IOMG/MIS student I take database classes, I need a copy of ACCESS.  
There is a $50 difference between Office Small Business and Office Pro, of
which ACCESS is the main item added to Pro.  As a student with a version of
Office Student/Teacher I would like to be able to get ...

A2K,
Can I have a command button act on the records of a multiple selection in a
subdatasheet? If so how?
Brad H.

I have a data entry form that contains a couple of subforms.  I would lke the
user to be able to enter all of the information on the form (including
subforms) and then confirm the update prior to the records being saved.  Is
there a way to do this?  I am not very good at code, ...

A2K
I am using the GetOpenFileName and BrowseFolder APIs, but how do I simply
launch a Windows folder at txtFolderName?
Brad H.

I have a table containing a start date and an end date for training courses.
I need to extract quarterly statistical information.  I have added two
columns to a query where I have used the datepart function to calculate the
quarter and year in which the start and end dates fall.  So ...

I have a table with 2 fields the first a number and the second text. It has
data like:
1 one
2 two

Okay, I am new to Access and I need to ask a simple
question I hope. I would like to create 1 table that would
have 5 fields. then I would like to create 1 table for
each field from the first table. then I would like to

I am creating a select query and I have a field that
currently contains the value of 10 and I need the field
to be left zero filled so that the value is 0010.
Any ideas.

Is it possible to embed a hyperlink in an Access 2003 report?
IOW, can I have a field in the report that is clickable when viewed so that
it will launch a browser and take the user to the URL in the link?

Morning all,
Simple question today.  When you click a command button can you change the
caption on the button.

I have a table that contains sales data.  I am trying to create a form on
which two dates are entered and the sales figures between those dates is
calculated and shown on the form.  Below is the code I have tried
unsuccessfully.  if someone can point me in the right direction that ...

I am building a database of staff details, names, addresses etc.. I would
like to add a photo for each of them. I have the photos as jpegs. I have set
up a field 'photo' in the database and  I've tried to copy & paste the jpg
file to it, but am getting an error message about opening ...

I have confirgured Outlook 2003 per Comcast directions but new email does not
come into Outlook it goes into the Comcast email.  Can anyone tell me whay
may be wrong?  Comcast does not support Outlook 2003.
Thanks,

I would like to stop the following and I think the two are related
When I press tab on the last control in my form a new record is added. (I
would like it to go back to the first control)
When I use the scroll on my mouse (The thing between the mouse keys..I can't