Search results

Hi all, probably a silly question but is it possible to exclude certain boxes when a form is set to read only? My database essentially has 4 user levels (Developer, Admin, User and Guest), and whenever a Guest opens up a form, the form opens as Read Only and a message box displays telling you...

The form is called "Planner Query" and I want it so when "BENCH" is chosen in PRODUCTION DEPARTMENT, "BENCH" should show in MACHINE, but if the production department is anything else, then I want MACHINE to be my choice.

Thanks for that, but I can't for the life of me figure this out. I have a Single Row Source table, and I've entered in the code exactly as the site says, substituting the names for my comboboxes and tables, yet I get an error saying the record source doesn't exist? If it helps, my Row Source...

Hi all. I would like to know how to make a combobox select a specific value based on another combo box's selection. Basically, I have a box called Production Department and one called Machine. In the Production Department there are things like Machine, Bench, Fulfilment, etc and the Machine...

It's calculating it as (Quantity/Rate)/24 and I have to store it because we need to run a report so we can see how many hours each machine will be running for.

Hi all, thanks for everyone's help so far! Just a couple of quick questions now; Firstly, I have a time elapsed field (in HH:MM) and occasionally the time elapsed will go over 24 hours, however say a job runs for 30 and a half hours, the field will just show 06:30 when really I want it to...

Ok I think I've got it now! I ended up using the If Me.Combo1.Column(1) = etc, code and it worked fine, so thanks for at least having a look!

Here, it's very stripped down with only 2 records, as I can't really give information away about my company. In the planner query form, you can enter in the total qty, machine, bench, etc and choose the production department, and the run rate. the calculated boxes work out how long it takes...

Yeah if you give me a few minutes, I'll upload a stripped down version

Hi all, I have 4 text boxes that are serving as calculated fields on my form, and these are based off certain values in certain boxes, i.e the run rate and the quantity in a certain production department, so for example, the run rate is 5000, the production department is machine so the text...

Thanks for that, I'll give it a go on Monday! My combo boxes are named appropriately, I just put down Combo1, etc as an example for you. It looks a little overly complicated, when all I really want to do is filter several envelope sizes across different production departments so I can ultimately...

Yeah I've tried using both AND and OR, still with no luck. I had a go at making a Union query as well and all I kept getting was an SQL error saying it expect DELETE, SELECT and some others.

Hi all! Moving on from my last question, I managed to get seperate combo boxes to filter out results on a query, however now I have a slightly different problem. I managed to get the combo boxes to filter records in different query criteria, i.e criteria A for field A, criteria B for field...

it's alright, I managed to get it! I had to use the criteria and now it filters everything like it should without throwing up blank results!

Both my comboboxes are unbound, and the wildcards have both got quotes around them. I've attached a version of the DB. EDIT: The form named Planner Query is stripped down, as there was a bit of coding for creating new records, saving, navigating, etc, and it pushed it past the file size limit.

Hi all! Hope you guys can help. On my database, I have 2 forms. One is to enter data into a Master table, and the other is to specify search terms for a query, and I'm having a problem with the search form. I've got 2 combo boxes, a tick box and some text boxes which I use to specify...