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

    How do I Search for multiple instances

    That worked a treat thanks alot now I have the payrolls I can get the users names :)
  2. Trowser

    How do I Search for multiple instances

    Hi guys I have a table that stores all the hardware that users have on site, some of these users have more than one piece of hardware like multiple machines etc Now all the users machines are referanced to them by thier payroll number for example ID (autonumber)(key) - Payroll - Machine -...
  3. Trowser

    Combo box not populating

    ok still have a problem with this for some reason CostCentre.ControlSource = "SELECT Departments.[Cost Center], Team.Team" & _ " FROM Departments INNER JOIN Team ON Departments.[Service Manager] = Team.[Service Manager] " & _ "WHERE (((Team.Team) Like " &...
  4. Trowser

    Combo box not populating

    Ok thanks Roy and make it so I tried loads of differant ways and both of your suggestions (Combo fires on focus) and well I found the problem why it wasn't populating and that was because the first 2 combo boxes were returning garbage :) Thanks for the help though
  5. Trowser

    Combo box not populating

    ...= "SELECT Payroll, [First Name], Surname FROM UserDetails " & _ "WHERE ([First Name] LIKE '" & fname & "*' " & _ "AND Surname LIKE '" & sname & "*');" cboPayroll.Requery End Sub ok changed it to look like the above and still no result FYI -...
  6. Trowser

    Combo box not populating

    Ok I have a series of combo boxes and I want each combo box to display the data depending on whats in the other combo boxes. but I cannot get the combo box to populate any data I get no errors and even when I put a break on the event procedure nothing happens. Option Compare Database Dim Fname...
  7. Trowser

    Adding Columns to Existing Table

    ok get errors again about objects I think I have an idea on why The code is running but I think that it doesn't know what table to append the columns so it errors out with a more useful error such as "right trying to append nothing as I have no idea what table you want me to append&quot...
  8. Trowser

    Adding Columns to Existing Table

    thanks should have thought of that but now I get the error You can't referance a property or method for a control unless the control has focus
  9. Trowser

    Adding Columns to Existing Table

    I have a form which shows a users details for an audit Now these users have many app's but I dont know what they are so I created a command button to add applications to the applications table. This brings up a form with a textbox and a command button labeled Add application. When clicked I want...
  10. Trowser

    Cannot get CDONTS to work I recive no mail

    ok I found the problem Seems like I renamed MemberID to Member_ID (on the form page) so the var wasn't being passed and being picked up Now since I am new to ASP but I do program VB I thought this would throw up an error but it doesn't something I am going to have to watch in the future...
  11. Trowser

    Cannot get CDONTS to work I recive no mail

    Thanks Atmo I will try it and see
  12. Trowser

    Cannot get CDONTS to work I recive no mail

    yup mine looks the same Grrr it annoying me now :)
  13. Trowser

    Cannot get CDONTS to work I recive no mail

    Hi guys this is the Asp Code I amd using from a form in oder to send the forms results back to us by email for some reason we have never recived an email back dunno if I have messed something up in the code could someone look over it for me please <%@ CodePage=65001...
  14. Trowser

    Skins in VB6?

    Thanks Jam thats a great OCX and cheap aswell well worth 15 bucks
  15. Trowser

    Skins in VB6?

    Thanks lads I will look into it more :)
  16. Trowser

    Skins in VB6?

    Is this possiable I see it for programs where you can get skins for it but can you do the same in VB?
  17. Trowser

    With Multiple forms how do I check that a form is open

    Thanks guys Doc that worked fine and dandy Clint Cool Adapting code to do that :) Thanks
  18. Trowser

    With Multiple forms how do I check that a form is open

    ok thanks guys I will try those ideas
  19. Trowser

    With Multiple forms how do I check that a form is open

    No not that way m8 I dont want it to go behind the form I want it to go beneath the form If form1.height = 1000 then me.top = 1000 elseif form2.height = 1500 then me.top = me.top+1500 end if me being the third form but I want it in any order I wanna be able to count the ammount of forms...
  20. Trowser

    With Multiple forms how do I check that a form is open

    I have 8 forms when a user opens one form it shows up when he opens the next form I want that one to show up below it when he opens the next one it shows up below the other 2 in, and it makes no differance what order he opens the forms.

Part and Inventory Search

Back
Top