Recent content by tvman5683

  1. T

    Solved Query no longer recognizes calculated field selected from a text box on a form

    Yes it always is. Here what just happened. I brought in an older version of the form from a recent backup. Renamed the original so the query would look at the imported form and it still did not work. I set up a test table and query using the same form source and it worked. I added it to the...
  2. T

    Solved Query no longer recognizes calculated field selected from a text box on a form

    I have a few queries that no longer seem to recognize the info selected from a text box on a form . Here is the way I had it set up. It's an append query to add the info to a table to be used later in a report. They worked well for over a year and suddenly this week when I run the query these...
  3. T

    Solved Report prints from RunReport command in Macro/turned into module

    Thank You. I did not know that. As I mentioned I created this originally as a Macro that just created the tables for the report but it got converted to code. I wanted to add the "Open Report" line so I just copied the line above it and changed openquery to open report.
  4. T

    Solved Report prints from RunReport command in Macro/turned into module

    I added a RunReport cmd to a macro I used to create the report from a button on a form. Recently when I had a problem with "duplicate previoud record" all my macros were converted to modules so code could be added to fix. I not too well verse in VBA and not sure why the report gets created but...
  5. T

    Solved Update Query question

    Ok went with create a table to hold the Sum and the Rate, then append them along with the calculation back into the Invoice Data Table. I tried it before but was trying to do it in one query. I guess it could not Sum then use that for a second calculation in the same Query. Thanks All...
  6. T

    Solved Update Query question

    Thanks for all the replies. Sorry it's an Access table that I use to create an Invoice. Once I have all the line Items I need to calculate the FSC charge and add that to the Sum Here is the final result I'm trying for. The Sum of the Customer rate is $6050. The 23% surcharge is $1391.50 so...
  7. T

    Solved Update Query question

    Can an update query be designed to perform a calculation on a table column(currency) then append that result to the same table in a new row that the becomes part of the total for that column. I want to sum the Customer Rate column then multiply by the 23% (FSC row) then append(or update) the...
  8. T

    Solved Sub Report data dissapears when trying to publish pdf or print

    I got it! Swapped out the "total" weekly subreport with 7 day version. That's exactly what I needed. Thanks again. Your improvements to the database are awesome and I have learned alot. John
  9. T

    Solved Sub Report data dissapears when trying to publish pdf or print

    Oh I see now you have a different way of selecting the date parameter. It works great for the first two reports but not the third(the YTD report). I'll study it more and see if I can adjust.
  10. T

    Solved Sub Report data dissapears when trying to publish pdf or print

    So I restored the date parameter back and it's the same problem. I think I'll need to make a table of the current week data as part of the button process then use that result as the subreport using your changes. I'll let you know how it works out. Thanks John
  11. T

    Solved Sub Report data dissapears when trying to publish pdf or print

    Looks fantastic! can't tell you how many times I tried to place it correctly. I'll study your changes so I can replicate. I did notice the date parameter in the subreport query no longer opens. I need it so the subreport reflects only one weeks data as the YTD is a summary of all the data in...
  12. T

    Solved Sub Report data dissapears when trying to publish pdf or print

    I found your sample data base named Sub Report headers and imported all my sample database items. I replaced my reports into your Main report to see if placement in the form section was the problem. It didn't work so I'm thinking it's something to do with the parameters in one of the queries?
  13. T

    Solved Sub Report data dissapears when trying to publish pdf or print

    Here is the database. From the main form select the driver John then click the YTD totals by Driver button to generate the report. then when trying to export the PDF you'll see the parameter window pop up. John
  14. T

    Solved Sub Report data dissapears when trying to publish pdf or print

    Thanks for the reply. When I open the report in the Print Preview the sub report is missing. One of the parameters does come from a combo box on the data entry form I use to add info to the main table of the database Drivers Daily Payroll Info Drivers Daily Payroll Info Drivers Name Work...
  15. T

    Solved Sub Report data dissapears when trying to publish pdf or print

    I created a Report with a sub report using queries with parameters (one is a combo box for a name the other is a date range). The reports appear together when run and look great. When I try to export as a pdf or print locally the parameter boxes reappear and request input. Re-entering the...
Top Bottom