Search results

Cannot seem to find an answer to this, but please point me in the correct way if you know of one! Quite simple i think, but blank mind at moment! How would i use the values in a table/query as the criteria for another query? I believed i could type in [qryOne]![classification] in the criteria...

I have a stock control database which i have nearly completed. This has Manufacturer, which is linked to products, which is linked to Sub Product(which also has field partCode). i.e. Manufacturer1 can have 3 products, and each of these products could have 5 subsystems and partcodes. Each...

nz - null values in queries - CRACKED!!! i have checked the forums and i know they kind of answer this question, but im not really sure where i am ment to write it! I have two queries, which a third query subtracts the 1st query and 2nd query values and gives the end value. If the 2nd value is...

How can i show command button if text box equals one or more query values? Hi, I have had a look at quite a few threads, but cannot find what i need. I am looking to show a command button if the value typed into the text box equals one of the values in the query. I understand how to show/hide...

Access error: you can't reference a property or method for a control unless the co... Hi, Can someone tell me what this error means? "You can't reference a property or method for a control unless the control has the focus. It is to do with a text box on a form, checking whether it has text in...

Hi, I am trying to do a search that will find all the records matching the customer number typed in another box on a different form. When i search a valid customer number, i.e. a number which is in the table, it will find the correct record, and close the other form. The problem is, if the...

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?

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

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

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