Search results

I have a list of customer names, and part numbers. In my table I can lookup the customer’s name, and the part number automatically. Can I limit the lookup table to show only the part numbers relevant to each customer? Mike

I have a working DB, which gets the relevant data and creates a report. What I want to do is input a customer name as required. The name only wants to be input at that time, and may differ on each occasion. Basically it’s a text input for one use only. I don’t even want to save it. Mike

I have a table showing 15 chemical levels taken on a daily basis. Each row being the next days readings. What I want to do is to create another table which has minimum and maximum levels for the chemical in that field. i.e. Silicon in the table is 3, 3.05, 3.15 etc. The min level could be 2.6...

I have built a db, and all is fine. It is on a server and shared between 3 people. An error occurred and I need to repair it. I have copied the db to a laptop, repaired it. All ok. I cant repair the master on the server. It tells me that I am not the exclusive user (which I have tried to change...

Hi all, I have a db, and in my table |I have a collect and deliver field. This follows through a quary, a form for inputting addresses, and onto a report that I use as an order. The Collect and Delivery addresses appear when necessary. What I want to do, is only have the delivery text box on...

Hello all, I have built a purchase order db and created a box that shows my last purchase order number, so I can see it before entering a new number. ( I do not want autonumber) I have put in the code ( DMax .....) and it works fine. But... every time I run the form, it works. When I close or...

Hi guys, A simple one I hope. I have built a purchase order database, and I want to have reports on each category. Can I use one form combo box to give a category, which gives a secon combo box for items. Example Maintenance in tye first box, gives electrical,, or hydraulic etc in the second...

I have set up 5 tables in the tables area. I want to create a tab form with three pages, and use various data from all tables. It will only let me use data from one table. I have relationships between one field across all the tables. HELP !!