The forms that they want have 4 to a page.
every one will be to a unique ID number that will be on the section
1          2
3          4

Can you loop through Query Defs and get the name of the tables/queries used
in each query?

But I am trying to split material from a text box to be entered into
two different tables.
Let's I enter the word "Makebelieve" in a text box. But I want to only
enter the first three words 'MAK' in table A and the rest of of the

Perhaps a silly question. I've been trying to format the list items in
a listbox by appending a constant text string to the values. Here is
the code:
********

I am using the following SQL statement courtesy of access monster user:
'Terry Kreft ' to convert dates from a text format (20020331 00:00:00) to a
recognised date/time format (31/03/2002).
SELECT

Filter the last date only
I am trying t0 filter only the last date of the query,but i cannot
manage that.
My query is the following :

I am using the PrtDevMode property of a report open in design view to
try and flip the orientation of the report between Portrait and
Landscape in a user control box before the report is opened. I pretty
much used the example out of the help verbatim and Im not having any

I am fresh college graduate who has done C and C++ during college
times.After that i had done a C# course from one of our local computer
institute.The course is BCM which ran for 1 year.But now when i am
looking for job the questions asked in interview are really very very

Set rs = db.OpenRecordset("tblIncident")
I'm getting a "Run-time error 13: Type Mismatch" this time.
I've got Dim db as database and set db = currentdb
DAO reference set up as well.

I'm running a VERY simple bit of code that is supposed to set the
record source of the current form based on the entries in two unbound
fields to act as a rudimentary search tool.
The code is as follows... excuse my over use of ifs and thens but its

In my main database I have a procedure to copy a template database named
MyTemplate and make a new database named MyDatabase. What is the code from
the main database to change the caption of a label named Title on form
MyForm in MyDatabase to "New Database"?

I wanted to know how to give certian permissions to a database. I will
tell you what I want to do. We have one database that has all the
students and teachers in there and we want the teachers to be able to
only see and grade there own students. I was thinking about setting up

Is it possible to ORDER BY a SubSelect?  I don't see why it wouldn't
be, but I'm having some trouble.  Hopefully it's just a simple error in
syntax and somebody can tell me.  Here's what I'm trying to do...
I've got two tables:

How do I stop an Access (2003) form from it's default behaviour to
automatically save a record when exiting the form?  I want to use a
save button instead.
Thanks,