Need help Database genious

[Ratatapa]

Hi, work asked me to do a mini database for them but my Access knowledge is really low.

So here is something i need to do and maybe you can help me.

The database is really small :

I have 2 tables, 1 is our provider and 1 is the office (we have 2 office in Quebec)

I have 1 form, that is used to make a kind of bill.

The form use a list to decide which office the bill/items needs to be sent to.

While on the other side of the bill i have the provider list, which our "buyer" can choose to from who to buy the article.

I have made a relation between those 2 tables with primary key. I also wanted to make a table for the objects to buy, but the "buyer" asked me to put a text box instead since the item can change name + price often. And we have too many she doesn't want to always modify the table to add/rename items.


So my 3 problem is this

1) We have all the provider name + info in a .xls file, i tried to import them in a new table in access. The first sheet work but i cant add more sheets.

(our .xls is made like this , we have 1 sheet with the A 1 sheet for the B etc. So i can add the A to a new table but i can't add the B to the A table.


2) When i made the form i tried to test it, but i can't make new records in the form (the button is grey)

3) we need to make a Purchase order number there, but i have no idea how to make a line that will put a number automatic there. Aka we would need to start with number 15000 exemple. and each new record will made X+1 on the PO number.


Anyway i hope i explained it ok, hope people know the answer.


Btw we are on Access 2003

Thx

[Dense]

Excel to Access is often tricky. Here is an article that will explain how to make your data "ready."

Techniques for successfully importing Excel data into Access

As for making the PO numbers incremental, you have to create a new field (via tabledesign view) and select the data type "AutoNumber" for the field.

[Ratatapa]

Excel to Access is often tricky. Here is an article that will explain how to make your data "ready."

Techniques for successfully importing Excel data into Access

As for making the PO numbers incremental, you have to create a new field (via tabledesign view) and select the data type "AutoNumber" for the field.

so you want me to create a new table just for PO numbers?

[Mafai]

So my 3 problem is this

1) We have all the provider name + info in a .xls file, i tried to import them in a new table in access. The first sheet work but i cant add more sheets.

(our .xls is made like this , we have 1 sheet with the A 1 sheet for the B etc. So i can add the A to a new table but i can't add the B to the A table.

If you are trying to import multiple sheets into the same table, the column names in the excel sheet need to match the field names of your table, this will allow you to use the option to "Import into table:" instead of just the new table option.

2) When i made the form i tried to test it, but i can't make new records in the form (the button is grey)

I would need to see the form, there are millions of different ways you can add a new record using forms. I personally hate the real time updating forms, so I use buttons to add / update records.

3) we need to make a Purchase order number there, but i have no idea how to make a line that will put a number automatic there. Aka we would need to start with number 15000 exemple. and each new record will made X+1 on the PO number.

Which of the tables is holding purchases? It sounds like you need a third table. Client table | Products Table | Purchases Table

[Ratatapa]

I'm not database brain at all lol


I wanted to make the perchase as a form (i can try to post a Screen shot but it'S all in french)


don'T laugh at my layout this is just a test i will fix the layout after promise

[Mafai]

you mind making a copy of the DB and clearing all the tables and letting me have a look at it?

[Ratatapa]

achats.mdb - Dedicated Web Hosting Service

tell me how it goes

[Mafai]

do you have aim or msn at work?

[Ratatapa]

[email protected] (msn)

tell me its you or i block

[Mafai]

check ur pms for mine

[Ratatapa]

Thank you very much Mafai, everything seems to work #1.

Might need some change here and there over time ,but atm all is fine

Thx