Search results for query: *

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

Thanks Jeff!! Works great!

Any help would be great. Is there any way to disable the user from closing out of Access (not a form but the actual application). I'm trying to make sure that users enter the mandatory log without bypassing it by just closing Access itself. Any suggestions?

Any help would be appreciated. I'm trying to keep a log of activity in a database. I have a text box for users to document their activity and I'm trying to time and date stamp each entry, but I keep getting a syntax error. I'm pretty sure it's something I'm doing wrong with date and time...

Thanks for helping Databaseguy. I tried your code in my form and it worked using the message box. I tried displaying the same result in the text box and it gave me the two boxes again. Strange. Thanks again!

Using that, the first line in the textbox is skipped, but in the other places it just shows two boxes followed by the next description. Here's what I get: <This lline was skipped> The United States of America is located in North American and is currently lead by President George Bush...