Search results

  1. sbenj69

    Loading form starting at bottom

    well, if you were going to do something like that, then you could do something like this: Say your screen shows 20 records at a time...... Dim X as Integer Docmd.gotorecord, , acLast 'Go Halfway Up the Screen (20 records displayed, go up 10) For X = 1 to 10 Docmd.gotorecord, , acPrevious...
  2. sbenj69

    This is the craziest thing I have ever seen!!!

    Well, a few things first..... this pc went to separate homes.... with the same results..... I would highly doubt that this is wiring, but it could be.... it would be an incredible coincidence. The next thing you have to ask yourself is, why would it hang on the BIOS post? Well, obviously...
  3. sbenj69

    Loading form starting at bottom

    what happens if you use this in the on load event? docmd.gotorecord , , acLastOr are you trying to get some sort of locator, like if you were on record 201 of 456, open back up to 201? If that's the case, then it will be a little more complex :)
  4. sbenj69

    Trouble with Date Fields (sum)

    well, if you're spanning across midnight, then you should be including the date with the time. Either in separate fields or by making it general date type format of your date/time field. However, you will need to parse out the time and the date separately for general date type fields, if you...
  5. sbenj69

    Trouble with Date Fields (sum)

    Just convert the hours to decimal representation: In the first query you would have your starttime and endtime, then an expression such as: LineTotalHrs: Format(DateDiff("n",[Starttime],[Endtime])/60, "Standard") Note: Generally I would round instead of format, but let's continue..... in...
  6. sbenj69

    Delete <space> if at beginning or end of value?

    yeah, but I bet he's not from the "Redneck" part of Illinois :p
  7. sbenj69

    I don't know the technical term for this

    Here is an informative video that shows how to do what you are asking: http://datapigtechnologies.com/flashfiles/combobox2.html
  8. sbenj69

    Live time in a form

    Basically, make an unbound textbox with the control source being =time(). Name it MyClock Then in your database, for database events, set timer interval to 1000, then, on timer build the following event: Private Sub Form_Timer() Me.Myclock.Requery End Sub As neileg stated, this is very...
Back
Top Bottom