Search results for query: *

Hi there, I've searched but do not know how to do this. and I'm sure it's elementary but I'm not that familiar with wscript and the syntax. I have a simple html form: <form name=frmTest action=test.vbs> <select name=location> <option value=1>Front Desk <option value=2>Yard <option...

Hi there, I have a small access 2000 database with a handful of records. I want to display these records one at a time in an asp with next previous buttons at the bottom. I've searched paging tutorials, etc. but they seem overkill for what I'm doing. I just want to display a record and click...

Hello, I have a SQL2000 database with datetime fields in some of the tables. Users have asp forms they add data to the tables with. If the user leaves a date field blank, it defaults to 1/1/1900. Is there a way to not have it automatically enter that date and just leave it null? Thanks.

Hi there, didn't know quite how to search for this. I'm pulling in file names from fso and would like them to display 6 across, unlimited down. I know how to do that with a recordset but I'm not smart enough to how do I do it using objFile in a for next loop?

Greetings, I found this thread but cannot figure out how to use the vba code. thread707-97374 I have an employee spreadsheet and the boss wants to randomly choose two employees per month for drug testing. Column C has their names, and if they've left, column F has a date so somehow I need to...

Hi there, I have an estimate file that gets printed for customers. The file consists of a verbiage line like ROOF then the estimated items follow then another category like FIRST FLOOR and more estimated items, etc. I'd like to be able to get a subtotal between the verbiage lines but I have...

Greetings, I'm using this simple code to send customers an email after their helpdesk ticket is resolved. I wanted to copy myself on the emails, but when I enter myMail.BCC or myMail.CC, it fails to send. If I comment out these lines, the message sends successfully. I've made sure the bcc or...

Greetings! I have a strange request. I have a table with job numbers and a form where users list the jobs using the following query: SELECT PLAN.* FROM PLAN ORDER BY PLAN.JOBID DESC; The data type is text because the templates they use are text names SITR but the job numbers are numerical...

I've looked for a similar answer to my problem but can't seem to find anything that works. I have the following query: SELECT * FROM dbo.customers LEFT OUTER JOIN dbo.gifts ON dbo.customers.contactid = dbo.gifts.giftcustomerid WHERE (dbo.customers.expanded IS NOT NULL) AND...

Hi there, I am trying to delete a file like this: Set fso = CreateObject("Scripting.FileSystemObject") Set fileObject = fso.GetFile("\\server\file.txt") fileObject.Delete It works great EXCEPT when the file isn't there... How do I see if it exists first? I've tried: Set fso =...

Hello all, I wrote the following code for an Active Server Page but I really need to use it in Access. Could someone please help me convert it and maybe help me know how to use it in Access? Please forgive my ignorance. I don't get to use Access too much. Many thanks! 'Create a recordset...

Hi there, I have exported several delimited text files and would like to know if there is some way I could write a function to trim all of the fields I've imported. I know how to write a regular query to do this, but there are over 30 fields and I don't really want to update field1 with for...

Hello all. I didn't know how to search for this so please forgive me if it's redundant. I'm pulling information from an orders table into a form for review. If some of the fields are empty, I receive the ugly error '80020009' . This particular one errored on a field called rs("ship_to_name")...

Hi there, I'm not very good at javascript but I'm using the following to close a child window and refresh a parent window after updating a database. It's within an ASP page. <SCRIPT> function CloseWindow() { if (window.opener && !window.opener.closed) {...

Hello, I've been thinking out of the box in this one and probably need some help. There is a list of stuff with a delete icon next to each entry. User clicks delete, this removes the item, then I want the user to be able to return to the same area. I'm working on it but somebody out there...

Hi there, here's a good one. I have a development server and a production server. Dev is winnt and prod is win2003. I have a delete link and after it deletes the records it redirects like this: response.redirect "?select=81" which returns in the address line: default.asp?select=81 simple...

hello, I have a recordset that I need to update with line numbers by job ID. For instance: db.execute("update job set line_no=??? where jobid=1") How do I go about looping through this recordset and adding line_no + 1 to the next and so on? I've tried iCount=iCount+1 in a do loop and...

Hello, I have a large text file with part numbers and descriptions that is parsed out and dumped into a table called estimates. Then I need to go back and run a query to update all of those records with a price from a separate table called parts. There are usually 100 records in each...

Greetings, I can log into the server (even remotely), run the asp page and make the following test code work, but if I log onto a workstation and run the same asp page, I don't get an error, but the file copy doesn't work. I have anonymous turned off because I record LOGON_USER as the clerk...

Hello, I have a dropdown or a textbox I want to display depending on what was selected from the first dropdown. i.e. the first box has two choices, N and V. What I see is the user choosing "V" for example (without clicking a button after making the choice either if possible) then a text box...