Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ricm9
  • Order by date
  1. ricm9

    I hav 10 forms and how can i add them into a

    I'm interested...
  2. ricm9

    Merge two values in chart data

    Sorry, Sorry. I figured it out. Thanks.
  3. ricm9

    Merge two values in chart data

    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?
  4. ricm9

    Textbox doesn't grab record

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

    Textbox doesn't grab record

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

    Textbox doesn't grab record

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

    set listindex

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

    set listindex

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

    set listindex

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

    set listindex

    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?
  11. ricm9

    Basic Report Generation Question

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

    Alphabetized table names

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

    print QUERY in landscape

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

    print QUERY in landscape

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

    Database name in titlebar

    EXACTLY what I was looking for. THANX
  16. ricm9

    Database name in titlebar

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

    unbound textboxes not filling in.

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

    unbound textboxes not filling in.

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

    error 3151 - - connection to Oracle failed

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

    error 3151 - - connection to Oracle failed

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

Part and Inventory Search

Back
Top