In an Access Project I have a datasheet with a column of genders, and
would like them to display only the first character.  Is there a way I
can add the Left(string, #) function to a property to display only the
first character of the gender?

I have a textbox on a form that I want to use to display a public
variable.
How would I go about doing this?  Could I use a label as well?

If I have a web site using ASP 3.0 and MS Access and hosted on a
server with MDAC 2.7/2.8 installed, does it make any difference
whether the mdb is an Access 97 one or an Access 2000 one? I only have
Access 97. The hosting company intimated that I should seriously

I need to pass the value held in a field in one form and have it
appear in another form.  I specifically don't want to have to refer to
the original form name as it has passed, because I want the second
form to be accessed from several different places.

I am working on a form in which I have a shopping list of items that
the user can check off and then beside each they can indicate the
quantity they wish to order.  I want each checked item to be a separate
record in the underlying table.  I'm just not sure how to use VBA to

They've disappeared.  The code is there in the property for the text
boxes still, but the icon won't appear.
Any ideas?
-pw

I have the following problem:
1-When I Try to compact my DB but I have the following error:
Error 3356 " You attempted to open a database that is already opened
exclusively by ‘Admin' on machine

We have a old VBA app that create 3 linked tables to SQL server.
However for whatever reason now whenever the code tries to create these
linked tables, a dialog box comes up prompting for a server name and
with the username and password already filled. Anyone know why these

I have a situation wher I have an Access 97.mdb with tables linked from SQL
Server 2000.
I have no problem opening the table via MS Access and viewing/modifying the
data.

If I used the AutoForm button to create a form based on a stored
procedure, where do I find the code or properties that calls the stored
proceedure? Or is this somehow embedded in the form where it's not
editable?

I have two tables in my Access database that I want to be able to
synchronize by pressing a form button. I think it can work, but I am
not sure how. I am trying to use a single query to do this.
The first table, and more updated table, is called tbl_hours_new. This

I have a large Access 2002 DB (mdb) with many linked tables pointing to
a vendor database. The vendor has released a new version, and the
column names in all the linked tables has changed.
There are many queries, reports, forms, and modules in this mdb that

Im wondering why the following will work
Me.Controls("subnonstorePos").visible = False
while
Me.Controls("subnonstorePos").AllowEdits = False

Can anyone point me to a good resource to show me what potential problems I'll have converting from Access 2000 to Access 2003? I understand that 2003 can read and work with the 2000 files, but that 2003 has a different native format? I'd just like to get a good idea of the ...

First thanks in advance for your help.
I am trying to do a query and am not sure if this is possible.
I have a table called Extensions:
ID    Ext    CDate