Search results

Let me get back to you in a little while. I'll drive home first.

That's what he said no? :-)

You would only populate the listboxes after the combobox is updated. So I'd leave the listbox default rowsource empty. In the afterupdate event of your combobox build the 2 sql statements and add them as row source. Any further questions just ask. :-)

I'm guessing this: dim count as integer count = DCount("tdAppointmentID", "tdAppointments", "TDIsTarget = true AND TDCompleted IS NULL")

Your SQL in the left listbox would show the entitlement records that don't exist for the current system. Something like this: SELECT e.EntitlementID, e.EntitlementName FROM Entitlement e WHERE NOT EXISTS ( SELECT se.EntitlementID FROM SystemEntitlement se WHERE se.EntitlementID =...

Is there any way to capture an event of a child form? The child form is a separate form, thus not a subform. Something like this: Private WithEvents child As Form Private Sub child_OnUnload() MsgBox "Child closing" End Sub

Hi all, I have a ListView which is anchored to all sides of the form. When I maximize the form, the ListView will grow in size accordingly. However, the ListView.Height and ListView.Width properties don't change to reflect the new format. For example: - Default ListView.Width = 8000 - I...

Thanks all for the info and suggestions.

Dear all, I know that in Access you can bind the value of one control to the value of another control. For example: txtFirstName.ControlSource = lstEmployees.Column(1) Is there a way to do the same for class objects. In other words, can I bind the properties of an object to a control...

Haha, don't focus so much on how I'm updating my silly countries. In this example the selection might be limited to 1 country at a time (how often does a country name change anyway). But I'm sure you can imagine situations where opening similar forms with different data behind might be useful...

I'm just toying with objects and new ways of doing things. I thinking: should my form really make sql statements? Depends on the situation of course, but in the first place I see a form's purpose as a means to interact with the user. In this case my form allows the user to select countries and...

That's the essence of the question. How to make the form exist beyond the scope of the sub. Well, here's what I've come up with. In the main form I've added a collection to hold the newly created editForms Private editForms As Collection Private Sub btnEditCountry_Click() Dim c As...

Hi and thanks for taking interest. The idea is that if I would select multiple countries (fe. from a listbox), I'd be able to show multiple instances of the same form, but each with their own country objects in the background. On each 'frmEditCountry' form I'd be able to edit the country...

Hi, I'm trying to create a new instance of a form, add a property (class object) to it and make it visible. The best I've done is the code below. But this only shows the form for as long as the code runs. In other words, the form becomes visible and disappears again immediately. Private Sub...

Thanks Bob, I'll look into it today!

I've created a simple ribbon: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="tabForms" label="Forms" visible="true"> <group id="groupExperiments" label="Experiments"> <button id="btnOverview"...

I've never worked with a QueryDef object. I don't mind looking into it. However, am I going to bind the recordsource property to this object then? And how will this change the number of fields in the subform. Won't they still be there?

Hi all, as per the title I've got a subform formatted as datasheet. On the main form I'm changing the recordsource of this subform: subOverview.Form.Recordsource = "SELECT * FROM tblCustomers" Let's say this results in 10 columns being returned. Now I'm doing another query...

Nice to see that you were able to do what you wanted! xD

So the different fields are represented as what on the form? Textboxes? Haha, I'm having trouble visualizing what you're doing... Here's at least something to simplify your load of if statements. Try a Select Case statement instead, less typing work. :-) Dim d As String Dim i As Integer For...