Search results for query: *

that was easy - thanks.

I have a row of checkboxes to show work stages completed. If I check box stage4 - I want stage1, stage2 and stage3 to be checked. Below is how I was trying to get Stage3 to check itself. It is on the AfterUpdate. It does not work. Please show me how. Thanks; Steve Private Sub...

I am trying to count the records in the detail section withing a group. Where the quantity of records is >1 I want to suppress that group & detail. Group Name: Person Record: Address 1 Record: Address 2 Count of the detail for this person would be 2 and so would be suppressed in the report...

PH - That's exactly what I wanted Thanks.

learning is what i am trying. I will use my nested IIF in the query. thanks anyway.

Thanks Skip, I think you are saying that Case won't work here so how about IF's like this. will Else: CostCodeN = Left(myActivityCode, 1) & "00000" capture everything that falls through the other IF's. Thanks If (myActivityCode) = "201900" Then CostCodeN = "201900" Else If...

I am trying to use a Case statement however the red part as below is being ignored. Can anyone point out my error. Thanks; Steve Select Case (myActivityCode) Case 201900 CostCodeN = "201900" Case 201901 CostCodeN = "201901" Select Case Left(myActivityCode, 3) Case "950"...

Thanks

I am trying to open a form in datasheet format from a button. Even thoug the form itself is set to datasheet view it opens as a single form. I suspect I need to add something between the commas on the Do.Cmd statement, but what? Dim stDocName As String Dim stLinkCriteria As String...

I have a start and end date field on a switchboard, this allows the user to select a date range to filter a report. I am using an unbound text box to hold the start and end dates, however this requires the user to reenter the date every time the form is reopened. How can I store those values - I...

PH Thanks; When I run the query I get a type conversion error for 2940 rows. If I run it anyway it removes ALL of the 201901 in the jobnumber field; Jobnumber and Counter are both number fields. Any other ideas? Thanks

I have some data as shown below. It is storted by the qryLinks_link field (name and date) then by counter. I need to change the job number when it is 201901. For each qryLink_link when the first jobnumber is 201901 it needs to be replaced with the jobnumber in the next record. If there is only...

Got it; Thanks all.

I am trying to filter by date and not getting the right answer I think the problem is that the field I am filtering is a date time field. 1/16/2006 6:30:00 AM I am asking for data greater than 1/16/06 but it is including 1/16/06 I am assuming because my filter is 1/16/06 (at 0:00:00) so that...

Freeze panels were not on. I eventually made some new data on a new sheet in the workbook and the filter worked. I copied the whole sheet to the new sheet and the filter dod not work. I copied the data without header row added my own header and it worked. I then copied the header from the bad...

Thanks but no hidden rows...

I received a spreadsheet which has about 700 rows. When I turn on the autofilter on the top row it does not give me the list of values; actually it just gives me the first value in the row beneath the header row where the autofilter is set. There are no blank rows. Why does this filter not...

PH - Got it thanks.

Sorry about the header; How can I change it

The results of a cross tab query are shown below. I need to filter these results in a report and am trying the code beneath. I only want to see the rows where an employee's time is greater than 8 hours on any day AND when it is charged to code 3101. In the example below it should return 2 rows...