Recent content by armychick86

Ok, my tables are as follows: tblComputerMaster ComputerName(P) Network Switch Port tblNetwork NetID(P) Network Description tblSwitch SwitchID(P) NetID Switch tblPort PortID(P) SwitchID Port Active (Yes/No)

I tryed that, it still didn't work.

Here is the code that I have: Private Sub cboPort_AfterUpdate() If Me.cboPort >= 1 Then Me.chkActive = 1 Else Me.chkActive = 0 End If End Sub I placed a checkbox on the form and changed the visibility to "no" just to see what it would do.. thats where the "chkActive" comes in...

Thanks for all your help... but its still not working like I want it to... it keeps coming back with an error: "You can't assign a value to this object". Now... the checkbox is not part of the form that i'm working with, its part of tblPort. It allows me to filter what ports are active and which...

Let me put it to you this way... my username isn't armychick86 for no reason. I am currently deployed with the Army in Iraq. No matter what I do with the time I am here, I will still get paid the exact same. Doing this not only occupies the year I have left to spend over here but it also makes...

Well thank you Bob, but no I would prefer to do this myself (with the help of those willing).

Thanks for your input mailman, I have successfully made a cascading combobox for network> switch> available ports. I created the table named tblPort (I was an idiot for not thinking of that before), which has the fields: PortID (P) SwitchID Port Active - yes/no Now all I need it to do is...

Hello all, Using Access 2003, I am creating a db that tracks computers along with what switch and port they are connected to. I have 5 different networks along with 31 switches. I have a cascading combobox, in my form, that gives me a list of what switches correspond with the network chosen...

Sorry it took me so long to reply to that last post. The default value is set and all three fields are changed to text.

I hate to be a bother but have you come up with a solution on why the disable/enable textboxes are not unique to one record but all of them?

Thanks Bob, If fixed the AfterUpdate it works like it did before now... i'm still working on deleting [forms]![frmDevices].[DeviceID]... as for changing the Device ID i understand why i would want it to be a number not text, and for the DoCmd.DoMenuItem codes, I used access to generate those...

try that one.. i am using winzip 11.. but i changed the compression mode so hopefully it will work now

It unzips fine on my computer... I posted it again in thread: http://www.access-programmers.co.uk/forums/showthread.php?t=122870 there are purposeful errors pertaining to that thread though... if it works let me know and ill post a better one here as well....

I compressed and zipped it again... I hope it works this time... On the last one I didn't have the code that was screwing it up... but i put it back this time... so thats why you'll get an error when you fisrt open it. I only entered it so you would get a better idea of my problem... Thanks...

When I unzip it, it works fine... I'll try again... Thank you so much for replying