Search results for query: *

Can someone please help me with this neverending date problem in Access. Dates are stored as mm/dd/yyyy time:min:sec. I have a daterange search that retrieves records from 'fromDate' and to 'toDate'. 'fromDate' and 'toDate' are only day, month, and year. The search works fine if 'fromDate'...

Hi, I'm trying to perform a simple action after the user has selected a radiobutton, and will then redirect the user to page1.asp if button1 is checked or page2.asp if button2 is checked. How can I make this selection? <form name=&quot;form1&quot; id=&quot;form1&quot; method=&quot;post&quot...

I have an applet that scrolls different messges vertically, but in addition I would like these different messages to link to different pages. Is there a way to make each message as a link in an applet? I know there is events like a mouseEnter and mouseDown, Can someone maybe givebe a hint...

Thanks for that, but after some thinking, using XML here is possibly too complicated. All I want is to write out some content to Excel that I have retrieved in a HTML table. After some studying I found that by using this, Response.ContentType = &quot;application/vnd.ms-excel&quot;, on the top...

Is it possible to transform Access data to XML and then use XSL to read that data again using ASP? I have done this using ASP.NET, but this time I have to use ASP where I'm not that experienced. The thing is that I'm trying to read some DB data and write it out to an Excel file (or tab...

Thanks, but actually when I thought about it, I found a way through it. I set a special Session when the condition is met and use it in the value field, such as: <input name=&quot;textrow1&quot; type=&quot;text&quot; size=&quot;25&quot; value=&quot;<%= Session(&quot;EditValue&quot;) %>&quot...

I am trying to set a text into a textfield when some conditions are met. I have this textfield: <input name=&quot;textrow1&quot; type=&quot;text&quot; size=&quot;25&quot;/> I don't want to use the value attribute. When I have a value for it I instead use...

I am trying to delete a tablerow from two tables with a relation. That is, there is a foreign key id relation and I want to delete all records with a certain id. This wasn't as simple as I though it would be. Is it possible to do it all in one query in Access? I tried something like: DELETE *...

I have a database with data relations that I want to export to Excel. I know I can export tables directly from Access etc. till Excel, but this data is not very readable. I want to make some queries to retrieve certain results, maybe store the result in a tmp table, and then export the result...

I am giving a report on DB data. For each &quot;level&quot;, i.e. 1-5, I retrieve how many selected each of them, such as: SELECT LikertLevel, Count(*) AS CountSelected FROM Response WHERE QuestId=&quot; & Session(&quot;QuestId&quot;) & &quot; And AlternativeId=&quot; & altIdList(i) & &quot...

Is there a way to retrieve the id from the record that was just inserted to DB? That is, I insert some values into an access DB and the record automatically creates an ID. The ID that is created (autonumber) is needed when I add new records to other tables with this ID as foreign key. I...

I'm trying to empty all my session, just after all values have been submitted. I tried with Session.Abandon(), but that doesn't seem to change anything. I want to do this because if the user refreshes the page after submitting values, an error occur because I try to add the same values to DB...

I am giving a graphical report on what is stored in the DB. I am not that experienced though with databases, so i'm afraid I have too many DB access. In one table I want to count the number of rows for each of '1','2','3','4' and '5'. Such as: SELECT Count(*) FROM table WHERE level='3'...

I have a list of radiobuttons that varies depending on the number of items that is stored in the database. The user clicks the selected radio button and then clicks a 'get' button. I have a javascript that checks whether a radio is checked. It works fine if I have more than one radiobutton, but...

I'm very new to ASP and VB, but this doesn't make sense to me at all. I'm checking whether a value is greater than an other, i.e. If questNr > Session(&quot;LastAdded&quot;) Then ..do something Session(&quot;LastAdded&quot;) = questNr End If This works fine until questNr is '10' and...

..never mind, guys .... You were right. I actually included the file twice within the same form, so yes, I had the same textfield name twice! Sorry, and thank you...

Thanks for that guys, but that is unfortunately not the reason. My textfields have different names. One thing is that the textfields is inside a table in a asp file I'm including. But that shouldn't cause any difference, should it? I have done the same now with another file I'm including, all...

This may sound like a very silly question, but I'm struggeling with a comma that always appears after submitting values from two textfields!! I have looked all over the code if a comma appears somewhere, but can't find it. Is there a way a comma can appear after a textfied value? This is a...

Thanks for that, but how can I do such a thing?

How can I refresh my previous window. The thing is I want the previous window to be refreshed when user clicks a &quot;goback button&quot; (refresh the window he goes back to). I tried to put a window.location.reload() in <body onload=..> in that previous window, but that causes a reload loop...