Search results

its ok i worked it out! i cant believe i can be real dumb sometimes. I ended up changing my text box to a list box instead, so i could use: Me.lstFree.Requery in my code, where lstFree is the list box. Just thought id explain incase any1 else was as stupid as me!!! hah thanks for the help em

ah, i need to beable to refresh the text box once the button has been clicked. Do you know the code for this? I know how to do it if it was a requery but not just to refresh the text box to find the information from the field in the query. Thanks! Em :)

thanks, i think i cracked most of it. I now press a button and the value is displayed in a field in the query, just gotta work out how 2 get that into the tet box, as at the moment i am just getting "#Name?". In my text box control source i have clicked on the expression builder and selected the...

how do i subtract using a query though? I dont really know access that well, but am trying to work it out! could you explain what i will need to write? I have totalquantityallocated and totalquantity and want to subtract the 1st from the 2nd. Thanks for the help. Em

How do i subtract one value, worked out using a query, from another value, worked out using a query, and display it in a text box?

Its ok guys i worked it out, thanks anyway! em

I have a field, quantity, which i want to add all the quantities together to show a total. I want to do this using a query as i will use this total for other calculations. When in the query, i have selected "sum" in the totals column in the quantity. What do i need to do extra? I am not getting...

just wondering if you ever managed to sort this? this is the same thing as i am trying to do!!! emily

yeah i know but ive really confused myself, and ive tried to break it down into smaller questions, hoping one of the small bits will make it so i can do the lot! I read one post, and i have grouped rows, and then created another query which counts the rows in the previous query, but it only...

i have a query which find all the records of stock that are similar. I want to count how many of these there are. How would i go about doing this? I then want the user to type in the system they want, how many they want, and this will "remove" the system from the list, but not from stock i.e...

you've had this problem before?

excuse me, "crosstab query wizard"

when you go to create a new query, click on new, and there is an option to create cross tab query in there.

Hi, I am creating a database which keeps control of stock. Each item is scanned in with a barcode scanner and given a unique stock number. The Manufacturer, System, Subsystem, Location and Classification is then added. When a customer phones, and orders a product i.e. a camera, a customer...

Hi, I am creating a database which keeps control of stock. Each item is scanned in with a barcode scanner and given a unique stock number. The Manufacturer, System, Subsystem, Location and Classification is then added. When a customer phones, and orders a product i.e. a camera, a customer...