Search results for query: *

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...

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...

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

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

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

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...

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...

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.

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...

I have solved the problem thanks.......

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

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

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

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

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

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...

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...

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...

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

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