Recent content by GShen

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