I have a database that has some tables joined via relationships.
The main table is a customer table, for gathering the first name, last name,
address, etc.  Then there are others are linked to it.
What I am wondering...is there a way to have the form check the table after

Back again with another little issue, well may be not so little!  
have a Main Form with two sub forms on it each based on differen
table, I then have a select query triggered by a command button whic
opens a report based on this query.  The purpose of this is to create

I have a report which is generated using a date range. The Query has been
set up with the following code in the date field:-
Between [Enter Start Date] And [Enter End Date]
This works fine, however if there is any data in the start or end date, this

Access97
I am trying to create a table in a local MDB by extracting a range of
records from an BE SQL table with 15 million records.
I have linked this table with: (watch for this message wrap)

I have an "insert into query" sql query that runs well (code below). What I
want is to ensure that you cannot be run it twice.  The primary key for the
table is a combination key of Year (Year) and CompanyID (CoID).  The Insert
Into query inserts the appropriate year (which is ...

I have a db of photos.  I currently display a thumbnail of each photo with a
link to a folder with the compressed (jpg) thumbnails, but because the data
is on the server this creates a great deal of traffic.  This works but
considering that the thumbnail is only 2 or 3k (jpg) I ...

hi
when i created a project in MS Access, i had to make split for different
computers, such as using Database Splitter, and i did it from the server.
when i try to open it from server, it works normally, but when i try to

i just need a help for MS Access.
when you have a form, and you need to use label and textfield and all that
stuff.
there's one more things, in Loan we've got split 1 and split 2 and split 3

Not sure this is the correct group to ask.
I created a program in MS Access to perform specific queries for a specific
computer or TS client but need sample code on how to validate the name of the
TS client in order to run appropriate queries for that specific TS client. I

My small database application is stored on a network drive.  Our office has
four floors with several printers on each floor.  We select our default
printer from a list of available printers.  We can change our default
printer, or we can just change printers for a single job via ...

    Good morning, everyone.
    I've converted my Acc2K db to use CurrentDB.Execute so far as possible
for new records and updates, rather than opening a recordset and using
.AddNew or .Edit.  However, I still use .AddNew when I'm creating a new

Hi I want to be able to create an input screen to add new records and test
for duplicates before saving.
I created an entry screen with unbound text windows. Software and version
txt windows will be saved into a single field called Strsoftwarewithversion.

I have developed a database allowing users to store property pictures using
access 2003 (2000 format) but the end user is using 2000. To make things
simple (or so I thought) i used the code on nothwind employees form to allow
the user to click a button to open a directory and find a ...

Hi chaps,
I'm trying to use the Windows Image Acquisition scripting model described
at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wia/wia/ref

[image: http://www.mink-studios.com/sample_form.jpg]
A sample of what I'm trying to create, and a two parter-question...
(1) I'm trying to create a form that displays *different* linked image
in continuous forms, as the left side of the above image indicates. M