Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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