Search results for query: *

Hi Duane, The stored times are values such as 615, 1145, 1805, etc. Therefore I've tried using values formatted like this in Forms![Generate Report]!BeginDate and EndDate but this does not work in producing any results. I also tried entering different formats in the form such as 6:15:00 AM but...

Yes, Entered and Time are both date/time fields. As for the Time field, it is in the format of hnn, so it displays 1805 in the table, but then when clicked on shows 6:05:00 PM. I have adjusting the field values to both of these but nothing seems to be working.

Hi Duane, Here's what I'm trying, based on your suggestion: [Communication Log].Entered+[Communication Log].Time Between Forms![Generate Report]!StartTime And Forms![Generate Report]!EndTime StartTime and EndTime are then something like 02-Apr-07 1805, which is the same format in which these...

I'm using a form where the user specifies the start points and end points of the records he or she wants on the report. Each record has a date field as well as a time field in the Communication Log table. However, up until this point, the user has only been able to specify the dates from the...

Hi Duane, thanks once again for your reply. However I'm not sure in what sense you mean the fields should be added. Here's a piece of my database query, as posted in an earlier thread: WHERE [Communication Log].Entered Between Forms![Generate Report]!BeginDate And Forms![Generate...

I have two seperate fields in my access database - one for the date and one for the time. Would it be possible to use both of these together for the purposes of selecting and sorting records in an access report? For example, have the user specify start and end points for both date and time (ie...

Thanks a lot! Worked great!

Hi dhookom, thanks for your reply. Yes, it it cutting off after exactly 255 characters. Here is the SQL query I am using for the report (excuse the length). It is the Messages field that is being cut off, which is listed as a Memo data type in the type. SELECT [Communication Log].Log...

Hi, the reports that are created in my program based on a table/form are cutting off one of the fields when it exceeds a certain length - it looks like a number of characters as it's sometimes cut off mid-word. It continues to appear normally in the table records, however. Any idea on what...

Hi Joe, really the most important thing for me is to be able to insert records at any point. I'm willing to have the log numbers remain the same even if this causes them to be out of order. Would this make things significantly easier?

Hi, Is it possible to insert records between older ones while using an autonumber field? I'm using an auto-numbered log number for each record. However, I need to also be able to go back and insert records at certain points. Would it be possible to do this and have the auto-number field...

Hi, I created a form in HTML that I'd like visitors to be able to print out and fill in. The problem is, the tables do not print as displayed on the screen (ie the cellspacing, etc). What's the best way to have the page printed exactly as it is displayed on the screen? Thanks...

Alternatively, maybe instead of trying to pass that info in the URL, could I create two hidden form fields that would contain these variables, and then read them on the next page? If so how could I get the fields to update themselves based on this info? Thanks again...

Hi kaht. The problem is the image itself is very big - I'm basically using the iframe to navigate across the image, and would like it to load at certain coordinates depending on where the user wants. Unfortunately I guess this complicates things a bit...

Okay, sorry for the confusion. I managed to get dkdude's original ScrollBy function working in the framed page. There were a couple of <nobr> tags in the code that I removed and that seemed to get it working. My only problem now is how to pass the current scroll locations to the new page, so...

Wasn't sure whether to post this in the javascript or php forum but thought I'd try it here. I need to pass the current scroll positions of a page (window.offsetX and window.Offsety) in a URL that would also contain php variables. For example, something like this...

No this does not seem to do it. I increased the iframe page to make it bigger than the browser window, and inserted the code into the <body> tag of the iframe page, but didn't seem to have an effect. Sorry for the multiple posts here....

As a followup, would it be best to just force an increase in the height and width of the page in the iframe? Doesn't seem like the best option but it might get the job done...

Thanks for your reply dkdude. However, do you know how I could set this to work with the iframe? Right now, because the actual page in the iframe fits within a regular browser window, the scrollBy has no effect. However I would like the iframe itself to be scrolled - can't seem to get this...

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