Search results
-
N
Filtering a subform from a combo box?
Great! You have been a fantastic help! Thanks, NS -
N
Filtering a subform from a combo box?
Fantastic! Thanks very much. The only thing I notice is that you can't clear the filter, so if I want to see all records again, I cant choose * or "All" from the drop down. Is there any way around this? Many thanks, NS. Reason for edit: No longer get the error msg. -
N
Filtering a subform from a combo box?
Oh right - yes, it's unbound (no record source on the main form). The combo box has the ID I want to filter in it and it is the first column in the combo box. The code you posted earlier works but I just need to filter rather than find the first. I did try to change FindFirst to Filter but got... -
N
Filtering a subform from a combo box?
I guess so. How would I find this out? .....It's basically just a simple form that has the subform in it and a combo box. Thanks, -NS -
N
Filtering a subform from a combo box?
Hi, Just as a follow up to this. I have just (stupidly) realised that this doesn't do exactly as needed. It would like the combobox to actually FILTER the subform, not simply find the first record. i.e. If I select ABC from the combobox, I would like to see just the records with ABC. Hope you... -
N
SUM'ing fields depending on IF a cetain value exists in another?
Thanks for all your replies on this! I have sorted the original issue. However, I now have a further question. I have created a derived field (Total) but down I would like to create a second derived field that uses the other derived field. I have got this to work but each time the query is ran... -
N
Problem filtering a simple query!
Hey all, Probably a bit of a newbie question but I have a very simple query that I cannot filter! I basically have 1 table that the query works on. It is the Employee table and I would like to query for Employee and Line Manager, this works fine but when I add a criteria of [Please enter... -
N
SUM'ing fields depending on IF a cetain value exists in another?
Excellent, many thanks! -
N
SUM'ing fields depending on IF a cetain value exists in another?
Thanks. WHen I say field I mean a "cell" on a query or table..if that makes sense. -
N
SUM'ing fields depending on IF a cetain value exists in another?
Thanks for your reply. I;m not sure if that is what I am looking (I possibly used SUM incorrectly). If I can explain in simple terms... Price: IIF fieldC is >0 Then (fieldA + fieldC) Else (fieldA + fieldB). Can I put something like that into a query that Access will understand? Thanks, -NS -
N
SUM'ing fields depending on IF a cetain value exists in another?
Hey all, I am quickly learning lots about Access but this one has me a little stumped. I need to SUM, say 2 or 3 fields in a query but only if there is a value present in another field (on another table). How difficult is this to do? I am assuming I need to use the IIF function? I would like... -
N
Joining 2 fields?
Many thanks for this. I will give this a try tomorrow :) -
N
Joining 2 fields?
I just didn't want to use a query as these fields will be used in a subform that will be used to create/delete records. I understand that inputting/deleting from a query can sometimes be difficult? -
N
Joining 2 fields?
Hey all, Not sure this can be done but I have 3 fields in a table. Forename, Surname and Full Name. If possible I would like Full Name to automatically populated from the other 2 fields. However, and here is the problem....I don't want to do this in a query but just just in the table it self... -
N
Filtering a subform from a combo box?
Great, I'll give it a try and let you know :) -
N
Filtering a subform from a combo box?
Excellent, I will truy this on Monday and let u know. Just out of interest, what is the Nz bit in the vba code? Thanks, -NS -
N
Filtering a subform from a combo box?
You got it. The ID is an Autonumber. -
N
Filtering a subform from a combo box?
Many thanks for this! The combo box will be area codes however, I assume I can just put the ID as the first column and hide it? ...also I'm not too sure on the bound bit....sorry, I'm still learning Access really.