Search results

any ideas on what to try next? I'm stuck. On a new form, a combo box works correctly and I can select values. Just not on my current form

Private Sub txt_Actual_Change() Dim sSQL As String sSQL = "UPDATE TableA SET Actual = " & Me.txt_Actual.Text & ", Target = " & Me.txt_Target.Text & "WHERE FormName = 'TestForm'" DoCmd.RunSQL (sSQL) End Sub Every time I load the form, I get an error message saying I can't reference...

I need to have 2 textboxe son my form that are directly linked to data in a DB so that the user can type values in directly. Unfortunately, the data for these 2 textboxes is completely separate from the main form's recordsource. Is it possible to do this using an expression? I've tried but it...

Yeah, it was created with the wizard. I tried one without and the same problem.

Row SOurce Type is Table/Query

Right sorry. When I wrote the original message I hadn't yet coded for the SQL. But now it is definitely being populated from some VBA SQL. Same problem however! The drop down works but I cannot select anything.

The combobox is unbound - it is being populated directly from a VBA SQL query. The Forms recordsource is not updateable - I have set deletions, additions, edits, etc. to No.

I have some combo boxes on a form with values that I have typed in directly. I would like the user to click on these and the option selected will dynamically change a resultset. Unfortunately, when I click on the combobox, the optionsare displayed, but clicking on each of the options doesn't do...

On one of my queries, the dataset is shown with a * as the last record. There's nothing in it apart from blank data but it is appearing on my forms. All my other queries do not seem to have this. Is there a setting to stop these from appearing ?

I have a form with 5 tabs. Each tab has 2 subforms. When the form loads I am trying to select it's recordsource by doing this: Me!Subformname_A.RecordSource = "SELECT FieldA, FieldB FROM TableA WHERE" However, it throws an error. Is there something wrong with this ?

More or less, yeah.

For some reason when I open my form, it does not start at the top of the from. Is there a way either through settings or within VBA code to automatically scroll to the top of the form when it loads?

bump ......

Hi I have a form with some tabs. Each tab has 2 subforms, of which the 2nd subform is always the same (call it SubformB). I had it set up before so that the SQL query to run is passed in the openargs property to that that form and this works well. However, on a tabbed form, each tab opens up...

Is it possible to adde extra filters to an expression, i.e. the same as an AND clause in a SQL query. For example, =DSum("[1To90]","tableA","ID=2") I need something like : =DSum("[1To90]","tableA","ID=2 AND Region='A'") Will that work ?

Yeah it needs the group by as the query is summing data from various records. The group by threfore facilitates this. To add a subform on the side, I will still need to link the record to the main form somehow. Is this possible? Perhaps with an expression in a hidden field linked to a box on...

I have some tab controls, which for some reason show up white. I have set their back style to transparent but it doesn't seem to show the grey Windows colour of the background form. Any ideas why ? AT the moment I'm having to put grey rectangles in various places to cover this up, which is...

Sorry, I meant to mention that. There is a group by clause in the query, which aggregates the data. The comment boxes would be inked to a separate table. Would some kind of subform work for the comments section? If not, then I am left with the choice of entering all the aggreagted data into a...

Hi I have a form which retrieves and lists data from a query. I need to add 2 textboxes on the end, which allow a user to add comments about the particular record, which are then saved directy to the database. Unfortunately, the query has joins in it so it is impossible to have the data directly...

Just to clarify, even if I add a separate text box on the form, I still cannot edit it even though it has no data in it. What's that all about ?