Search results for query: *

running under ACCESS 10 and it seems to be handling the memory issue. Remember when... everything worked and there was a reason for it?

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

hey there, I read the posts but that was not the issue. I got it working. The stored procedure I was calling is running on another server. So basically I call one stored procedure on the server attached to the ADP and it runs the procedure on the other server and passes the data back to the...

1) I guess you could do a DCOUNT on the sub forms, record set. Check to see if > 0 or 2)Create a record set for that forms records. You can see if it is a EOF on the subform for the record set and do what you need to do at that point in time. Remember when... everything worked and there was...

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

Hey everyone, I sort of got lost in what you were trying to tell me. What I did was open the form in design view, set the popup and modal attributes to YES. I then opened the form as normal and it works perfectly. Is it that easy? Remember when... everything worked and there was a reason...

Hey there. Going home. I will decipher what you are saying on Monday. A tad confused. You are saying to open my current form with the 3 buttons in formedit mode with acdialog. Never did that before. What is the difference between that and a normal open of a form? Those 3 buttons I have at...

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

no problem. You gave me a great start. Thaxnks! Remember when... everything worked and there was a reason for it?

Duane, I thought I posted but apparently did not . My problem was the double quotes. I had them after the description field. This the code I had. see below: -------------- SELECT tblbidx_Description, tblbidx_PageNumber, DCount("*","tblBook4ColumnIndex","tblbidx_Description" <""" &...

mdb. I thought I answered ever question on the 1st reply back. Not sure what else you want me answer. I will paste again here. ------------------------------------------------------- Ok. This is an Access MDB. Running SQL server backend. The table is a local table from the MDB. table name is...

Not sure if 1st one got attached. Did it again. And when I say I ran it from SQL. I took the code from the record source and ran it on enterprize manager. It is where you develope all the SQL for ADP's. You obviously can't use DCOUNT in native sql. As far as the VB comment goes, I have...

Ok. This is an Access MDB. Running SQL server backend. The table is a local table from the MDB. table name is tblbook4columnIndex. Field name is tblbidx_Description. It is an a text field. There is another field in there I need to print for the page number(tblbidx_PageNumber) but it is...

Also, I was trying to run this straight from SQL and it states DCount is not a function. So how can I populate and SQL record source with a VB function? Remember when... everything worked and there was a reason for it?

Hey Duane, I tried retrofitting with my fields names and I got syntax problems all over the place. Trying to decifer what you are doing. Obviously if I have 4 columns I guess I set it to 4+1 instead of 3+1. I tried breaking it into pieces and still getting way too many syntax errors. What...

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

a little confused where the problem is. The problem occurs when I add data to tIncome after which when I run the report the new data appears under a group represented by the ItemID. That line confuses me. Can you cut paste and example of how it looks when it is wrong and how it is supposed to...

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