I would like to create a chart that shows available funds and expenditures in the data section of a chart with invoice numbers as the "X" axis and dollar values as the "Y" axis. I have all of these values in one table. Is this possible? If so, how?
Thanks for helping.
Yes, (I just figured out) the form is opening to a new record. However, the code to select the form's record (therefore filling the textbox controls) from the listbox's selection does not work.
My form is linked to a table, and I have controls linked to the table's fields.
I also have a listbox also connected to the table. I use the listbox to select the record for the form/controls.
When I call the form from the switchboard, the controls are blank and the listbox does not select...
First, THANK YOU for your timely support in answering my question.
Second - Yes, thanks to your help, I got my app working exactly as I want.
Third - OK, NOW I see what the problem is. I quoted what was in the "Example" section at the bottom of the page. I see what you quoted at...
But I see several posts in these forums that show code to set the listindex property. As I look in the help files, I see this example:
To set the ListIndex property value, you can use the following:
Forms(formname).Controls(controlname).ListIndex = index
For some reason, when I try to set the listindex property of a combobox, I get an error saying I have used the listindex property incorrectly.
Any idea why I get this?
Maybe someone might have an easier method, cause I only know how to do it with code:
Dim qDef As QueryDef
Set db = CurrentDb
Set qDef = db.QueryDefs("NameOfYourQuery")
qDef![ParameterName] = YourComboBox.Column(BoundColumn,YourCombobox.Listindex)
"Set report query to "...
Can I have my tables NOT listed in alphabetical order?
I know its a strange question, but a co-worker renames his tables and looses the newly created table.
I know, I know, he could avoid the problem by changing the LAST part of the table name to keep that from happening, but you know how...
Is it possible to use code to change the printer property when printing a query? I see lots of info about how to change it for a report, but not when printing a query.
I have a form where the user selects from available fields to dynamically generates a query, and I send the results to another...
Somewhere along the way I created a name for the database that shows up in all of the forms. Now my client wants to change the name. How do I do that? I know that I can ADD to the titlebar with the caption method, but I want to change the name of the database in the titlebar as well.
I have a function that fills three textboxes when I run my report. The fuction is used as the data source of the third box. This is because one of the arguments is supplied by another textbox's value in the grouping.
Now here's the problem. On the first line the function is called, for some...
Sorry.
The stupid thing I did THIS time was set the reference to DAO 3.6 and not 3.5. Once I made the switch, I had no problems.
I can be SUCH an idiot at times.
I keep getting this error message. I link Oracle tables to an Access db, make a DAO call to Access, and use an SQL statement to generate a recordset in VB. I know the Access connection is good because I can view the records from Access. Also, I can use the ODBC driver to manually connect...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.