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

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

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

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.

Hey folks, here is a teaser for you all. I have a report that is currently looking like this: INFORMATION INFORMATION INFORMATION INFORMATION INFORMATION INFORMATION INFORMATION INFORMATION INFORMATION INFORMATION INFORMATION...

Guys is there a way to change a file from MDE to MDB. Providing one can not find the original file? I would appreciate some help on this one...... thanks

This SQL code is currently performing what it was set out to do: SELECT [account] & " " & [project] & " " & [sof] & " " & [sector] & " " & [lastcode] AS udak_field, dbo_DCA_ldr_acct_bal_ext.ministry, qry_ministry.ministry_desc AS min_desc...

I had posted this issue earlier and thought I had it solved but it has not been working as well as I thought It was. This is the code for a button on a form. When the user presses this button it is suppose to append or add information into a table: Private Sub Add_Click() On Error GoTo...

CAn anyone tell me why do some reports take forever to process? WHat can be done to speed it up? I am very interested in that Thanks

OK Guys heres another little project... I have this form that I am using to populate a table. I have a button on the form which is basically used to add info into the table. The button has this code on it: Private Sub Add_Click() On Error GoTo Err_Add_Click DoCmd.GoToRecord , , acNewRec...

Ok Guys this is my predicament: I have a form that I am using to enter information into a table. One of the fields is called Constituencies. I want to make this field a combo box which has a list of the names of the constituencies. However, after making a query which contains only the names...

I would like to set a command button so that the user can click it to delete records that they may not want from a form. The from is used to enter information into a table but I would like them also to delete records. How can I accomplish this? Thank you... Regards

For lack of other programming softwares, I am forced to try and make a form that will call all the other reports that currently exist from different databases. It will work such as a switchboard does, but not exactly. What I want to do is make a form that will call reports from different areas...

Good day guys and gals, My question this morning is weather or not it is possible to copy everything off a report and put it on a new report, including the report headers and other sections.... if so, then How? if not then what? thank you for your time, I really appreciate it.

Hi guys, I have a report that apparently was working up until some time ago. The problem: Certain Labels are not being viewed. For example, in the Report Header, when the report is viewed whatever is in the report header is not viewable. The properties for it is set to view-yes, but I still...