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!

  • Congratulations TouchToneTommy 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 golandsh

  1. golandsh

    Unload all forms vs. End

    If you are concerned with memory, why not check the proccesses in the task manager if you have win 2000 or better, or oanother application. so if all the memory was freed in both cases, then end is preferrable because it's more convinient.
  2. golandsh

    Help... Date Unrecognized...

    check the date format in your database and then use the format function to enter the date properly to the database the format function : Format(Date,"dd/mm/yyyy") for example try Format(cdate(Label2.Caption),(the date format));
  3. golandsh

    Run Time Error with ADO, VB6

    Why not trying: if adoName.RecordCount<>0 then Do Somehing?
  4. golandsh

    Run Time Error with ADO, VB6

    After the statement what kind of operation youre doing? Try checking the recordcount of the ado recordset after the sql statement so if the recordcount is above 0 then you do something else do nothing. i think even the movefirst procedure causes error if there is no record.
  5. golandsh

    Left Join Query Using Multiple Tables

    use this: from (ededuct e left join ebase b on b.flxid = e.deeflxideb) left join deduction d on d.dedflxid = e.deeflxidded
  6. golandsh

    SQL Query?

    you propably didnt write the table name properly
  7. golandsh

    SQL Query?

    It works just fine
  8. golandsh

    Form Resize at run-time

    Well there is the Form_Resize Method start with that
  9. golandsh

    ADODC Controls - change Recordsource

    Try writing Set before the lines with the DataSource Set adcSummary.DataSource=strFileSummary
  10. golandsh

    Scrollbars &amp; Forms

    I want to correct something, the frame1.top should be 0 on the form. the scrollbar will start from 0 so any change to it, it will affect frame1.top accordingly. hope it helps
  11. golandsh

    Scrollbars &amp; Forms

    Put all the controls of your form on a frame, the frame size needs to the size of the form. place the scrollbar next to the frame, and when you scroll down move the frame top downwards, so you'll see the frame(container) will rise upwards with all of it's controls in it. in the scrollbar_change...

Part and Inventory Search

Back
Top