Recent content by pparadis

You will just need to use the Order By syntax at the end of your query...i.e. "Select * From TABLE Where Row# > 0 Order By Row#, Sequence;"

Does anyone know how to disable the hourglass that appears next to the pointer in Explorer when a request is sent to the server. I have a hidden frame refreshing a list box and don't want the hourglass to keep coming up. Thanks.

Does anyone know how to disable the hourglass that appears next to the pointer in Explorer when a request is sent to the server. I have a hidden frame refreshing a list box in another frame and don't want the hourglass to keep coming up. Thanks.

Works great! Thanks.

I need to pull the filename out of a file path. Example: string = "C:\MyDocuments\Work\WorkFile.doc" I just need to pull out WorkFile.doc Any ideas? Thanks.

I'm working on an MS Access form. I want the user to be able to browse their machine for a file, select it, and then the vbcode will move it to a folder on a shared drive and save the location of the file in the db. I'm looking for a control that allows the user to find a file on their machine...

I have an ASP page that generates a report that the user is to print using their browser. If the document runs over one page, I need it to print a heading on each additional page. Is there anyway to know when a new page is started and what would I need to do to print the heading on the...

The input tag is created dynamically depending on the number of years and types of funding for a project so it uses variables to generate some of the text box names. They would look something like this: <input type=&quot;text&quot; size=&quot;5&quot...

I have a form that edits budget information. When I create the form I pull the existing budget numbers and put the values in text boxes by using the value attribute. The user is suppossed to be able to type over the existing number and update the database to a new number. The problem I'm...

I'm using INPUT to read in a text file to Access and write data to tables. Currently I am reading one piece of data per text line(one record can take up multiple lines). Is there any way to read one record per text line and seperate attributes by say a semi-colon or some other symbol? Thanks.

Thanks to both of you. Helped me open my eyes.

I have an sql query used to search for projects that match a users input string. The query works when I take it out of the code and try it in Access, but it wont work when trying to run it from my page. Anybody know why it would do this? Thanks. Here is the SQL: strSQL = &quot;Select * From...

I have a form that acts both as a search form and an inserting form. It has two submit buttons on it, one for searching and one for inserting new records. I need to validate the form before it is sent to the server. I'm using Javascript but can't find a way to determine which button has been...

Thanks Jeff. It worked great!

Is there a way to take data from one form, say ProjectID, and save it so it can be used in another form (i.e. to use in a querey to get information about that project). Currently I am writing data to a table I made to hold that information and then retrieving it from that table when I open the...