I am converting from a different desktop DB application and I can't do
the simplist damn thing.
In access, how do you use a relation on a form?
In the table view I had it working like two seconds. But on my form it

Recently converted the entire office to Access 2003 as a by-product of
upgrading all users to XP sp2 and Office 2003.
My performance on the Access 2003 datasheet view of a bound (to an
underlying SQL Server view) is so slow the application now is unusable.

I am trying to build a query in MS Access, I would like to be able to
subtract a set amount of minutes from the Now() function.  What I'm
trying to do is be able to say:
New Time: Now() - [Minutes] for example is Now() is 2/21/2006 9:04:08

I'm trying to write a query that will find multiple transactions that
take place within a pre-determined time limit.  I can easily compute
the time between adjacent transactions and then judge whether they fall
within the time limit, but I can't figure out a way to do this for

In my application, I have many forms. Some of these forms contains some
labels, which are placed in the header section, and act as a column
header. Because of the available space, the orientation is vertical.
This application (A2K format) is used by many users on different

I need some vb code that I could perhaps run from access that will look
in a particular folder I could specify in the code, and convert all the
files (just excel are saved there) to .csv.  Is this possible?  This
would be a huge help for me and any help would be greatly appreciated.

I'm trying to loop through records in a table, split the contents and
insert each subsequent string in the array into a new table.  I need to
determine how to cast the current record in the record set as a string.
I'm very very new to access and VB and any help would be greatly

When I executed the following in Access:
alter table t1 alter column c1 decimal(8,4);
I got an error message: "Syntax error in ALTER TABLE statement". I got
a similar error when I tried to add a decimal field. I know I can

This is a very stupid question, but it has been years since i've
touched databases so any help will be very appreciated.
I am designing a school registration database which also serves as an
analysis application for an LEA or something.

In Access2003 and XP.
My forms detail section hides behind the header when I scroll down to
see controls off screen.
This is similar to freezing a pane in Excel. I'd rather this did not

hi.,
i've got 3 tables, customer, film and filmrental.
i've got a customer form, with a sub form at the bottom, which is a film
rental subform.

    I want to to be able to read line by line the contents (ie the html)
inside some Data Access Pages I have in a Microsoft Access database.
There doesnt seem to be a call I can use in the Access library within VB
.net to allow me to read lines (there is for modules).

I use SetFocus to jump from one field to another. That works fine. But
one of the focussed fields has default text and this text is selected
and the cursor is on the left of it. How to have the curosr positioned
at the right of the default (or filled) text?

I'm trying to use the same subforms for two different mainforms. The first
main form is "frmSwaps" and the second main form is named "frmSwapsLive".
The recordsources for the subforms have parameters such as: [Forms]![frmSwaps]
![grpPayFixed]

Hi People
I need help!!!
Have got a excel file that i have put into an access file so that i can
create a mailing carrier sheet without re typing everybodys details in.