Recent content by Luongo1

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