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

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

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

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

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

I am simply trying to submit my form data to another page, but I don't want to leave the page. I am simply doing a document.forms[&quot;form1&quot;].action = &quot;anotherpage.asp&quot; document.forms[&quot;form1&quot;].submit(); This takes me to anotherpage.asp. I want to do some processing...

I'm trying to submit 2 forms to the same page with only one submit button. The reason I have 2 forms is that my asp page wouldn't recognise the start and end tag of the single form (maybe because I have a asp include in between). So I tried with this: function SubmitInfo() {...

Im very new to VB and I'm simply trying to declare a dynamic array. That is, I'm retrieving data from DB with set rs = cnn.execute(query). I want to go through every recordset and add the content to an array. Is there a way to get the size of rs? If not I tried to declare a dynamic array as...

I'm trying to include DB content into a message that is scrolling in a textbox on the page. The scrolling is ok, but now the text is static. In my asp page I want to first load DB content into an array etc.. when the page loads. I then want to somehow call the javascript that does the actual...

I have found a way to scroll a message in a textbox on a page. That is, the message starts at the bottom and slowly fades out on the top of the textbox. But this message is static. Does anyone know how I can first retrieve some DB info, store it in a table etc and then use it for the scroll...