Search results

  1. C

    Use the same report with different query's

    Absolutely, yes.
  2. C

    Use the same report with different query's

    Nope, same error. The report doesn't have any records bound to it.
  3. C

    Use the same report with different query's

    Hi Bob, I get the same error message.
  4. C

    Use the same report with different query's

    Ranman256, thanks. The two query's I want to use with the same report are exactly the same, except two fields in the query have different Criteria. The criteria for query #1 is based on which form the user clicked on, i.e. a WorkNbr on form A and in query #2 it is based on form B. Therefore...
  5. C

    Use the same report with different query's

    Hi, I want to use the same report with different. If the user is on Form "A" and they click on a button it will use: Private Sub Command105_Click() Dim WhichQuery As String WhichQuery = "Invoice Query-3-Bulk-Reinvoice" DoCmd.OpenReport "Invoice Report-BulkTest", acViewPreview...
  6. C

    Go to the last record minus 5 records on a continuous form

    I have a continuous form and when it opens, I would like it to go to the last record, (or a new record), minus 5 records. I'm trying to make it easy for a user to add a new record yet when you use Go To New when a continuous form opens, you see at the top of the form a blank row to start...
  7. C

    Need to filter rows on a Continuous Form

    Thanks. I'll do some more testing but I think your suggestion has solved my problem. Now, I'll go wash my hands and keep my distance, other than from my wife and dog. Take care.
  8. C

    Need to filter rows on a Continuous Form

    CJL, thank you, your suggestion worked. It resulted in either a 0 or a 1 for the "DCount" calculation which then made it easy to set criteria = 0. Thank you very much!
  9. C

    Need to filter rows on a Continuous Form

    Job Order numbers can repeat, but not for the same employee. I don't think that will help. The issue in my mind keeps going back to how do I find the first, (or last, or unique), WorkNbr for the query.
  10. C

    Need to filter rows on a Continuous Form

    There is an ID field, but since the ID field is different for each row I'm back to trying to figure out how do determine if a row is the second occurence of a WorkNbr. CJ London, maybe the attached PDF will help.
  11. C

    Need to filter rows on a Continuous Form

    Hi dbg. As far as I can tell, right-clicking on the WorkNbr field doesn't allow you to filter out a record if it is the second or more occurrence of that WorkNbr, number.
  12. C

    Need to filter rows on a Continuous Form

    I have a continuous form. The form displays rows from a query. An important field is the WorkNbr, which is a number field. I need to find a way to display only one WorkNbr row if there is more than one WorkNbr in the Query. I can't use a Totals query because the user needs to input data into...
  13. C

    Change certain Excel row 1 cell values

    All right, Halloween is over! That means Trick or Treats is over too. In the suggested coding, wb.Sheets(1).Cells(3,1)="Cust ID", I interpeted the 3,1 to mean column 3 and row 1. It turns out they were reversed. I looked that up and reversed them and it works perfectly. It should be...
  14. C

    Change certain Excel row 1 cell values

    Hi DBG, After the last line in my original posting, it has: DoCmd.SetWarnings False DoCmd.OpenQuery "Delete TempSalesData" DoCmd.Close acQuery, "Delete TempSalesData" Call DoCmd.TransferSpreadsheet(acImport, acSpreadsheetTypeExcel12, "TempSalesData", strExcelPath, True) The spreadsheet that...
  15. C

    Change certain Excel row 1 cell values

    Thanks everyone. I added 6 lines to the code: wb.Sheets(1).Cells(3, 1) = "Cust ID" wb.Sheets(1).Cells(12, 1) = "Ext Sell" wb.Sheets(1).Cells(22, 1) = "City2" wb.Sheets(1).Cells(23, 1) = "State2" wb.Sheets(1).Cells(24, 1) = "Country2" wb.Sheets(1).Cells(27, 1) = "Rep ID"...
  16. C

    Change certain Excel row 1 cell values

    Thank you Paul and DBG. I guess my question is since I'm using wb.Sheets(1)..... to define what the the formatting of the columns are, where do I use, wb.Sheets(1).Cells(3,1)="Cust ID"? Is that a new line beneath all of the existing wb.Sheets? Chuck
  17. C

    Change certain Excel row 1 cell values

    Hi, I'm writing VBA code to import a spreadsheet. Row 1 has the field names in an Access table. It works fine except there are 6 columns in row 1 where I need to change the name because they either have a period in the cell or the cell is a duplicate from an earlier column. A portion of the...
  18. C

    Insert contents of HTML file into Outlook body

    I have a HTML file, “Trip Report-Email.html”, that I would like to insert into the body of an Outlook email message. The html file, “Trip Report-Email.html” is generated by exporting an Access report to an html file. When the email gets sent, I want the email recipient to see in the body of...
  19. C

    Move sub-reports

    H DBG, Sorry. I didn't see it until this morning. I was successful by noting for the text box the TOP dimension and adding to it the HEIGHT. I used that number in the TOP dimension for the sub report and it worked. Thank you as always. Chuck
  20. C

    Move sub-reports

    Hi, sorry for the delayed reply. Lots of things going on. The text box's data is: =([rTitle]+Chr(13)+Chr(10)) & ([LAddress]+Chr(13)+Chr(10)) & ([LAddress2]+Chr(13)+Chr(10)) & ([LCity] & ", " & [LState] & " " & [LZIP]+Chr(13)+Chr(10)) & (IIf([LTel] Is Not Null,"Tel: " & Format([LTel],"(000)...
Back
Top Bottom