I have a database that has 70,000 parts and what i  have a form that has a
text box that when you type in the part number and hit  enter it would
populate the other 20  fields of info related to that part and also i want to
put a subform on that  page that will be attached ot  ...

In my database two of the fields relate to date. 1 is for year (4 digit)
while the other is the date of creation (date format in form dd/mm/yy ie
23/1/2007).
Is there a way to automatically fill in the year field when the date is

I am using Access 2003
I want to created a field in a Db design that only shows me the month and
year.
What is the input mask I use to get only the month and year displayed.

I have a table and in the table there is a column with data in the column
seperated by a ;    I know I can use text to columns in excel but this is
670,000 rows.  Is there a way to seperate this in the table?

Trying to set up my invoice database to automatically enter product name and
price according to the item number I enter.
Can anyone help me?

Hi, I would really appreciate some help on the following query:
I would like to design a db that captures employee data. At the moment
in the Employees table I have an entry for a team. However, it only
captures the "Current" team the employee belongs to. If the employee

I have a table in Access that I run many update queries on to get the data
in the correct format. Once this is completed, I then need to export this
data into an Excel workbook onto a specific worksheet, where I then have
Pivot Tables setup to use this data. I have been copying ...

In my database, I have a linked table called SOtbtext which contain 2
fields, FreeTextCode (Number) and FreeText (Memo) - what is puzzling
me is that in the field FreeText, the field appears to be blank, but
if you do a search for what should be in there - it highlights the

I have to import data from several various excel files and other tables into
an application. I need to import each file into its own temporary table that
can be over written each month. I want to create command buttons to do this
process from a form.

I have my paper and pencil out, but nothing is coming to my mind, so I
thought I'd see if you guys could get me started.  I am currently using
Outlook to schedule rooms at my school.  I have a calendar for each room, and
I want to be able to print a weekly report for my ...

tbl_parts:
part_id - autonumber - pk
part_description - text
tbl_bom:  (bill of material)

I am ready to scream. I have been trying to get this right for months. I have
a customer invoiceing database that has worked very well for me. But takes
longer to fill in.
Currently I have to key in the product ID number, the quantity, Type in the

I have an ID field that is an AutoNumber. This database has been working well.
Know all of the sudden the AutoNumber is trying to re-assigning exsiting
numbers. It's failing as would be expected. The next Autonumber should be
157763, but it's trying to start again in the 30098 range ...

I have 3 tables then another table (loc_adjustment) that has joins all 3
tables.
id
value

I have a master database called "Master List".  It contains ID, Name,
Address, phone, etc.
I have a detail database called "Transactions" It contains, ID, Transaction,
event, date, etc. (many records for each in "Master List")