Search results for query: *

Hey! That worked great! Many thanks to both of you especially VRoscioli!

I need to build a query from a list of items in a text box. The text box will contain around 40 items most of the time. I have created a form with the necessary objects such as a text box for the item list and a text box for the date. Basically what the query needs to do (as you can see below)...

Thanks for your response PHV. I tried to use your suggestion but I still had the same troubles. I did, however, realize that I can use the ID field from the users table instead of the actual user name which basically took the Doe, John and its comma out of the mix completely. Thanks again for...

I have a query that is breaking and I believe it is because of the data that is going into it. The query picks up info from a text box called txtUser which contains a name formated like: "Doe, John" (remove the "). I assume the , is killing the query. If so, how do I fix that? Dim...

OK. All is well. Thanks to mstrmage1768 for putting me on the right track. Private Sub cboEqlist_AfterUpdate() Me.cboLenlist = Null Me.cboLenlist.Requery Me.cboLenlist = Me.cboLenlist.ItemData(0) Dim strSQL As String Dim strColCount As String Dim strColWidth As...

Here's what I have come up with so far. Private Sub cboEqlist_AfterUpdate() Me.cboLenlist = Null Me.cboLenlist.Requery Me.cboLenlist = Me.cboLenlist.ItemData(0) Dim strSQL As String Dim strColCount As String Dim strColWidth As String Dim strColBound As String...

Ok! Thanks mstrmage1768!! Im almost there. Here is what I have so far: Private Sub cboEqlist_AfterUpdate() Me.cboLenlist = Null Me.cboLenlist.Requery Me.cboLenlist = Me.cboLenlist.ItemData(0) Dim strSQL As String Dim strEqtype As String Dim strEqtrunk As String...

Im working on a database to track information about our phone switch. I have a form for adding a new phone/device and on that form there are currently three combo boxes that are built based on information in the other combo boxes. They are cboEqlist, cboLenlist, and cboExttrunk. cboEqlist...

I hate to keep responding to my own thread but I'm still in need of assistance. If there is anyone that can help me with this problem please respond. Thanks!!!

Maybe like this? Me!cboExttrunk.RowSourceType = "Table/Query" Me!cbxExttrunk.RowSource = strSQL

This will show that I really don't have a head for programming! :P Dim strSQL As String Dim strEqtype As String Dim strEqtrunk As String strEqtype = Me.cboEqlist strEqtrunk = "TRUNK" If strEqtype = strEqtrunk Then strSQL = "SELECT tblTrunks.ID, tblTrunks.trunk, tblTrunks.inuse " & _...

Im working on a database to track information about our phone switch. I have a form for adding a new phone/device and on that form there are currently three combo boxes that are built based on information in the other combo boxes. They are cboEqlist, cboLenlist, and cboExttrunk. cboEqlist...

Thank you WildHare. I am working on building the database portion up a bit then I am going to move back to the forms. I will let you know if it works. THANKS!!

I am working on a database to record information about phone extensions on our phone switch. I have a table with three columns: -------------------- | ID | EXT | INUSE | |----|-----|-------| | 1 | 243 | 1 | | 2 | 192 | 0 | -------------------- ID is the record ID, EXT is the...

Hello everyone! I am attempting to help our AS400 admins solve a problem with excessive query times in a new application they just deployed called Innoprise. The application runs via the Jboss application server on the as400 and we are often time seeing http requests taking in excess of 2...

Hello all! Here is what I want to do. At login I want to check to see if printer \\bhc2\cd_3800dtn is installed. If that printer is installed I want to end the script. If that printer is not installed I want to remove a couple of existing printers and install a new printer. The existing...

Thanks Tony, but, I've seen that page a couple times and unfortunatly its no help. I did find a reg hack that will remove the service and the bar. Windows Registry Editor Version 5.00 [-HKEY_CLASSES_ROOT\CLSID\{540D8A8B-1C3F-4E32-8132-530F6A502090}] @="Language bar"...

I'm nearly at my wits end. There must be a way to automatically disable, remove, or simply not install the Language Bar that shows up on the task bar. The only thing I have been able to find anywhere on the net is how to do it manually (uncheck the boxes). I also found a little reg hack that...

Thanks for the input Andy. I'm convinced myself that they wouldnt be worth it in my environment. I dont know that I could live without the CLI and have yet to be impressed by any Cisco GUI based configuration tools. After some research I believe that I am going to go with 2960's (which came...

Has anyone had any experience with this 'new' line of switches? I'm liking the price but I dont want to get caught up in one of those "you get what you pay for" type situations. To be more specific I am looking at the Cisco Catalyst Express 500-24LC model. The other option is to go with the...