Search results

Hello, I have a combobox control bound to a table, and pre-populated with a query. Choosing something in the combobox should not update the table, but I would still like to be able to pick from the list. When I click the mouse on one of the items in the combobox's drop-down list, the...

Hello, I have a table as such: NAME RANK WIN_PERCENT DRAW_PERCENT The table can have the same people in it multipe times, such as: NAME LEVEL WIN_PERCENT DRAW_PERCENT Bob 4 80% 4% Bob 5 90% 5% Bob 8 60%...

Thank you both for the responses, both approaches are useful to me. -Scott

Hello, I have an employee table set up like so: NAME, SALRY, SUPERVISOR_NAME This table contains a large group of employees, and every employee has a Name, Salary and Supervisor. Some of these employees are also Supervisors, and hence they are in the table once as an employee but also have...

Thanks Keith...

I think I have answered my own question by searching these forums and playing around a bit... BeforeInsert and AfterInsert events seem to be what I'm after. I've done some coding and have solved my inital problem. Now, I'd ideally like to elliminate the default Navigation Buttons and only...

Hello, I have a continuous form bound to a table. The form's Navigation Buttons property is set to Yes, so I have the buttons at the bottom of the form giving me the ability to navigate between records, and especially the ability to add a new record (the button with the Arrow and Asterisk)...

Much easier indeed, thank you!! -"George" a.k.a. Scott

Bob, Thanks for the insight. Not sure why I didn't see a simpler solution at first :P Are you still assuming the form is using a multi-column query that populates the combobox? So the combobox will still be populated with two columns, like: Apple, M Grape, S Banana, M etc. Where the first...

Hello, I have a continuous form bound to a table. I have one control on the form, a combobox. When I select a new value in the form's combobox (which is bound to a field in the table) I would like to update a "hidden" field on the table, in the same record. By "hidden" I mean not visibly...

Thanks that was very helpful ;)

Hello, I saw a thread on this once, but wasn't sure if it hit every point. When does a query bound to a form officially become UNupdateable? I have a query that was updateable (I could change the value in a text control on the form, say FIRST NAME, and results would save to the database). I...

Oh yeah, the Bound Column property of the ComboBox was also something that's used to link the Combo Box to the Form...

Banana, Thanks for the info. I am using a query in the Row Source of the Combo Box. I wanted to use DAO to add a little search feature to the app, which tied the Combo Box's selected value to the current record on the form, and hence the rest of the Form's Controls. The tip above worked...

pbaldy thank you, that is just what I was looking for :) -Scott

Hello, I have a question on DAO. I have a Single form that is bound to a table with 15,000 records. The form has several controls that are each bound to a field in the table. I have a combo box that is bound to a query that selects the primary key of each of the 15,000 records. If I select...

Thanks again Bob, exactly what I needed. FYI, I searched first but didn't see that thread in my results.

Hello, I am using a subform, and when I want to access that subform's properties and methods in VBA from the Main Form's module, I have had to access it as a Control on the Main Form, i.e. MainForm.Controls("Name of subform").Property/Method The problem I am facing is, only the...

That worked wonderfully thank you.

Hello, Is there a way within VBA to determine which tab the user has just clicked? I am using the ON CHANGE event, and with this I can detect that the user has clicked any tab, and I can execute some code when this happens. But I have some additional code I would like to only execute when the...