Search results for query: *

I tried commenting out the following lines from the example above to see if I would get a different result. I get the same result. To me, this would indicate that SendMessage() is doing nothing. I'm continuing to look for a solution. ' hWndSB = GetFocus ' LngThumb =...

First, let me start by thanking everyone for your support and patience with my previous posts! After setting aListbox.ListIndex I'm attempting to scroll the listbox so the ListIndex entry is displayed at the top of the listbox. Instead, it seems to always be displayed at the bottom. What...

Access 2003. Can you tell me more about the rule?

Ah. Is it that one refers to the Control and the other refers to the Source Object? The light might be getting a bit brighter.

Yep, I know the difference. And yes, I named them the same. I'm not very imaginative :) I tried tweaking the Requery. This works. Yippee!!! Forms!DBTRacker.Form!EmailTracker.Form.Requery Can someone provide a technical explanation of the difference between the above statement and the one...

Yep. Sorry, I typeo'd the post. I have the dot in the real code. It doesn't work. I tried other approaches. This is the latest...real code. DBTracker is a tabbed form. One of the tabs holds the form "People", and another form "EmailTracker" ' Code executed from button on the People subform...

On Form0 I have a tabbed form. On Page1 I have Form1. On Page2 I have Form2. Form1 has a button that adds a row to Table2 that is displayed by Form2 Form2 is a continuous display form that uses a query as its Record Source to display Table2 rows. After clicking the button on Form1 to add a...

I'm still not sure why AddItem slows but I've now recoded the routine that populates the listbox, avoiding use of AddItem, and instead, building a string of values in a loop and then setting RowSource to the string. But the question remains unanswered. Why does AddItem slow with each add only...

This is just plain weird (for the less intuitive). In the slowdown scenario I commented out the addItem. Processing the recordset was no longer slowed. So I've narrowed down the problem to be related to listbox.additem. Thinking that it might be related to having an item selected (even...

I have a form "aForm" that that is bound to a table "aTable". aForm displays a row of aTable. The record selector is used to move through the rows. Since I have about 2500 rows in the table, I created a popup listbox that lists 2 principle fields, 500 rows at a time. The user clicks on an item...

I figured it out. The answer to my own question is no, the form name is not equal to the subform control name. The subform control name can be found by opening the main form in design view, and opening the code view (Alt-F11), then scrolling through the Code View Properties window combobox to...

I need a bit more explanation of the reference to subformcontrolName. Let's say my main form is "MainForm". It has a tab control called "TabCtl0" It has several pages ... called Page1, Page2, etc It has several subforms.. one called "aForm" Does the subform control name equal the name of the...

The hint about LEFT/RIGHT JOIN solved my problem. Thanks dhookom!

OK. So here is the real SQL. I've also included a link to an image of the query design tool. Anytime the ID reference to a related table is 0, that row is not returned even if the WHERE clause is satisfied. LEFT/RIGHT JOIN was mentioned. I'll read up on that. SELECT ServersIPDups.[DB Server...

Well, this worked ... but didn't. When I open aForm as the first form (clicking on it from the list of forms) and then I click the button to open bForm, the reference Forms("aForm).Recordset works. However, aForm is normally displayed (opened) on a tab of tabbed form. So, while on the tabForm...

I have a table that contains rows. (duh) The rows have String fields and a few Long fields. The Long fields reference the IDs of related table rows. So far .. nothing unusual. I created a query using the design tool. I designated that I want the query to return all of the rows matching one of...

The format for the Me.Recordset statement is exactly what I needed. No work around required. I just put that at the beginning of the Form_Load() and followed it with LoadtheListbox code. Thanks!

bForm is a popup that contains a listbox that I want to populate based on the recordset being passed. I wanted to use the bForm Load function to populate the listbox. It seems that I need to take another approach. One way would be to code the bForm Load to get the parent's recordset but I can't...

I've read other posts but I'm having a problem with the solution pasted below: Dim stDocName As String Dim stLinkCriteria As String stDocName = "bForm" DoCmd.OpenForm stDocName, , , stLinkCriteria Set Forms(stDocName).Recordset = Me.Recordset The above code opens the form...

I think I found the answer. Is this it? Dim Myrst as DAO.Recordset Set Myrst = Forms!Form1.Recordset http://msdn.microsoft.com/en-us/library/aa173231%28v=office.11%29.aspx