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

    Grouping recordsets into columns

    Hello, I am using the following code to group menu items with categories and subcategories, this one being entrees. This code works great, but since there are 6 entree groups, there are too many columns spread across. What I need is to take the following code one step further and split the...
  2. meldrape

    Group and sum outside of query string

    Hello there, my company is converting to a new inventory system. I have the following query that eventually produces an export file. I hesitate to post it because it's huge but I have to. tblExport.Execute "SELECT qyNewExport.cQty, qyNewExport.CUNIT, qyNewExport.CCATGORDR, qyNewExport.CCATG...
  3. meldrape

    https and self.close isn't working

    Hi all, I'm using the following in a child page after it posts info to a database: 'refresh parent, close self With Response .Write "<script language=javascript>" .Write "window.opener.location.reload();" .Write "self.close();" .Write "</script>" End With This worked perfectly...
  4. meldrape

    Export file name problem

    Greetings, I have a simple query I need to export as "qte.mat" and I am getting a database or object read only error. When I change the name to "qte.txt" it exports perfectly. Anybody know how I can handle this? it HAS to have the "mat" extension. here's my code...
  5. meldrape

    Export to RTF with &quot;where&quot; condition (vba)

    Hi there, I need to export a report to RTF format but can't figure where to put the "where" condition. Here's my code: DoCmd.OutputTo acOutputReport, "rptMaterialsLoad", acFormatRTF, "c:\xfer\Report.rtf", True When I print the report I use this code: DoCmd.OpenReport ("rptMaterialsLoad")...
  6. meldrape

    Copy file from windows to linux?

    Hi there, I am not familiar with Linux yet [sad]. I have a Microsoft Access application exports a text file. Is there a way to write a batch file to copy it from the windows server to a Linux server? We are a lumber company migrating to a new inventory system that's on the Linux platform and...
  7. meldrape

    Split and count from survey results

    Greetings, I have survey results where 4 of the questions had multiple checkboxes: Basic, Advanced, Specialty. All of the checkboxes are named the same so some of the answers look like this: Basic, Advanced, Specialty <form>CPT Coding for Staff: <input type=checkbox name=cpt...
  8. meldrape

    Open Excel, run macro, use as recordset

    Greetings, I have an excel macro in a spreadsheet that imports a log file into another spreadsheet, then saves it. I would like to be able to open Excel from an Active Server Page, run the macro, and use the spreadsheet as a recordset. Is there any way I can do this? I've been searching like...
  9. meldrape

    Javascript won't run, maybe??

    Hi there, odd problem with a page. User can't pull up active server pages where a javascript is trying to run. She was able to do it Monday. If she goes anywhere else on the site, the other asps run fine. This is a login page. We've checked the internet settings, she does NOT have sp2, we...
  10. meldrape

    Saving query text to SQL table

    Greetings, I've created a report builder app, SQL 2000/ASP. One of the features is that the user can save the query they build. The text of the query is saved to a separate SQL table. The problem I'm having is saving this text. I've done everything I know to handle the apostrophes. Here's an...
  11. meldrape

    Combine two recordsets into temp table?

    Greetings, I have two recordsets: computerinfo equipment These tables are unrelated but I need to combine them for the sake of a report. SO I've created the report with looping through two separate recordsets which works fine, except I don't know how to put in a page break. The page break...
  12. meldrape

    File upload problem

    Greetings, I have a webpage where the user can upload images (this is an intranet). I do it without any problem at all, I can uploade to my heart's content, but my boss cannot. I've made him an owner, I've given him full permissions, I don't know what else to do in IIS 6 to make it work for...
  13. meldrape

    Accessing folder on another server

    Hello, this is a general question. We have some christmas party photos on our mainserver (named mainserver). I support several sites on our webserver (webserver). I wonder if there is a way to access some folders on mainserver from webserver? They are both on the same network. I've done it...
  14. meldrape

    Write error description to database?

    Greetings, I've taken a script to collect computer information and modified it for our IT dept needs, but I don't know how to capture errors. I only know how to do on error resume next when looping through ip addresses. What would be neat is if I could capture the error info and move on to the...
  15. meldrape

    Typical VB constant error

    Greetings, once again, forgive me if this has been answered but the search feature is not available. I have a standalone vbs script to acquire remote computer info. It uses an access database but I want to use a SQL2000 database so I changed the connection string to reflect this. Now I'm...
  16. meldrape

    Open web page with vbscript

    Greetings, I have a script that I run to collect system data. It's not running in an ASP page, but rather stand alone. When it finishes, I'd like it to open a web page. Is this possible? The last line of code is: wscript.echo "Finished Collection Information for the System." I'd appreciate...
  17. meldrape

    Need Access connection string converted to SQL

    Greetings, I feel foolish asking for this. I have this script and SQL database but the script is designed for an access database. I need the connection information converted to SQL but try as I might, I keep getting various errors. There is something I'm not doing right. Here's the original...
  18. meldrape

    Problem importing text file

    Greetings, I need to import a csv or text file either one and it keeps turning a text field into numeric when imported. There are only five fields. Here's an example of how I'm doing the import: txtFile="c:/test.csv" DoCmd.TransferText acImportDelim, , "tblEUImport", txtFile, True There are...
  19. meldrape

    Exch server 2003 isn't sending email through asp

    Hi there, not sure if I'm posting this to the right place, so please bear with me. Just started running exchange server 2003. I have a help desk applicaiton in asp, using the smtp server to email us when someone posts a helpdesk ticket. I do not get an error when sending email but the email...
  20. meldrape

    Importing 104,000 records

    Hi there, I've searched for this and did find some helpful posts, but wondering if anyone can help me with this. I have a delimited text file with 104,000 records. It will not fit into one spreadsheet, but when I try to "start import at row 65,000" I get the error "integer is not valid" and...

Part and Inventory Search

Back
Top