Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GShen
  • Order by date
  1. GShen

    memory leakage

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

    memory leakage

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

    create Excel file using stored procedure

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

    check if there is record in subform to enable edit

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

    create Excel file using stored procedure

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

    Lost Focus or Deactivate On Form

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

    Lost Focus or Deactivate On Form

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

    Lost Focus or Deactivate On Form

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

    sub report multi column print

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

    sub report multi column print

    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" <""" &...
  11. GShen

    sub report multi column print

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

    sub report multi column print

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

    sub report multi column print

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

    sub report multi column print

    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?
  15. GShen

    sub report multi column print

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

    sub report multi column print

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

    pdf change copy count

    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?
  18. GShen

    PDF image to Ricoh Fiery VDP.

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

    Combo Box Data not displaying correctly

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

    printer drivers

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

Part and Inventory Search

Back
Top