I have the following code.
Public Function fTableExists1(strTableName As String) As Boolean
   Dim db As Database
   Dim tdf As Tabledef

I am creating form from code using 'CreateForm' and 'CreateControl'
functions.
Everything works fine, as we plan to deploy MDE version soon, question is
will it work in MDE enviroment??

I would like to automaticly insert text into a field as a default (like a
template) but then be able to add to the text without the default text
disappearing.  How can this be done.  The field is open text.  An example of
what I would like to do is have the words "To:" be the ...

I write small database apps for local companies, charities, etc. Just
before I deploy the final version to the client I create an mde front
end and a customized tool bar for each form and report with just the
icons they need.

I have an invoice table.   The invoice table is associated with the bills
table by a text column in each.  The bills table is linked to a suppliers
table.
I want to print all the invoices that have a certain

Why is it that my "Yes/No" field is showing up as 0 and -1 in my form?  
Any way that I can change it?
Thanks!
-Tegan

I am trying to create a query that searches a field for specifically
*******, not wildcard
I am running Access2000
Thanks

test mail question

I have a query that allows for a keyword search in one criteria using the
following formula:
Like "*" & [forms]![frmSearchByVenue]![ThisValue1] & "*"
My question is can I use the same criteria, include ThisValue1, in another

If you please could help me i will be very glad.
this is what i have:
StudentID         Class          Date
S031N0032     EENG-122     1/1/2007

Like many, I am experiencing difficulting making all the right settings so my
linked Excel table will correctly import  a column (type=Text) of values
containing text, numbers, or a mix of the two to an Access report. Have read
the 'dicks-blog' article and made the first two ...

I have an Access 2003 database that uses an MDW for security.  It is
also signed with a VBA code-signing certification, in case that
matters.  There is *not* a database-level password applied.
I've sent the database and mdw to another user who needs to make some

We have clients that we mail to, each client has a ID.  However, they can
nominate another client as a representative who we mail instead.  Therefore,
I need a query to use the Representative ID (if it exists), If there is no
Representative ID, to use Client ID.

i have a employee form and a subform with training info info on...the trouble
im having is being able to add more than one traning record for each
employee, i.e. each employee will have up to 30 training record.
i keep getting a message which basically says i cant add more than ...

Hi,
I am attempting to do a validation rule on the table level which would
prevent a duplicate value where a duplicate value exists in a different
column.