Search results

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

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

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

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

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

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

Okay I was working on this earlier and had it correct but then had to make some changes and lost the correct syntax and for the life of me cannot remember how I had it. Here is what I currently have which incorrect: strWhere = strWhere & "([RG]= between """ & Me.cmbRG1 & """ And """ &...

This is driving me nuts and have researched multiple threads on multiple sites and still cannot get this to work. I have 1 form with two controls on it (a text box named path, and a web browser control). I am trying to use use vba code in the forms oncurrent event and the [path] control...

First of let me apologize if this has already been covered for I have searched extensively and cannot seemed to find what I am looking for. I have a table, "tblDailyInfo", with a date field [EntryDate] formatted as date/field in long format, and a currency field [Cash]. In playing around...

Sorry if I missed this in another post, bit didn't see it when searched for. I have a form that has a [EntryDate] date/time field formatted as LongDate. This form also contains several currency formatted fields. I am using DSum to calculate one of these currenct fields but am wanting to...

I have a very small basic table containing these fields; Id, Date, Time, Name, and Amount. I also have a query with the same fields (although I don't know that the query is neccessary). I need a report that will display the records grouped by Date (which i can do) but also between hours on...

Okay, Have looked all over and can't seem to find the soultion, although some have come close but just not doin it. I have a form (Main) that has 2 forms on it (A and B). Both A and B are linked to Main and have same recordset, but are not linked to eacth other. Form A is a single form and...

Trying to figure out how to go to a different form control after the max field size has been reached on current form control.