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%...

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...

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)...

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...

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...

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...

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...

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...

Hello, I have a subform that is bound to a query. I have some textbox controls that are bound to fields in that query. Everything is working fine. I also have another control, on the same subform, that I would like to bind to a different query altogether independent of the query that's bound...

Hello, Can Access handle paramater-passing without getting into the object model and adding a "Parameter" datatype to a query and calling DoCmd.RunSQL etc, and also without prompting the user? Is something like this possible (as it is in SQL Server I believe): SELECT * FROM some_query_that...

Hello, I've got two questions: 1) Can you use a parameter in a subquery? 2) Can the parameter value be the value from another field in the query? In a nutshell, I want to write a query that returns these fields about some marbles: Color of Marble Marble Stat1 Marble Stat2 Marble Stat3...

Hi, I was given form as a "guideline" to use for some development. The form has three controls in its Details section: combobox, textbox, command button. The are displayed in a "row" on the form: COMB TXT CMD When a value is selected in the combobox, a new row of the same three controls...

Hi, I have a Main form that spawns other forms. Currently, when I click a button in Main to spawn a new form, a new window is opened containing the new form, and the current window containing Main stays open. Is there a way to keep only one window open, and have the new form appear in the...

Hello, I have four tabs, each containing a subform. During development, when I switch from Design View to Form View to see how my changes are looking, the tabs do not initially dispaly. Only after I hit CNTRL+TAB do they appear. Anyone know why the tabs don't show at first in Form View and...

Hello, Is there a way to configure Access so SQL View saves white space changes to a query? By white space changes I mean tabs, spaces and carriage returns added to make the query more readable in SQL view. For instance: When I'm editing a complex query in Access, I space it out nicely like...