Search results for query: *

Hi all, i found this script from the adobe website and is it possible for some1 to convert this to vb....am not having much luck? <script runat="server"> protected void dg_employees_SortCommand(Object sender, DataGridSortCommandEventArgs e) { // This function allows us to sort on the...

Hi all i have tested my webstie in asp.net and it works on my pc well. When i upload it to the server and test it...it allows me to login and takes me to the insert record page. Which it should do. But when i want to view records (view_records.aspx). Which has datagrid all the patients. I get...

Hi guys, I have question and not sure how to approach this. Well i'll start with the question. (Q) i have session id's...if user doesn't finish the form after 30 mins then i want it to log them off. But still have the session id enabled and when they login...the information they left is still...

Hi all i have access database connected to myp aspx webpage. I used dreamweaver. When i store the time through an aspx form. It saves it in access database table field. I set the field to show short time field. How ever when i retrieve the record through my aspx form it shows the date and time...

Hi all, Am trying to use this code in the control source of a textbox and i get an error msg. Am not sure where i gone wrong :s =DCount("[ID]","sheet4","dateadded BETWEEN #" & 1/11/2007 & "# AND #" & 30/11/2007 & "#") many thanks

Hi all, I have query which counts the number of records on monday, tuesday, wednesday etc depending on whether it is true or false. e.g Monday 18 yes Monday 3 no Tuesday 9 yes Tuesday 8 no etc... the code for...

Hi all, I have query which shows number of records for each day. How do i go about changing this so that it can give me the percentage of each. This what i got so far... SELECT Sum(IIf(Format([DateAdded],"dddd")="Monday",1,0)) AS Monday, Sum(IIf(Format([DateAdded],"dddd")="Tuesday",1,0)) AS...

Hi all, i want to count the records and group them. But this doesnt work if there's empty records in location. SELECT Sheet4.Location, Count(Sheet4.Location) AS CountOfLocation FROM Sheet4 GROUP BY Sheet4.Location; e.g Location count test1 5 test2 7 empty...

Hi all i have query which am trying to show from table "sheet" the field am using is hr what i would like to do is count then number of records who have results below: <50 between 51 and 100 >100 this is what i got but am not sure its right? SELECT Count(Sheet4.HR) AS [HR<51]...

Hi all, Am knew to all the aspx stuff. Currently am creating an intranet and am tryin to search for hospno and then fill the firstname and surname into webpage form fields. Am not entirely sure how to go bout this.... i've started off..... Sub GetHospitalNoButtonClick(Source as Object, E as...

Hi everyone am trying to create a search query but using 2 parameters....surname or hospital no.... How do i tell it to ignore one of the fields if its empty? What i mean is if enter the surname ....then i only want to filter it by surname and not hospital no...if nothing is written in...

Hi all am currently saving data using an aspx webpage. I can store textbox values but having trouble getting the syntax right for a checkbox value.... could any1 have look at this code and see where am going wrong? cmd.Parameters.Add(New OleDbParameter("@Location", txt_Location.text))...

Hi just wondered if any of u cud have a look at this sql and tell me whats wrong with it? It doesnt seem to be working... sql2 = "UPDATE Users SET Users.[Password] = '" & newpassword & "', Users.[Password expiry] = #" & DateAdd("d",90,Now()) & "# WHERE (((Users.[Login ID])='" & login & "'))"...

Hi i have this code which checks for carriage returns ms access 2003 query.... EXAM_Neuro1: Replace([EXAM_Neuro],Chr(10),Chr(13) & Chr(10),1,-1,1) I get an error msg on the field if its null...how do i take that in to consideration? Many thanks

Hi everyone.... Is there way by code to email a report. I create temporary table which the reports uses in access database. Could some1 give me an example or something to get me started...i dont want to save the report...i just want my vb.net (2003) application by a command button... to got to...

Hi all i have got data from oracle and placed it in access table.... in some of the fields it has square brackets. How do i get rid of the square brackets and replace them with carriage return. Is there some sort of function i could do to loop through each field and replace the squares boxes...

Hi all, I have this data in excel and i want to add the the calories. But the catch is.... each calorie has ID and they can be several ids that are the same e.g ID calories 23 15 23 17 23 23 12 1 12 2 12 3 etc i know u can use a conditional...

Hi am having slight problem, I can open the current document and print it. How do i print all records or send them straight to the printer without opening ms word? Is there code or example that can get me started? Am using access 2003.

Hi, Am doin append query and each line i would like to add Primary diagnosis as well as to the field am appending? But i dont think its right....this is what i got so far? INSERT INTO Temp_Diagnosis ( PatientID, ["PRIMARY DIAGNOSIS: " & Diagnosis] ) SELECT T_PrimaryDiag.PatientID...

GP_Address: [GP Add1] & ", " & [GP Add2] & ", " & [GP Add3] & ", " & [GP Add4] & ", " & [GP Postode] i've put that in access query and wanted to know if there is nothing in either field names then do not include the comma. Is this possible and could someone show me an example many thanks