Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. leslied

    Printing

    The following is the code in my command button for printing the report: My question is , how do I specify a default printer? thank you.... code is as follows: Private Sub cmd_print_Click() On Error GoTo Err_cmd_print_Click Dim db As Database Dim qdf_check As QueryDef Dim qdf_rcu...
  2. leslied

    Report Question

    I am not getting any errors. Here is the scenario: I open this form. It has several reports that are able to run from the form, now, upon selecting a report, it will start the process but it will not give me any output. After it finishes running the query it rushes through the output screen...
  3. leslied

    Setting forms one size

    I tried searching for this but the search is not very friendly. All i want to di is set the form so that when it is open it does not open to the size of the screen. I want it to open one small size.... can anyone help? thank you
  4. leslied

    Report Question

    I would appreciate some feedback on this question, Why is it that a report works on one machine very well, no errors or whatever, but on another machine sometime does not work or may work some of the times. I would really appreciate your feedbacks. I am stumped on this. Thank You
  5. leslied

    Generating an output to a file instead of a report

    this is what i did.... is this correct or does it look okay to you? DoCmd.TransferText acExportDelim, , &quot;<RBC Monthlysal Query>&quot;, &quot;<D:\TEMP\RBC MonthlySal>&quot;, True because i am getting this error that D:\TEMP is not a valid path thanks
  6. leslied

    Generating an output to a file instead of a report

    ok... I have a query which pulls information i need. now what i want to do with the query is to send the information it pulls to a file, namely a plain text file. The type of file is not very important at this moment. Now I want to do a form. On that form i will have a button that runs the...
  7. leslied

    Generating an output to a file instead of a report

    I accept your answer..thank you for that. What I was actually looking for, and this is my fault, so I apologize for it. Any how, what i really wanted to know is how to make it automatic. For example, when the user hits the generate report button, instead of it actually generating a report it...
  8. leslied

    Generating an output to a file instead of a report

    How do you output information from a query to a file, for example for disk transfer, rathern than outputting it to a report? I apprecaite your feed backs. Reagrds.
  9. leslied

    Report

    Hey guys I have a question I want to format a report such that the report header prints out every time a new section is printed. Example, this is how the report looks currently: REPORT HEADER Constituency name People numbers addresses somewhere My name 0000 someplace somewhere...
  10. leslied

    EXPORTING TO EXCEL

    I have solved the problem thanks.......
  11. leslied

    EXPORTING TO EXCEL

    you are certainly correct there.... yes the mising columns fall in that catefory...
  12. leslied

    EXPORTING TO EXCEL

    yes... everything that needs to be selected is... since I am using this same query to run other reports and upon exporting that other report, everything shows up on the excel file...Thus my incomprehension as to why this one doesn't do the same.... thanks
  13. leslied

    EXPORTING TO EXCEL

    I believe i am exporting the query since i am viewing the report first then i export it.....
  14. leslied

    EXPORTING TO EXCEL

    Hi, I am doing it via file/export....
  15. leslied

    EXPORTING TO EXCEL

    Upon exporting to Excel, certain fields do not show up in the Excel report. What would be possible causes for that? Can anyone help with this question? Thanks
  16. leslied

    Supprressing zeros in a row

    I am using a query.... but i don't know how to do it... This is the SQL for the query: SELECT [account] & &quot; &quot; & [project] & &quot; &quot; & [sof] & &quot; &quot; & [sector] & &quot; &quot; & [lastcode] AS udak_field, dbo_DCA_ldr_acct_bal_ext.ministry, qry_ministry.ministry_desc...
  17. leslied

    Supprressing zeros in a row

    Is there a way to suppress a row that has all zeros in it? For example: Item Amt Amt AMt Amt Total Item Name 0.00 0.00 0.00 0.00 0.00 Item Name 1.00 1.00 0.00 1.00 3.00 What i want to do is supress the row where the item name(doesn't matter what...
  18. leslied

    Table help...(link tables)

    I have a table where I want to do a query... however within one field in the table there are certain other ares that i want out of it... this is an example.... please bear with me.... The table looks like this: pay_element_id tot_current_monetary_amt ADVICE $0000000 A_TAXEARN...
  19. leslied

    Mdex.mda

    Guys can anyone tell me where I can find an updated version of mdex.mda? Thanks I appreciate the info.
  20. leslied

    Reports only on one page

    Never minds guys, I figured it out. Thanks alot CosmoKramer Have a good day

Part and Inventory Search

Back
Top