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 LesMartin

  1. LesMartin

    MS Publisher like document (VB6/Access)

    Hello All, I find myself not knowing what to do again!! I have a form that displays around 60 textbox controls. These controls are set out on a form as if the form were a landsacape document and pull records from a database when the user chooses to. This all works and prints fine. My problem...
  2. LesMartin

    SQL query runs but doesnt filter properly(VB6,SQL,Access DB)

    Thanks so much
  3. LesMartin

    SQL query runs but doesnt filter properly(VB6,SQL,Access DB)

    Hi Guys, Can anyone help me with my SQL here, the recordset pulls a field called [field_name] but it must not = the var "progenyname" or the text values 'Unknown2' and 'Unknown' The code below runs but still picks out the 'Unknown2' for some reason. Any thoughts are very welcome...
  4. LesMartin

    using "OR" in an SQL select statment in VB6 (Access database)

    Thanks Zemp, I didnt realise this with the underscore, I will bear that in mind when naming fields in my databases in future. Thank you
  5. LesMartin

    using "OR" in an SQL select statment in VB6 (Access database)

    Thank you so much,
  6. LesMartin

    using "OR" in an SQL select statment in VB6 (Access database)

    Hi Guys, Can any one tell me whats wrong with my syntax in my Select statment below. It runs if i just query field_1 on its own, but when I add the OR it wont go?? Any suggestions are very welcome. Thanks Set rs2 = db2.OpenRecordset("SELECT * " & _...
  7. LesMartin

    Zoom a Form In And Out

    Hi P What can I say but thanks a bunch. Your help is appreciated, I'd would never have came up with that. Many thanks
  8. LesMartin

    Zoom a Form In And Out

    Hi P Right so If i were to use that example on form34, would I just replace Text 1 with a list of all my form controls? like Private Sub Form_Resize() Dim Factor As Double With Me If .Width < 5000 Then .Width = 5000 .Height = .Width * (4 / 5) Factor = .Width / 5000 End With With...
  9. LesMartin

    Zoom a Form In And Out

    Hi P Yea I think that sounds about right for what I need to do, but to be honest Im not sure where to begin? Thanks again
  10. LesMartin

    Zoom a Form In And Out

    Hi P Yes the form 34 is a child form. I have a resize control modual that form34's On_load & On_resize events were calling, this was to keep all the controls on the form in proportion to the form34 if it were resized, if I remove these references to the modual the form resizes in and out by...
  11. LesMartin

    Zoom a Form In And Out

    Hi, This is my first post here so I hope Im in the right forum. Im pretty new to VB6 and have got a little stuck with my app(Just a pet project I have). I have a MDI form On the left of the MDI I have a picture box control im using as a container for my search records controls, when a search is...
See more

Part and Inventory Search

Back
Top