Recent content by lbigk

I am using Access 2003, the report is based on a simple query, I open report from the form in Preview. SegmentID is one of the fields selected from the table. What I am trying to do is to hide duplicates, if necessary. For example: SegmentID=1 compared to a record with ID=001 SegmentID=2...

Me.SegmentID is being reset to 1 no matter which record it's on. When I make SegmentID visible on report, it shows what it should be 1,2,3... I am not sure why it's doing that.

Yes, I am not finding any issues, I did step by step through the code with individual records and even if the statement is true, it jumps to false.

I added a field directly on report nbrRecordCount: control source is =1

Hello, I have a simple If statement for the Details On Format. Please see example below: If Me.SegmentID>1 Then Me.Description.Visible=False Else Me.Description.Visible=True End If It worked just fine, until I added RecordCount field for additional validation. Now, the If statement always...

Thank you, it worked perfectly.

MajP, Thank you for the code, it's very clean. I am having problem with 'Public faytList As FindAsYouTypeListBox' line, I am getting a Compile error: A module is not a valid type. Any advice? Thank you, lbigk

Thank you, you are the best!

I am trying to execute the following code: Set rstQt = dbs.OpenRecordset("SELECT tmpWeeklyLF.State, tmpWeeklyLF.Year, tmpWeeklyLF.DP1, tmpWeeklyLF.Est1, tmpWeeklyLF.DP2, tmpWeeklyLF.Est2, tmpWeeklyLF.DP3, tmpWeeklyLF.Est3, tmpWeeklyLF.DP4, tmpWeeklyLF.Est4, tmpWeeklyLF.DP5, tmpWeeklyLF.Est5...

Thank you soooo much, between the 2 posts that I received, I was able to get exactly what I was looking for. Thank you.

JB, Thank you very much, it certainly pointed me in the right direction. I didn't consider DateAdd function before, I should be able to figure it out from here. Thank you again, lbigk

Hello, I need to get a Date for each Monday in the year. I have 2 variables Year and Week, so at the end what each record should have is: 2008 1 Jan-7 2008 2 Jan-14 Thank you.

OK, I think the simplest way would be to declare RespiteRate1 as a Global value and in the report query have a field with calculation Wages:[hours] * RespiteRate1

If all you are trying to do is view on the report, change the field from text to lablel and set .Caption = RespiteRate1. lbigk

I don't believe that you can load the data without Excel being open, but you can close it at the end of the code to avoide an Application running on the background. And, you can turn off warnings at the beginning of the code: DoCmd.SetWarnings False Hope this helps.