Search results for query: *

I'm interested...

Sorry, Sorry. I figured it out. Thanks.

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?

Yup, that did it. I just clicked too fast on the set up. THANKS!!!!

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

YES, YES, that is exactly what I wanted to do. THANKS

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

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

How? I tried referencing the list box directly, it's control source, and the query that is the control source directly. None worked.

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

EXACTLY what I was looking for. THANX

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.

Further, I'm finding that the function is actually picking up one of the values from the previous line's textbox. This is getting crazier.

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