I have not come across this before and just wondered if anyone had any
suggestions as to the cause.
I have a parent form, a subform and a subsubform for Invoice Number (VBA
Generated)

I am using the following code in a combobox named authorizers. When I
enter a new name I get a message telling me an error occured. Any help
is most appreciated.
This code was originally written by Dev Ashish.

Can I do a select like so: -
SELECT TM_InvoiceItemGroup.Field3, TM_CompContact.AcNo
FROM TM_InvoiceItemGroup LEFT JOIN TM_CompContact ON
TM_InvoiceItemGroup.Field3 = TM_CompContact.AcNo

I've done this before, but cant remember how and I cant find anything
in help or on the internet.
I need a formula to calculate whether a specified cell has text
letters in it or numbers in it.

I am trying to execute the following code: -
   [Forms]![FM_MainDetails]![FMS_Boat_subform]!
[TM_JobDetails_subform].LinkMasterFields = "jobno"
jobno is a hidden control in Form FM_MainDetails.

I Have created a 3 columns report
In design, the with of the report is 2.5"
I have put labels in the page header
ID - Name - City

to get a unique identifier i use the now() function and on the form it
displays like this "2007-02-26T11:46:57" but uses a 24 hour clock
is there a way to change the format?
i was trying to get auto numbering to work but even with a access database

For example my users have to input text describing a product under the
product field. i would like it that everytime they type something in it is
stored and saved so that next time as they begin to type the same thing, it
will automatically fill in the rest, just like how IE does ...

hi
i've made a database for temporary id cards,
to add photos i've made a command button - when i click on this button i
want it to take me to a specific folder where i store my photos!! please

I have created a database in Access and I have a have a couple of problems I
have not been able to solve.
1. I have created the securities on my database by using the workgroup
admin.  This causes me to have to change the workgroup in Access in order to

I am trying to do the following:
I have a notes table, and a doc input table.    I then have a form for the
document input and have a second form for the notes input.  All notes are
related to the record in doc input table.  When entering a new doc using the

I'm trying to store/display a text box calc value/result (calc is located in
control source property line) into another text box numeric field (control
source is a field name).  The value to store is in this format 00:00.   I use
a set value in macro to assign this value to this ...

Getting an error message trying to run the TransferText command of the
DoCmd object.
"...Jet Database Engine could not find database object
'export.txt'..."

I am very new to Access. I have two separate mailing list Access files with
the same or similar info in different sort orders and/or info in the same
fields.  I would like to make on of them a "master"
How can I check DB "B" for the a street  address field....and if there is a

The great helpers here really helps me a lot.
Thank you£¡ And thanks to ACCESS NEWSGROUP !
Martin LEE
2007-02-28