I need to create criteria in a query. It must select records where the first
3 characters in the field are the same as 3 characters in a text box on some
form.
I'm sure this is an easy one. I've done this before...somewhere...but I

I need your help to solve a problem exporting MS Access data to a text
file.
I have a table with 5 fields: Name, LastName, Address, City, Country.
When I export the data I need Name and LastName on the first row -

One minor annoyance with Access is that it seems to have its own ideas
about the size of windows it opens for the various views. I can reset the
window sizes as I open them, but as soon as I close them, the next time I
open them they have reverted to the size they were before.

I have taken over a database from someone else and need to edit some of
the report pages before printed. I have opened the database in
exclusive and tried to find the ones needing to be changed and they are
not under the forms, reports or pages. The only option I have is to

I'mworking on my database again. Here is the last question I asked that I
knowyou didn't see. It's in regards to your previous response to me...
What is it supposed to be? I'm confused.
"Klatuu" wrote:

I have a database where I have a number of transactions (numbered from 1 up)
with a number of transaction lines in each. For example, transaction 1 might
have 2 lines of info, transaction 2 may have 5 lines. I have a table with
the transaction lines in and I need to create a ...

I have a form design that when the user loads this form, the cursor appears
in a Number field.  When a number is typed in and Enter is pressed, the
cursor moves to a value field.  When the value is typed in and Enter pressed,
I would like the cursor to return to the Number field ...

I have a field for entering email address in form. The problem is that it is
displayed in the underlying table as the email address with the full
hyperlink address appended. Whether the data type is text or hyperlink makes
no difference it still displays with the email address ...

I have a table with the following info: Work Orders and tasks, I need to
setup the parent task: task 20's parent is task 10, etc, etc, etc
id, wo, task, parent
1, 2345-1, 10, null

Every time I create labels from my Query it omits all numbers (street
numbers; apartment numbers and zip codes). The street numbers are in the same
field as the street but it just omits the numbers.  Some apartment numbers
have a letter as well and it only displays the letter not ...

I have a field that shows up as 1234 but I need to add two zeros in
the middle so the field shows up as 120034. Is that possible? If so,
how would I do it?

When I type an email address into a form the underlying table displays the
address but appends appends a full hyperlink address to it. How can I
prevent this?
Thanks

It's been a couple of years since I've used this function.
I've tried the following as expressions in a query.
AnnualMin: FormatCurrency([MarketWage]*0.8)
Then I tried:

I was able to acccess a ms access 03 database before installing ms access
2007.
When I try to access the database now .The error is Your Microsoft Office
Access database or project contains a missing or broken reference to the file

Hi, my name is Nadia. I joined this Access community so that I can brush up
on my Access skills. I really think this is a great idea. :-)
Well, I'm going now.