Search results

I've been searching the forums for some time now and have not found an answer to this question: When I write a formula to Excel using Access VBA, why does Excel show the formula syntax as the value of the cell instead of the result of the formula? How do I write my procedure to force Excel to...

Is there a property that I can use to change the datasheet for a chart from Series By Row to Series By Column?

I have a form with a combo box that contains a list of customers. Select a customer from the combo box and the form fields populate with general customer info. The form has a subform on it with a combo box where you can select products. Select a product from the combo box and the subform...

Recordset.Open returns no records when I use a query with a join in it as the source. If I change the source to a simpler query (with no join), I get records. What's going on???!!!

I have captured the following variable, which will change depending upon the value(s) a user chooses from a list box that contains a list of fields to display on a form: 'Forms!frm1!txt1.Visible = True Forms!frm1!txt2.Visible = True Forms!frm1!txt5.Visible = True' Now this variable needs to be...