Search results for query: *

No apology needed :) That is what I was using it for though. The Autonumber is used as the primary key in my COrders table. COrder_Num (Autonumber) (PK) COrder_Date (Date) Client_ID (FK) With related table COrderLines COrder_Num (Number)(FK)(PK) CLine_Num (Number)(PK) Prod_ID (FK)...

What I know of Autonumbers comes from the MS Access 2000 Help file. Blame it on the designers. Actually, I'm taking a db desing course right now (Dalhousie University) and they use the Autonumber the same way as the Access help file. I think that JimHorton is correct. Access was designed and...

Thanks for the help guys but this is out of my league. See y'all round.

IC - so I guess I shouldn't compact and repair this thing. Too bad.. Thanks for the reply.

Hi all, Can anyone tell me why Access is reseting my autonumber fields to 0 everytime I move the db from one computer to another? Can I stop it from doing this? It is messing up my order system because the reset autonumber is making duplicate entries in my primary key field. Thanks for the...

Thank you Zeroanarchy :)

Now, I'll start again... Is there any way that I can tell Access to leave my form sizes alone? I would like every form and report to open in the size that I saved it as. Access seems to like maximizing and restoring withough consulting me. Thanks

Although, come to think of it, you didn't happen to notice that I say thank you in most of my posts. Thanks for wasting your time.

I was not aware of that feature but thank you for unmasking my ignorance :( Oh, and pardon my poor language.....

AAAAAHHHHH!!!!! Access is enraging me!!! Everytime I get all my forms set to a nice size, Access either changes the size or maximize it or does some other darn thing to make it look like crap. Is there any way that I can tell Access to leave my darn form sizes alone?

Thanks. That second post is exactly what I wanted. Any way to get the month name instead of the month number?

Hi all, Can someone tell me if it is possible to group records by month? I would like my query to show the sum of clientordertotals ($) by month. For example: January: $500 February: $1000 However, I can't seem to get Access to group by month. Thanks for your help!

Hi all, I pretty sure that this is a simple question but it'd the details that I don't know. My db need to create and destroy a table during one of the transactions. I need to create some thing (module, macro etc..) that will create a table automatically. Here are the specifics...

Will this work in Access 2000? I copied and pasted the code but I get "Compile Error: Method or data member not found" refering to 'RS.Findfirst'. I can follow the instructions but I don't know much about VBA so there's no way that I could dissect this. Thanks :)

Hi all!! I am having some trouble with an order form. The form consists of the main form (ClientOrder) which is used to select the client's company address and contact info, and the subform (ClientOrder subform) which is used to select the products and amount. The subform is in datasheet...

Thank you very much. I'll give it a try!

Hi all, I have a sales form that list the client's name/address with a subform that is used to make the invoice. The subform is displayed in datasheet view and has the following columns (Product_ID, Product_Description, Product_Cost, Number_of_Units, (Row Subtotal =...

Hi all! I had a nice relationships table with all my relationships defined between the main entities. However, after a whole bunch of designing of forms and adding features, my relationships window has become cluttered with a load of relationships that I do not recognize. Some are names of...

Very cool! Thanks :)

Hi all! Firstly, thanks to all the good people who have answered my numerous questions :) Second, my problem: I would like to query my employee and employee_type (eng, adm, sci ect..) using a parameter to tell the query what kind of employee records I want returned. For example: list all...