George Allen
Last Activity: Jun 2 '11, 07:12 PM
Joined: Feb 1 '11
Location: Omaha, NE
-
George Allen replied to Why does selecting item on combo with callback function cause next callback to fail?in AccessThanks again. I will look at making the change. It was an earlier suggestion of yours to try and make another part of this work. -
George Allen replied to Why does selecting item on combo with callback function cause next callback to fail?in AccessFigured it out. I was closing my ADO connection eveytime I used it so I could try and release resources I was not using. Everytime I closed the connection through a DWConn.Close, I was wiping out my provider list. My thought was that each time I called the connection for an ADO call it was a seperate connection. Guessed wrong.
Thanks for your help. Your insistence on looking at Box B afterupdate pointed me in the right direct...Leave a comment:
-
George Allen replied to Why does selecting item on combo with callback function cause next callback to fail?in AccessYes there is. The code connects to another SQL table and then changes the size and layout of th eform to accomodate data from that other table.
...Code:Private Sub cmb_Provider_AfterUpdate() Redraw_Form DW_Connect rs_ScoreData.CursorLocation = adUseServer strSQLScore = "Select oppesid, measure_ClassSID,measure_Class, Measure, Benchmark, Max(ScoreDate) as Last_Date,Leave a comment:
-
George Allen replied to Why does selecting item on combo with callback function cause next callback to fail?in AccessNope, no better. Removing ERASE line does not affect the content of the combobox. It still ends up blank.
I followed code in the callback function. Once I select a item in box B, then select the Box A (even before I make a selection) the callback function is called by the control for the following codes in sequence (By breakpoint check on line 28):
6, 7, 6, 7, 6, 7
After this I make a selection and the callback...Leave a comment:
-
George Allen replied to Why does selecting item on combo with callback function cause next callback to fail?in AccessOK, I will give this a shot. I do realize that the acLBGetValue is where the data is being placed in the control, but the code never goes there when it should be.Leave a comment:
-
George Allen started a topic Why does selecting item on combo with callback function cause next callback to fail?in AccessWhy does selecting item on combo with callback function cause next callback to fail?
So, I have two comboboxes on my form. One has a vlaue list (A), then other uses a callback function to populate (B) items based on the combo A selection. If I select something in A, then the function correctly populates B. I can do this over and over. However, if I select an item in B, then go back to A to select a different filter, the callback function does not populate B. One thing I noticed was that the combobox.value is still set to the... -
Thanks for the helpLeave a comment:
-
Well, I fixed my own issue, but I think it was because there is something wrong with the code still, I just found a workaround. What I did was to stop building a new criteria string when I come in like I was:
...Code:If Not IsNull(Me.cmb_Svc_Section) Then StrSQL = "Select * from dim.Provider where InactivationDate is null and ServiceSection like '" & Me.cmb_Svc_Section.Column(0) & "';"Leave a comment:
-
Well, that got halfway there. Now I am able to change box B and see new data in box A, but then if I change box B again, I end up with nothing in box A. I used your RowSourceType suggestion.
When I go through the second time the code jumps out when it hits the Redim statement at line #64. Is this a problem with Redim twice?Leave a comment:
-
Why does requery on combobox callback function not requery?
I have a callback function that correctly fills a combobox (A) with two-column data on load. I have a second combobox (B) that acts as a filterchoice for the first. When the combobox B is updated, I have a AfterUpdate event to requery the combobox A. However, the process doe snot change a thing in combobox A. Watching the code run through I see the function correctly create the new array needed, but the function never goes to the acLBGetValue... -
George Allen replied to Why is Listbox callback function acLBGetColumnWidth getting called too many times?in AccessDon't think that really matters since the Redim and the Move.First/Last are of two different items.Leave a comment:
-
George Allen replied to Why is Listbox callback function acLBGetColumnWidth getting called too many times?in AccessNever mind. I found my errors. As I played more wit hthe code it turned out I was reading one record past the end of my recordset. Basically, the "fcount = fcount + 1" code needed to move to follow the two feed lines. This got rid of my null first record and then also helped me land on the right record in the end. See, All I needed to do was try asking someone else and feel embarassed, to figure it out.Leave a comment:
-
George Allen started a topic Why is Listbox callback function acLBGetColumnWidth getting called too many times?in AccessWhy is Listbox callback function acLBGetColumnWidth getting called too many times?
I have been experimenting wiht using the Listbox Callback function to solve an issue I have with my db tool. The function below connects ADO to a SQL server database and table and reads those members of the table that fit the criteria and then fills in two columns in my listbox.
So far, it appears to init well, filling the array properly. What I am having a problem with is the control calls with the code acLBGetColumnWi dth (5) three...
No activity results to display
Leave a comment: