Search results for query: *

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

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

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 " &...

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

Ok thanks for the help lads :) I recognised some things you mentioned but been 2 yrs since I last had to look at VBA or VB so still trying to kick in my memory Private Sub cboPayroll_Click() Dim fname As String Dim sname As String fname = cboFname.Value sname = cboSname.Value If sname Is Null...

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

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

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

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

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

Thanks Atmo I will try it and see

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

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

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

Thanks lads I will look into it more :)

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

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

ok thanks guys I will try those ideas

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

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.