Recent content by efiftythree

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