Recent content by Simon22

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...