Search results

Re: SOLVED Form Filter Property using Nested Iif Statement Okay I found out that I was totally overthinking this whole thing. After re-evaluating my goals, I found that I could accomplish the task without needing nested Iif Statements which allowed me to filter the form the way I needed. Thank...

I apologize, I was trying to keep it short winded. Too short I guess. I have a form based on a query where the query has several criteria for several fields. On this form I am am using a text box that counts (sums using if statements) for the control source of this text box. Then when the form...

Is it possible to use a nested Iif statement in the form filter property? If so can someone show me some quick syntax on how this could be accomplished. I am using 3 different query field null values together with and/or in the 3 level nested iif statement. If this is not possible, would...

[SOLVED] Problems with Linking Master/Child Fields to Subform Control After stumbling on another thread http://www.access-programmers.co.uk/forums/showthread.php?t=204635 posted by JamesMcS, after some editing to the subform control; frmFormHolder and utilizing the oder of events as he posted...

Sorry Forgot to mention that I am using Access 2007.

HI Guys, I am not new to Access or VBA, but certainly not an expert either. Structure: I have form that is a background form; frmSplash Within frmSplash I have 2 continuous forms; cfrmInstitutions and cfrmPatients, and 1 additional subform control; frmFormHolder. cfrmInstitutions has only 1...

Thank you so much, my headache has disappeared. Works like charm with the only correction needed was changing your Me.Parent.sfrm2.Form.cbo1.RowSource = s to Forms!Parent!sfrm2.Form!cbo1.RowSource = s

Still learning in the finer points of Access and VBA and needing help here. I have a tab control with two a subform (sfrm1) on one tab and a subform (sfrm2) on another tab. I have a subform (sfrm1) with two numeric controls (SL) and (EL) whose values are chosen by the user. I have another...

Very helpful Glaxiom. The "Sphisticated Coded Way" sounds more like the route I would need to take. A couple questions though, In specifing the OpenArg for the form open event, as in the code I already have: DoCmd.OpenForm "frmBowlerSpecs", , , "[BowlerInfoID] = " & Me.[BowlerInfoID], don't I...

I was trying to prevent that and having to rereference my VBA coding. If that is what I must do, then so be it but take a look at the folllwoing info and tell me what you think please? UPDATE: By chance that my original post was unclear, this is what is happening: I have 2 tables, 2...

Is it possible to change the slection type of a form from form to subform? Having a problem passing the unique value of the first form to the second form when the relations are set properly so I was trying to make the second (unconnected, but related) form a subfrom and edit its linked fields.

First to PNGBILL, Hi again. I do understand that with the dlookup() it is easy to find the matching record, but within that record, there is one possible value that can be returned for each column (10) in the table, leaving 10 possible values. I am not undrstanding how dlookup() can narrow this...

Yes I have tried dlookup() but because I do not know what value will be returned, I was having a problem with the criteria as the criteria would actually need to be the specific column in which to find the value. I understood the criteria as being a value already known, which we don't. I...

First, I apologize if this has already been specifically covered, however, the further I search for the answer or example, the more confused I seem to get. Second, I hope my explanation of the situation and requested goal is clear. I have a form; frmbowlerspecs that contains a few user input...

Okay I understand somewhat. The reason for the Select Case AT = 2.5 is because that value can also be changed by the user. But when that value is changed the same AR BS and RR comparisons are still compared only returning different value for IMBR1 and IMBR2. I understand taht this may be...

Just tried that code I attached and it does not work at all. Back to the drawing board.

I think your on to something with dim three variables, which I have done because the project is explicit, however, being kind of a novice with vba, I am not sure how to store and retrieve, or as you say, bring forward, the variables I am looking to compare. Here is a small example of what I am...

This is a little confusing but I will try to make it clear. I have the controls on a form whose values are filled by the user; AR, BS, and RR. My vba code compares two of these values at any given time, not all three, and returns a determined value to another control on the form if the...

Thanx Chris. Worked perfectly. :)

Okay, so I have continuous form that has a DueDate (date data type, formatted to medium date) control and a Completed (date data type, formatted to medium date) control. I am tryping to pass Completed.Value from the previous record to the DueDate.DefaultValue of the current record using an...