I have a system for placing orders with suppliers, when i'm checking
invoices I need to get to specific orders and ammend quantities prices
etc.  When i place an order i have a nice form for the data input.
what i ideally need is to find a way to use this form to get to a

All,
I'm dealing with a 3rd party application that can't interpret the
Access function FormatCurrency.
When it encounters my query with "Exclu: FormatCurrency([Exclusion],

I'm using Access 2003 and reviving some development on an application.
I have an Orders form with a Products subform. 1:n relationship between
tables.
Is there any way to programmatically set a Filter on the Products subform and

I have a form with many fields, each of which has their separate record
sources in a split db.  Today, several users throughout the afternoon
encountered the following message when accessing various dropdowns on the
form:  "Error (-1517).  There is no message for this error." ...

Trying to understand what VBA is telling me when running
Dir c:\thisdir\thatsubdir\nul
I did the following in a command window:
C:\Docs\TitleWork>cd\

I have a table that I need to export to a .asc file format. I have had
several attempts at getting this to work but with no luck. Basically
the file would need to have every record displayed on a separate line
- If you like a CrLF delimited file. The unfortunate thing is that the

I'm writting an application in Access 2002.  It'a a appointment
manager.
I had been chllenged add the possibilitie (beyond print, email and
fax) to send a message to a cell phone, beeper or palm.

I have an error handler: On Error GoTo Outtahere
At the end of the routine, the OuttaHere section reads:
OuttaHere:
If Err.Number <> 0 Then

Front end is Access 2002, back end is linked Oracle tables.
My users need to describe things in feet and inches and want to use
the standard ' and " abbrevations.
On a testing form I go to a record with double or single quotes in the

I have a numeric field (double) which holds a number of hours.  I wish
to display this on a report in the form of hours and minutes.
E.g.
2.5 to be displayed as 02:30

I have a table named StockItems with field:
StockItemID
QuantityInStock
I am creating assemblies of stock items and have another table named

I'm developing a new application. The datasource for the application
is generating a string filled with XML data.
Because we need all record we need to split this XML data.
When we save the XML data to disk and then import this into access

Was working in A2003 and noticed that the Save Record item on the Records
menu was not available when the record was not dirty. In A2000, Save Record
was always available. (This is a problem for me because I have Docmd.Runcmd
acCmdSaveRecord code all over the place, which never ...

I'm trying to create a database for my companys inventory and I have
almost no experience on Access nor the time to get the training. I'm
using the inventory template so the work has already been done about
90%, but I would like to make a few edits.

Here is the SQL code:
SELECT [IBCCP Referral].[Caller ID], DCount("[Caller ID]","IBCCP
Referral","[Caller ID] <= " & [Caller ID]) Mod 10 AS Expr1, [IBCCP
Referral].CallDate, [IBCCP Referral].CallTaker, [IBCCP