Search results

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

ok thanks!!!!

I am having some problems with rounding numbers. I have a DB using forms and i want the user to enter a weight and it rounds to the nearest half KG, so either ?.5 or ?.0 depending on what the number is. I know i can enter a range check in the table validation or say => 5 AND <= 10 but i am stuck...

I like oranges...also satsumers :eek:

lol as i said, i dont know very much about Access queries so how can i query a query. Do you mean set up a query that gives me the results, and then have a query that runs using the data from that query?

ok yes that does work, but not in my example. See here you used client ID and added all the records for client ID, which words with mine, but i have 1 server per client, so i want to add the cost for each client, so client 1,2,3,4,5 are displayed with cost next to it, i want a total cost of all...