Search results

Thanks, I used DAO and its' working. What do you mean I can insert/update/append the data. Do you mean add additional fields to my query result so I have new fields that the form is bound to?

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

Was missing a set of [] in the original query, nevermind.

I've used the code below and I'm getting an error pop-up: Wrong data type for parameter 'ParamCountry'. MyTable.Country is of type Text. Any ideas?

Thank you bytemyzer that's exactly what i was looking for.

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

Ok nevermind. The Details section wasn't resized yet. I was getting all of the records, I just couldn't see them cuz the form's size was too small :P -Scott

For the form I'm working on, I would like one text box to appear for each field in a record. I have bound my form to a query that returns three records. Each record has four fields. So ideally I would like three "rows" of four textboxes, each row holding the fields of a record: Field1...

Thanks Rainman :)

Default View is set to Continuous Forms. Is that the trick?

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