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 TouchToneTommy 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: VogonPoet
  • Content: Threads
  • Order by date
  1. VogonPoet

    SQL Server 2000 32 Bit on 64 Bit System

    We are trying to run SQL Server 2000 Enterprise Edition 32 bit on Windows Server 2003 64 bit running on Opteron 64 bit processors. SQL is only using a little under 4GB of RAM (we have 32) and I cannot find out how to use the balance of the RAM. I've already tried using sp_configure and 'awe...
  2. VogonPoet

    Unable to automate import of Access DBs

    I have setup a stored procedure to allow me to run any DTS package from Query Analyzer. When I run the stored procedure for a DTS package that moves data from one SQL DB to another it works. However, when I run the stored procedure for packages which transer data from MS Access to SQL, it does...
  3. VogonPoet

    Updating a table using a cursor

    Here's the readers digest version of what I want to do. I need to assign numbers to members (SampleNo) based on a set of criteria (this is not listed in the code below to keep things simple). Anyway, I'm selecting a some of the records in tblMemberlist. I then want to be able to set to...
  4. VogonPoet

    Report graphs not always updating

    I have several reports with embedded graphs. I was having a very significant problem with the graphs updating. I thought I had solved the problem by putting an graph.requery statement in the OnFormat event. This seems to have worked for the most part, but I am still having occasional cases...
  5. VogonPoet

    Suppress warning dialog box with Excel delete method

    I have an Access(2000) program that is doing some manipulation to Excel(2000) workbooks. When I execute the following command, I get a dialog box asking me to confirm the deleteion: objWkbk.Worksheets(intCnt).Delete How can I temporarily disable the dialog box asking me to confirm the...
  6. VogonPoet

    Delete method gives confirmation dialog box

    I have an Access(2000) program that is doing some manipulation to Excel(2000) workbooks. When I execute the following command, I get a dialog box asking me to confirm the deleteion: objWkbk.Worksheets(intCnt).Delete How can I temporarily disable the dialog box asking me to confirm the delete?
  7. VogonPoet

    Multiple SQL logins during single report

    I am using Access 2000 as a front end reporting tool against a SQL Server 7.0 database. When running one particular report, the SQL Server Login form appears (and must be dealt with) 50 or more times. The database is automated to output many reports, both to PDF files and paper, automatically...
  8. VogonPoet

    Shrink Log File

    I have a database where the log file is allocated 3GB, but I'm only using 30MB. How can I shrink the log file to 500MB or so? Thanks in advance.
  9. VogonPoet

    PDF Files

    I'm printing a large number of Access reports to PDF files. I want to combine the separate files into one PDF file and create bookmarks. Any ideas. Also, has anyone seen a third party utility that makes accessing Acrobat easy for the Access/VB programmer.
  10. VogonPoet

    Working with PDF Files

    I'm printing a large number of Access reports to PDF files. I want to combine the separate files into one PDF file and create bookmarks. Any ideas. Also, has anyone seen a third party utility that makes accessing Acrobat easy for the Access/VB programmer.

Part and Inventory Search

Back
Top