Search results

no worries. i will give your qry suggestion a try. you have been much help, thank you

i am having trouble with the "Or" statement;Option Compare Database Option Explicit Sub printFlu(optArgs As String) Dim repFilStr As String repFilStr = "clstrFlu = True Or clstrHep = True Or clstrTdap = True" & IIF(Len(optArgs)>0, " AND " & optArgs, vbNullString) DoCmd.OpenReport "rptFlu"...

Thank you for your quick reply, Paul, works great Thanks again for setting me on the right path!!

I am stuck. I am trying to create a public function that will print a report so that i can call the report from different forms. i have this code that opens rptFlu (bound to qryClinicData - query is not filtered); Option Compare Database Option Explicit Function printFlu() DoCmd.OpenReport...

thanks CJ. this project is looking match cleaner with your help. i also replaced the if statements with abs. Bryan

:o the if tests the table field the code is Option Explicit Dim tglht As Double, lftPos As Double Private Sub Form_Load() ' 1440 twips = 1 inch; multiply twips x inch tglht = 0.3 * 1440 lftPos = 0.2 * 1440 Dim i As Integer For i = 1 To 6 Me("s" & i).Height = 0...

would the code be - "If Not IsNull(Me!lodstrSSN) Then Me!tgl1.Height = .3 * 1440 Else Me!tgl1.Height = 0" ? when i use this code i get control overlap. i have attached a screen shot

thanks for your help, CJ. i do learn much easier by example. i also tried to set the "c" height to '0' to hide the control when my table field is null, but i haven't figured that out yet. right now i am using the visible control to hide -- but the white space is still on the form between "c1"...

Thank you for the reply, CJ. But I am afraid that I am still not getting it. I guessed that "control1" is the top most control, "control2" is is next...etc. So i replaced "control1" with tglLOD, "control2" with tglTemp...etc, but i end up with the controls stacked on one another! What am i doing...

Thanks for your reply CJ. I am new to VBA, so how would i use your code? Thanks, Bryan

I have so many if...then statements that I am getting lost in my own code. In my attached file, I have 6 toggle buttons that make subforms visible=true and visible=false when clicked. All buttons work as expected when all toggles are visible, but not when only some toggles are visible. If you...

the dates will always be continuous. the state and status may change...

I am new to Access and to this forum. i apologize if this should have been posted under "Querys". i have been trying to create a query or VBA that will calculate time in service from the following table. this table consists of 10,000 records. strID separates time in service between members...

hello all, i am new to Access and do not know how to use VBA, but thanks to this site, i am learning bryan