Search results

Works a treat. Thanks. Mike

Lookup Hey Jack How are you ?. No I have one table, Field 1 is Customer, field 2 is Part Number, and 3 is description. If I select "Ford" as my customer, I want only the Ford part numbers allowed in my Part Number filed lookup. Does this make sense ? Mike

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

No Problem Mike :D

Open the table that houses the data. open in the design mode and select the field that you want to sort. On the bottom of the page, select indexed. You have No , Yes with duplicates and yes with no duplicates. Select either of the yes options, depending on your choice. Close and save. That field...

When you craeted the combo box using the wizard or whatever, you have only selected the ID Field. Create your combo box, select that you want to look up in a table or query, select the table, and then select both the ID and the E name fields. Then store the value for later if you wish. When you...

Do you have this information running in your query ? If you do, you can show all the data relating to your ID number. Just explain a bit more. Mike

Keeps comming up with a " missing endif" error. Mike

Thanks for the reply, I'll give it a go !! Mike

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

It looks ok to me. I have just tried it on a test db, and it works. Mike

Dates In the query that you have made, you will ( or should have ) the date field. In the criteria box simply type "Between [Enter First Date] And [Enter Last Date]" Don't put the " " in though. When the query runs, it will ask for A First date and Last date. Only records with dates between...

Yipee Work a dream. Thanks, Mike:D

macro error PDX Man My On current event code is: Me.Last PO Number.Requery I have a text box with this code in that gives me the last record number. =DMax("[Purchase Number]","Purchase Table") I have removed the Me. but the error still shows every time I move through the records. I have no...

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

SK Data base attached. When you open the Main Purchase form, You will see the category combo box. This houses all the items in my category list. I want to say have a "consumable" category and this would bring up grinding tools , cleaning consumables etc. Your help is very much appreciated...

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