Search results for query: *

Hi, I am running into a memory issue. Never had the problem on ACCESS 2000, under VISTA. Now running on ACCESS 2007 and windows 10. Code is fairly simple. Sending out emails to a bunch of customers (roughly 600) with an attached report. It basically is a do while loop using the record and...

Hi, I have used DoCmd.OutputTo acOutputStoredProcedure, stSQL, acFormatXLS, FileName & “.XLS”, FALSE for older versions of ACCESS and older operating systems. It will no longer output the file on the newer versions. Running Access 2007 and Windows 10. It doesn't give me an error, however, no...

Good afternoon. Beating my head against the wall. Here is the scenerio. I have a form which gets used for ordering product. When the user puts in quantity which is not divisable by the required order amount (different for each item), I pop up another form. On the form you have 3 choices...

Is there a way to print a sub report multi column, down and then across but not filling out the entire page? I have about 4 inches on the report. If I go across and then then down, no problem as it creates the 4 columns a populates fine. However, I am printing and index by alpha description...

Hello, Is there a way of changing the copy count on a PDF document before I try and print it? I got code to print the document. Now I need to be able to change the # of copies before I print. THanks, Remember when... everything worked and there was a reason for it?

Hi, Does anyone know how to send a pdf from a folder to a ricoh color copier (MP C4000) with a Fiery E5100 controller? I want to use the VDP and save the PDF as a master, overlaying the prior master. I think I can manage the code for getting the name of the document from a folder with some VB...

Hi, I am having a problem printing. I have a ricoh 2075 printer. We are purchasing a new ricoh 907ex printer. Downloaded the drivers. Now when I am printing on the 2075 ACCESS is hanging and terminating. Running ACCESS 2007 and Vista. Tried deleting drivers, installing, back,forth,up, down...

Hi, I have to missing something here. Using the wizard. 1) Select excel as the input file. .....No problem. 2) Destination file - Microsoft OLE DB Provider For Sqlserver .... No problem. 3) Select the server name and database. .... No problem. 4) Check off radio button for Copy data from...

What I am trying to do is create multiple rows from 1 record.. easily. This is for a report. I can write repitive cursors but I just wondering if there is an easier way. For ex. Say my select returns a set of records each with a field to tell me how many times I need to repeat that record...

I have an ACCESS program printing excel documents and word documents using the PrintExcel and PrintWord commands. Work great. When there are mult. pages in word, the printer prints them each on 1 page. When there are mult. pages in excel, it is trying to print them on all 1 page and shrinks...

Is there any way of ascertaining the # of pages which were just printed a report from VB? In other words DoCmd.OpenReport "ReportName", acNormal On the next line I need to know how many pages just printed. Why you ask? I am doing a mailing and I need to figure out the weight of each...

Hi, I have a main report with 4 subreports. On 1 of the subreports I need it to break on one of the groupings when a field on the group header is set to a certain value. I know you can't use sep. pages in subreports. So in the ON FORMAT of the grouping, I set the grouping force new page = 2...

How do I get the font to be bigger than 127. I need to print larger numbers and letters on a report. Do I have to do a something with WORD to allow for a bigger font or is there some other method of madness I can use. Thanks. Remember when... everything worked and there was a reason for it?

When using the format: DoCmd.OutputTo acOutputStoredProcedure, "spname", acFormatTXT, pathandfilename, False ...... how do you stop the heading from appearing? I just want he raw data. Also, when I use txt, it is chopping my output and putting dashes on top, below and on the sides. See below...

When using the format: DoCmd.OutputTo acOutputStoredProcedure, "spname", acFormatTXT, pathandfilename, False ...... how do you stop the heading from appearing? I just want he raw data. Also, when I use txt, it is chopping my output and putting dashes on top, below and on the sides. See below...

When using the format: DoCmd.OutputTo acOutputStoredProcedure, "spname", acFormatTXT, pathandfilename, False ...... how do you stop the heading from appearing? I just want he raw data. Also, when I use txt, it is chopping my output and putting dashes on top, below and on the sides. See below...

When using the format: DoCmd.OutputTo acOutputStoredProcedure, "spname", acFormatTXT, pathandfilename, False ...... how do you stop the heading from appearing? I just want he raw data. Also, when I use txt, it is chopping my output and putting dashes on top, below and on the sides. See below...

Tried posting in other forums, maybe this is the correct one to post in. I can't believe this will not work. Using an ADP. backend stored procedures. have done this million times using a table. Can you substitute a stored procedure returning the data you want in place of the table? 100...

Tried posting in other forums, maybe this is the correct one to post in. I can't believe this will not work. Using an ADP. backend stored procedures. have done this million times using a table. Can you substitute a stored procedure returning the data you want in place of the table? 100...

Using an ADP. backend stored procedures. have done this million times using a table. Can you substiture a stored procedure returning the data you want in place of the table? 100 people on the net say yes, 100 say no. The syntax says you can use a query. Does a query mean a sp as well? 1...