Search results

I just noticed you said "where subform controls are bound to the fields returned in your query", so I guess the answer is yes!

@DocMan - what I am trying to do is output the results to EITHER a report or a subform - sorry if that wasn't clear in my post. @CJ_London - perhaps a daft one, but when I add the subform it takes me through the wizard to add the fields from tables etc. Do I do this mirroring the fields that...

Probably an easy one for somebody but I've hit the wall after 3.5 hours tonight. I have a form, on it is a combo box. There are also two text boxes set to date format where the user can enter Start and End dates. Dependent upon the value selected by the user from the combo box and the date...

Cheers PLog, I'll look at it after the weekend. I have my hours in this week so I'm focusing on other things, such as life for a few days :D Thanks, Lol

Yeah I've been playing with that although perhaps it's my twisted brain but I found it easy to follow :D

I have a simple query I'm trying to finish off and it could be idiocy or just tiredness but I just can't get it to work! I have two fields, Tbl_Issue.Qty_Issue and Tbl_PPE.Unit_Price. I can get a query to return a subtotal for each instance of clothing being issued but I CANNOT get it to...

I've sorted it Pat, just been up to the neck with other stuff to come on and post the solution. What i did was have the following tables: Tbl_Employee - as it suggests Tbl_PPE - clothing table now incorporating masks and harnesses Tbl_Issue - junction table between the two above Tbl_Size not...

I see now, I never thought of putting a table together with the variants of item and size, I was using separate tables for size and item and inserting those, or trying to, with cascading combo boxes into a table that logged items issued to each person. I'm very familiar with the junction table...

Hi, I thought I had a handle on this data but I didn't, so if anyone could offer some suggestions for structure then that would be great. The data is thus: Clothing: Fleece, T-Shirt, Polo Shirt, Hi-Viz These are available in a multitude of sizes from XS to XXXL Helmets: Orange, White, Blue...

Okay, having done much reading on the internet I'm going to abandon this line of approach. I need to get some expert help on normalising data for this one so I 'll post where appropriate. Thanks for help so far, Lol.

Now that explains a lot to me about how combo boxes work. Thanks!

I hear what you say. I don't like having users select from a non-descriptive ID number, I prefer where possible to allow them to select from actual meaningful data i.e. fleece, shirt,socks etc I considered putting the descriptions in a table of their own instead of inputting them in a list for...

Hi, I'm working on a form and have several combo boxes on it for choosing which data to enter. I am trying to alter the rowsource for a combobox using vba in the AfterUpdate event of the first combobox. Clear as mud so far? This is the code I am using and nothing is happening. I have tried using...

To be honest the company doesn't know what it wants or needs really, so I'm working on the premise "This is what I think you need based on what I can ascertain from what you have and our chats" which I caveat with "once you've got it tell me what else you need and I'll make it work". It's a...

Off track slightly, my father, born early 1920's was left handed, beaten with a stick to use his right hand, and known as a "sinisterist" for his left handed tendencies!

Interestingly I was pursuing a position in the church and as a chaplain :D I'm right handed though :) Hope my previous lengthy post makes some sense.

Ridders all I know is the whole form just didn't work! I'm frustrated as hell because believe it or not, or perhaps you do,I am a product of the English educational system of IT at higher levels! I have an HNC in Business IT and an HND in Applied Computing. On the course we were taught the most...

Okay,the company has a fleet of vehicles which are allotted to a tradesman pretty much for as long as they work for the company or until the vehicle is replaced. They also issue fuel cards to drivers and obviously need to keep a list of drivers in the company including who is legally allowed to...

Well I tried it and it caused so much carnage I had to import forms from a backup to replace the ones I was trying to "improve".

Hi, probably a simple one but I can't find the answer and my brain is very tired so here goes: I have a form with two subforms, I created it through the form wizard, and all is groovy. However, I have added a data field to the table that is the data source for one of the subforms. I now wish to...