I purchased a home version of Access from Microsoft through my job, and when
I tried the following statement using the home version of Access, it wont
recognize [NameThings.NameLOOK] as being correct, but it works at work: (why?)
Dim strwhere As String

I'm trying to use Stephen Lebans' "Justify" module in an A2K3 program
running under A2K7 Runtime under Vista.  The program has been working fine
for a couple of years when simply running under A2K3 ... but now I'm just
trying to get it working under A2K7 Runtime and am having a ...

Let's say I have a list of hyperlinks in a column
Column A:  
Link: "ftp://upload:XXXXXX@24.XXX.XXX.XXX/spot%20viewer/" & [number] & ".wmv"
Column B:  [number]

We have a database that has been in use for a few years. Recently we upgraded
our MS Office to 2003. Since that time on one of the desktops that uses the
front end there was an event that has rendered the front end unusable. The
user was entering data to a form when she suddenly ...

What would I set the input mask for a phone number field:
###-###-####
Had it once but lost it.
Thanks,

I have placed a customer listbox on page one of a tab control. On page two I
have a form bound to a customer table. When I select a customer in the
listbox and click on the tab for page two I would like the form to show info
for that customer. how can I synchronize the two?

Hi,  I created a form using the wizard based on a query, everything looks ok
but i cannot enter data into the form because it is locked? what have i done
wrong, i been trying to solve this for 2 hours now - please can you HELP!!!

Okay I have a main form with 2 continous subforms.
Subform1   -  sbfmClientSearch with a wildcard search by client field.  
I type "Toy" I get every client that contains this text.  I placed a check
box so I can select the exact client I want to see details in Subform2.

I just converted a DB from Access 2000 to 2003.  The only thing that
does not appear to be working is a combo box that displays 2 columns
for selection to dictate the data to display in the subform.  First
column is a name/text, second is an ID/number and is the stored

I'm using Access 2003.
I'd like to know if I can set up a form that will let me add a
different photo to each record.
What's the simplest procedure to do this?  Thank you.

Is there a way to put a main form/subform in a continuous form so I can
scroll through all the records in the main form?
Thanks!

Hi,
On a form I have a command button that should change a text value to "Work
Complete" when clicked.  However I get the run time error "The Recordset is
not updateable"

Placing a label on a form with the text running horizontal not vertical.
I can do this easily in every other MS Office app but can not seem to find
where to do it in Access (2003).
Can't imagine that it is not available

I have a database that logs when a form (RPA) comes into our office. The RPA
will go through a few different hands and will have different information
entered into the database from each person. How do I get a log of when
information is entered and by who?