Access does not seem to have FIND function.  I need to capture Last
Name + Comma + First 4 Characters of First name.  In the Mid function
since last names are variable length, I need to determine the location
of the comma within the field, then capture from 1 to Comma plus 5

Good Day!
I develop Access dbs for a large Mortage firm. As a rule, most of the larger
tables are housed on a MS-SQL server. ODBC connections are used to connect.  
The Front-end access db could be launched from any number of desktops in our

Access 2003.  All of a sudden in a database that has worked fine for years,
the primary autonumber key in a table is assigning a number that has already
been used.  The primary autonumber key goes up to 863.  When I go into the
table and try to add a record at the end, it tries ...

After installing Office2007 Professional, on an XP-Pro computer, my access97
runtime application gets an error, when I close the application. After
sending the error report to Microsoft, a web page pops up that says "Problem
caused by Microsoft Office 97: consider upgrading"

I run a bunch of queries in code, this patiqular qry_ABC is a make
table query. I run it ok manually, but if I run it like below in code,
it got no records. Other queries run ok in code.
... other queries

Hi, this is my problem:
I need to delete from table "A", all fields that exist in table "B"
I tried a "delete query" but it sends an error "Please specify the table
where you want to delete the records" (its translate from spanish)

Hello, I am using the Transfer Text macro (for the first time) and I receive
an error message that access cannot find the file. I'm sure it's that I do
not have the path written correctly. I wrote it as I would for any other
application: \\location\filename

  I have a query that contains a field(subject) that always has data like
this:
SM# 2-1009579390 - New Industry report
I need to make anthother field in the query to extract only the numbers of

I am trying to convert values in the numeric field [HW] that are negative
into zeros while keeping positive values unchanged.
when I try the expression IIf([HW]<0,0,[HW]) as a crosstab query criteria
the negative values all come out as 1, while the positive values remain

I have a form with fields; ID, DATE and QUANTITY. The Date and
Quantity Field I've changed into a List Box showing the two columns
respectively and the ID field is left as a normal text box. When I
click on any item in the list box the ID change change according to

Just started using Access to manage some data for a project. Here's
the background:
-I get leads everyday from a client in excel
-I format and import that data from excel to access

Is it possible to split an Access DB into a front and back end where users
who don't have Access on their PCs can view a form and input data? -Thanks

on 2 out of 6 pcs in my office, when a form is opened there is a
blankety-blank blinking hourglass.
is this an access problem? office problem? a hardware conflict?
thanks for the help.

I am taking an online college course and learning Access.  I have purchased
the 2007 version and my teacher has the 2003 version.  I know absolutely
nothing about access.  I just want to make sure that when I send my files to
her she will be able to view them.  Any help is ...

At the moment we're trying to run all the main office components for Office
XP and Office 2007 on the same PC, so that users can decide which version
they'd like to run if required.  
Thanks to Bob Buckland's registry information, I've got Word XP and Word