Wow, this worked great - thanks a lot for your help.
Just one more question, along these same lines - how would I be able to query for records entered in the last 12 hours, even if this crosses over into the previous day? For example, at 6 in the morning, query for records since 6pm the previous evening? Thanks again...
Luongo
Last Activity: Oct 3 '08, 03:56 PM
Joined: Oct 30 '06
Location:
-
Specifying date and time range for report
Hi, I'm trying to have a report whose range is specified in a form by the user. I managed to do this successfully in the past with just dates, using Access's calendar function and the proper query. However, now I need to be able to specify an exact time as well as the date, for example April 2 6:00 PM to April 11:45 AM.
What complicates things, I believe, is that the date and time must be stored as seperate fields in the table,... -
Changing the name of field with radio buttons
Hi,
I'm setting up a survey form in which the user will select from a series of radio buttons (Session 1, Session 2, etc) and then rate different criteria of the selected session. I thought a good way to do this would be to set up up the entire form and then have the names of the rating fields change depending on which session was selected. This would be in order to differentiate between the different sessions. The problem, I thought,... -
Hi Ronald,
The purpose of the survey.php file is just to verify the fields and insert the values into mysql. This is what the form submits to, ie action="survey. php". This file does have its own content output with a thank you message, however I do not want it displayed at all as it contains a different layout than I'm using for the form. So basically I'd like to combine the processing of the one file with the display...Leave a comment:
-
Processing form but showing another page...
Hi, I have a form that, when submitted, needs to be processed by one file (survey.php) but have another page (thankyou.php) displayed. Because I don't have access to the former, I can't combine the two which would obviously be the best thing. What's the best way therefore to accomplish this? Would a meta-refresh do the trick or would that simply redirect to the thankyou page without processing? Thanks for your help.... -
Thanks dswethar.
The document clause is what I was missing in my combinations.
This (slightly) shorter combo also works for me:
parent.document .formname.textn ame.valueLeave a comment:
-
Setting input value in parent from iframe
Hi, I need to change the value of a text input (onmousemove) in the parent document from an iframe, based on what an iframe variable is.
I tried this code along with several others but can't seem to get it to work:
(in the iframe)
window.parent.p oints.mapvalues .value = tempX;
Any help would be appreicated. Thanks.... -
Yes, but what I need is the exact coordinates where the image is clicked, which is what the coords_x and coords_y values of the input provide. Do you know of a different way I could get these coordinates and store them as hidden values, rather than having to wait until the form is submitted?Leave a comment:
-
Furthermore, I believe you'll have to call the function when the page is loaded, ie body onLoad="CurDate ()"... sorry I can't actually play around with it right now but I think that would be needed....Leave a comment:
-
Glitch with results ordering
Hi, I'm working on a mysql-based survey program. On the user page I display the survey form, and on the admin page I display the results for each question. The problem, which I find puzzling, is that on the results page the order of the questions (sorted by specified question numbers) are slightly jumbled, while on the user form they work fine. I've looked at these mysql queries for a while but can't seem to pinpoint the problem. I'll paste them... -
I doubt this will solve the problem, but make sure the cases are matching. Your input name is "readout" but you're calling it as "Readout".Leave a comment:
-
Thanks again Ronald. I have managed to get a test form up and running using these methods. However, one problem I cannot solve is how to pass the coords_x and coords_y values of an image input type through ajax. Usually an image submit button would submit the form and also generate those coordinate values. However, with Ajax it just seems to submit the form. I will continue searching, but if you know of a way around this please let me know.Leave a comment:
-
Thanks ronverdonk.
Along these same lines, though more specific, is it possible to submit a form and have just that layer refreshed? I saw in your discussions the use of a select box that would display info onChange. However, in one case, I'd like to be able to actually pass values (hidden values and the coords_x/coords_y values on an image input type) without refreshing the entire page as mentioned. Can this be done using the methods...Leave a comment:
-
Using AJAX to refresh part of page
Hi, I'm looking for a way to refresh just one part of a page (a div layer) rather than the entire thing. It has been suggested to me that i use AJAX to do this - however I have no knowledge whatsoever of this. Could someone confirm that this could be done and point me in the right direction?
Thanks.... -
Locking position of iframe page
Hi, I'm working on a project which includes an iframe that can be scrolled both vertically and horizontally. The basic purpose is for the user to be able to create an image map - on each click, the image in the iframe refreshes itself with red dots on the click coordinates and lines connecting the dots.
This is working fine - however, my problem is that each time the iframe refreshes it goes back to the default starting position,... -
Putting mouse coordinates in URL
Hi,
I'm working on a project in which I'd like to have the user's mouse click coordinates included in a php URL which would load onClick, for example http://...imagecreate. php?x=200&y=100 . I've seen several scripts dealing with mouse coordinates, but can't seem to make things work with this. Can anyone help? Thanks... -
Thanks, was trying to complicate it I guess. Didn't realize it was that simple...Leave a comment:
-
Query database for today and yesterday...
I'm trying to construct a report based on a database query that retrieves the records from the current day as well as the day before. Can anyone explain the proper syntax for doing this? I tried using the DateDiff function but couldn't seem to get it working at all. Any help would be appreciated... thanks... -
Yes, thanks to both of you for all your help. I've noticed that the current code just sets the default value for the one record, and not on any subsequent records. Since I'm in datasheet mode, I'd like each new row to have that default value. I tried inserting this code in the OnLoad event of the form (within the code provided above), but it did not seem to work:
Me.Supervisor.D efaultValue = strValue
Here's the whole...Leave a comment:
-
Thanks again, it's working now (sorry, I forgot to include the 'Then' in my earlier paste).
Just one more question about this if I can... How can I pass multiple variables using this OpenArgs function? As mentioned, I have 'Shift' and 'Supervisor' values that I'd like to pass to the form. However, the example seems to only deal with one. Is there a way to expand the OpenArgs to include both values?Leave a comment:
No activity results to display
Leave a comment: