Search results for query: *

Thanks for your 2 cents! I had assigned an ip address to each vlan interface on each switch and was confused about what to use an the default gateway. Since each switch could technically be a default gateway for the devices plugged into it, I wasn't sure which one I should use. To simplify my...

Thanks for the helpful information. You cleared up a gray area in my thought process and deserve a star.

Hi all, We just installed 7 3Com 5500-EI switches and have a basic configuration loaded with everything running on vlan1. My plan is to have vlans defined to segment out our voice traffic, network equipment, servers, and computers with the following ip schema; 10.10.10.0/24 - network equipment...

Set the combo box properties as: ColumnCount=3 ' ssn, lastname, firstname ColumnWidth=0";1";1" ' hide, 1 inch, 1 inch BoundColumn=1 ' bind value to SSN Doing so will display last name & first name and bind the hidden SSN value

Hopefully what I said makes sense...It has been a long day. Jason

Based on the SQL statement above, I'm not seeing any reason why your combo box would be limited to only one last name. I figured there would be an underlying DISTINCT in the SELECT statement - so my theory is blown out of the water. Try setting the RowSource of the combo box to something like...

What does qryPatientToCalcAge look like? Switch to SQL View and post a snippet if you don't mind. It is possible that the query itself is limiting the results in the combo box.

Sounds like the combo box's Row Source is being fed a SELECT DISTINCT statement. If that's the case you might want to change it to something like this: Select Distinct ([Last_Name] & ", " & [First_Name]) As [Customer Name] From TableName

There may be an easier way but this should work... Private Sub OptionGroupName_BeforeUpdate(Cancel As Integer) Select Case OptionGroupName.Value Case 1 TextBoxName.Value = "Open" TextBoxName.BackColor = vbBlue Case 2 TextBoxName.Value =...

Thanks for the response! Your function worked great after resolving a data type mismatch within my code. Nice, clean, and concise - I appreciate it. After much trial and error with other methods, I was able to get the desired result with DSum and passing it the same criteria as the RowSource...

Is it possible to sum a column in a listbox and display the result in a textbox? Something like this: TextBox = Sum(ListBoxName.Column(1))

I have been trying to duplicate ComponentOne's TrueDBGrid FilterBar control for a couple of days now and have finally been successful with the following code. This is a pretty simple way to create a Search Form where a ListBox gets filtered on every letter a user enters into multiple texboxes...