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
...= "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 -...
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"...
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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.