I have textBox on a form. I want to write a onChange event that will put
"abc" in the field [fam] from the [trav] table. this field is also on the
same form.
I need the code of the Sub.

Hi. I have a few Update and Amend queries in my mdbs.
When the users run these, there is no visible indication
that the query had completed, apart from watching the
little progress indicator at the bottom left of the

What i'm trying to do is create a Query using a specific
time period from the data that I have.  For some reason I
can't come up with the expression that I need.. i.e. i
need to just take the data from 05012003 to 05312004 and

I'm attempting to create my school's master schedule from a download.  Importing data into a table and then running a xtab query (teacher - column)(period - row) works perfectly.  To make the final product more appealing - I have created a report - the data source is the xtab ...

I have information in a database table that I need to merge
with a word document all easy... however how can I place a
"button" on the switchboard to send the data to the word
document without the user haveing to create a new merge

I have followed a few links suggesting adding Custom Splash Screens as
follows:
1. Create Bitmap Image with same name as database, for example:
DataBaseName.bmp

does any one know how i can make it so that when a number (15) is inserted into a field in column A, the corresponding field in
column B always enters the date that the certain #  was entered into column A.
or a good tutorial will help
im using access 2000 and the generel date/time ...

I am a completely new  user of Access trying to modify what I think is the tab order of an existing database.
The database tracks scores for archers during an archery tournament.  There are 3 archers on each target.  The archers shoot 6 arrows, score them and then the score for ...

I thought I could place a condition in the control source in my report!  That if the field [Proposed Increase] is blank (Null) then populate the field with No Increase?
Although it does not work!  I am guessing that the problem is me :-)   Here is what I put in the form.
=IIf(Null ...

We have a database that was created in 97 and has recently
been converted to XP.  The import brings in a very large
file (approximately 300mb).  With XP now we receive and
error that states "One or more rows of data in your file

Hi -
I'm trying to truncate a field using the update query -
but can't get it to work correctly.  I'm trying to go
from M12345 to 12345  - eliminating the M.

I have installed office 97 on my system (running windows
XP). When I try to run MSACCESS, I receive the following
message:"Microsoft acces can't start because  there is no
licence for it on this machine".All other programs are

I'm having trouble and have been trying to create this database for over a
week now. I'm not very up to speed with creating databases and have been
trying to figure this out on my own. But I'm not doing a very good job at
it.

I have a string that I need to split out into its original components. The
string will appear in one of 2 formats either
0:11:22:33 or as 11:22:33
I now need to seperate out each segment, I can get the "33" out ok using

I have created a relativly simple DB using acess 2003 (file format is 2000) and have put a copy up on our LAN server. When I open and use the DB from different workstations everything appears to work fine. In a short time I intend to split this into a front end and a backend as ...