Dear reader,
Some times I receive an error message by using the functions:
Left([FieldName...];2)
Mid([FieldName...];5;2)

I made a database and tested it a few times.
I now wnat to use it in production.
I deleted all the test data.
Is there a way to tell it to start autonumbering from 1 or am I stuck

I have an edit button on my form that changes the recordsettype of the
form, causing the form to requery.  If I have a filter applied on the
form before I hit the edit button, it is not applied to the new
recordset (which I expected).  How do I pass the filter that I applied

I'm having a complicated linking problem.  Before I get into the particulars,
I'd like to know how Access links to the back-end file at startup, AFTER I've
distributed my application to the client.
Here's the issue.  While I'm working on my app, I'm linked to the backend on

I want to use a calculated function for the caption on my tab controls. I
used the following  code:
Me.Page28.Caption = "Expenses [" & [ExpenseEntryCount] & "]"
This should display the following: " Expenses [10] " where 10 is the number

Before executing some code I want to check for some null values so I
have this code...
If IsNull(cboCarton) Or cboCarton = "" Then
MsgBox "Specify Carton Type", vbCritical, "Required Data"

I see lots of threads on this but no solution.
I'm using the following to output my report in HTML format:
DoCmd.OutputTo acReport, "myReportName", acFormatHTML,...
Some rows have valid hyperlink info and some do not.

I have several tables based on exactly the same fields
(Key/Date/Price1/Price2).
I do some statistics on the prices.
However, as I have many different tables (the tables are different

I got the code for dimming a menu item from this group after looking
for it for a long time thanks to those who share their experiences with
the others :)
The problem I'm facing is that it dims the wrong menu item!! Example,

I have a database with two tables in it.  One is for student contact
information:
Contacts
ContactID

I would like to create a sort of lookup form with two listboxes. The
firts should read all the drives on my workstation. According to the
drive selected, the second listbox should display all the files it
containg. I would then need to open these files with the double click

Hello!,
is possible use relative path in access? for example use "photo\image1.jpg"
instead of "c:\db\photo\image1.jpg", I try it but I cann't, but in Visual
Basic if is possible.

Can somehow tell me the best way for multi user development to occur in
MS Access? The situation is: We are creating a new database for a small
company. There are 2 of us who  want to simultaneously work on
development. Does splitting the database and creating FE's work for

I've seen multiple threads (several in the last 6 months or so) on this
topic, but I wanted to clarify my practices. I understand the need for
cleaning object variables by setting them to Nothing and/or closing
them, but I'm not sure about the order.

i'm falling in headache status.
i have 3 forms linking together by the sub/main form way.
1st form named fcontract: biggest
2nd form named fdetailcontract