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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. deBassMan

    Need to detect Access sub-form vertical scroll bar

    errm - not really as per my comments in the original thread thanks anyway
  2. deBassMan

    Need to detect when form has scrollbar

    Sorry - should have said - above code written for VB6. also Access forms do not seem to have hwnds like normal
  3. deBassMan

    Need to detect when form has scrollbar

    I have this from DevX: Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" _ (ByVal hwnd As Long, ByVal nIndex As Long) As Long Const GWL_STYLE = (-16) Const WS_VSCROLL = &H200000 Const WS_HSCROLL = &H100000 Function HasHorizontalScrollbar(ctrl As Control) As...
  4. deBassMan

    Need to detect Access sub-form vertical scroll bar

    Hi all using Ms Access 2000/2003, XP Pro I need a way to detect wether an Access sub-form is currently displaying a vertical scrollbar. really would appreciate any ideas - thanks!
  5. deBassMan

    Need to detect when form has scrollbar

    Hi MajP thanks for your reply interesting code - however sadly I cannot get it working either. But I think we're closing in on a solution -can anyone help??
  6. deBassMan

    Need to detect when form has scrollbar

    thanks for your reply ... the former cheers
  7. deBassMan

    Need to detect when form has scrollbar

    Hi all Using MS Access 2000, Win XP I require a way of detecting whether a vertical scrollbar is visible on a sub-form. thanks
  8. deBassMan

    Date question (should be easy!)

    thanks for that tb the code now looks a bit like this ... mTargetDate = DatePart("m", DateAdd("m", -1, Date)) strsql = "SELECT * FROM tblReferrals WHERE Datepart('m',RefDate) = " & mTargetDate Set rs = db.OpenRecordset(strsql) rs.MoveLast Debug.Print "Previous month total...
  9. deBassMan

    Date question (should be easy!)

    thanks for your quick response tb system date is used to determine current month the date stored is a full date I was hoping to SELECT on current month-1 (and subsequently -2,-3 etc) - perhaps using dateserial p.s watch out for those frisbees
  10. deBassMan

    Date question (should be easy!)

    Ideally I need to SELECT only those records that fall in the previous month .... Here's the relevant code so far ... 'return all recs from previous month mTargetDate = Format(DateAdd("m", -1, Date), "mmm yyyy") strsql = "SELECT * FROM tblReferrals" Set rs =...
  11. deBassMan

    Changing available selection in a combo based on other combo box

    May I suggest using a SQL statement for the second combo based on the selection from the first combo - works for me!
  12. deBassMan

    Date question (should be easy!)

    Thanks for that TB but how do I code the SQL statement to select all transactions that have a transaction date that falls in the previous month?
  13. deBassMan

    Date question (should be easy!)

    Hi all I have a table of transactions which include a date field. I need to produce a column chart of the last six monthly total number of transactions. The chart will ignore current month and start with previous month, then work backwards to previous month etc for six months. I am using a...

Part and Inventory Search

Back
Top