Recent content by kicken18

i guess so, it just says.. File Orginisation Description of file orginisation (How does access store files)

I am doing my comptuer science coursework and one thing I need to include is "how does access stored files" and the basic description of file organisation. After some googlging around though I have found nothing, can anyone hlep me out on this? Thanks Chris

haha no idear why I didnt try that, thats been bugging me for ages now Thanks alot Chris

I have a report that is an invoice for a customers order. It displays the orders that the customer has placed and the cost of each order. At the bottom in the Page Footer i have put a text field with =sum([Cost] but all i get is #error and I have tried changing it to Running sum over group and...

yes, but thats not the question here, my question is i am trying to write something which looks at a customer ID and if they have > 5 order ID's (they have over 5 orders) then a message box comes up. Now in SQL its TBL_Customers.CustomerID do i write the same in VBA?

in VBA, i want to write something along the lines of if Customer Name = Orders > 5 PromptBox "sorry only 5 orders max" do i just use the varible names like in SQL like TBL_Customer.CustomerID or is it differnt for VBA Thanks Chris

yess it worked but now i have a small problem where i press the button (to urn the query) it brings up a box saying ID and then a prompt. If i type in the order ID then it does add a 1 in the correct turkey but i dont want to have to key in the order ID, i just want it to do it. Here is my code...

ok yes that does make sense, and i did think of a simular sort of idea ealier but this seams easier. The problem i have is setting the ID to the order ID, since this could be anything from 1 to..99999 or something, it obvislly needs to be a varbiel, so do i just set it as where ID =...

i have an order form in which a turkey is picked from the order form by the weight (i.e a customer phones up and says i want a turkey of this weight and a turkey of that weight or somehting closer is picked) thats bit is done. I have ym turkey table with Id and weight in an order form and...

wehey,database fun and a date...where will the fun end oddjob

:eek: Access...Shit...Pfft, try writing it all in SQL Boy ;)

well i understand the first bit, and i understand the bit of where turkey ID = from my sue of SQL with PHP but i am unsure of this bit "" & cboBox.column(2) & "';" currentdb.execute sSql" im guessing the second bit is easy but the fist bit...what is column(2) about? Thanks

no one got any ideas?

I am developing a database for a buisness. a Customer phones up, gives the details and I pick the details from a drop down list which is from a table. Basically the details will be taken down, a turkey weight will be picked from the drop down list and this will then be removed form the table...

Pat, what kind of code would we be looking at here. I understand where to enter it and everything, but not what i would be entering as the code for it to round