Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Luongo1

  1. Luongo1

    Selecting by date and time

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

    Selecting by date and time

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

    Selecting by date and time

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

    Selecting by date and time

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

    Selecting by date and time

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

    Selecting by date and time

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

    Report cutting off field

    Thanks a lot! Worked great!
  8. Luongo1

    Report cutting off field

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

    Report cutting off field

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

    Inserting between old records

    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?
  11. Luongo1

    Inserting between old records

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

    Best way to print exactly as displayed?

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

    Locking position of iframe

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

    Locking position of iframe

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

    Locking position of iframe

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

Part and Inventory Search

Back
Top