I have a text field PO# which is my key field.  Every month the PO# changes  
(i.e. OCT 2006 - PO-FY601-001, NOV 2006  PO-FY602-001,002,003 etc).  I have
an append query the I run to reset the FY6## every month.  Is there any way
to automatically increase the last three digits?

In design view, I am trying to use the variable contents one one field to use
as the default data in another field w/in the same table. I am trying to use
the DateAdd Function in this way..."DateAdd(d,135,[Field Name])" (The
parenthesis are not part of the function). I get back ...

Ok, since I am really a novice to Access (indeed, to relational databases,
and databases of any sort), please be patient if I do not word my question
properly.
Although I am the only one who uses the database in our office, I do not

  i really want to use my own picture in word pad how can i do that.cos i
hav tried several time but it still doesn`t work. so i need your help
please.cos i need to use the picture. bye.thank you .
----------------

I have imported a bBASE table, and was wondering if there is a way to edit
the numbers within the records so it only displays 2 decimal points instead
of 5.
Is this possible, or does it have to be done before it is imported into

I need to edit an attached file of names/dates for a website with frontpage?  
I have never used before.  Please assist.  Thanks

hi, I am creating a database for supply chain.I have some questions.
My first table has Site Index (PK)
site index
site name

I am a novice at Access, but I thought I understood the basics of it. I
created this DB, which I thought was simple and straightforward, but I guess
I was wrong. Separately, the main form and its subforms work well, but  I
have problems when I join them together. I have a main ...

I am a beginner at Access. How do I set a table to add additional cities to
pick from a list and the city only show up one time on the drop down list?
Ex. I added Smyrna and Nashville to the table and have set a relationship of
the City field to that table. When I add other cities ...

I just turned off auto-index & now need to delete the duplicate indexes it
caused. How?

hi all can someone please help,  
i am using the above template.  I have created a unit cost field in the
products table i just need to know how i can get access to automaticlly enter
this cost into the inventry transactions table when i select the product

I want to use the username from the Access login to auto populate the
employee field when clearing a ticket.  Can it be pulled from the information
that they logged in with (not windows password).

Hi all :-)  - Access 2003 - XP Pro SP2
I need to filter data in a table by one or more criteria, such as parcel
number, zip code, map number, etc. either one or more, to look up
information for geographic surveys, maintenance and assessments.

hey all,
how do receipts tie in to the payments table and invoice table? does it
usually have it's own table? if so, how does it relate to the other tables?
thanks,

ok i'm only 15 and i'm trying to make a slide show but i cant figer out how
to do it. since I want to put the show onto a program I have, but every thing
I try doesnt work.