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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by wandan

  1. wandan

    Reference column in list box that is not the bound one

    Thanks for the reponses! listboxname.column(1) worked perfectly!!
  2. wandan

    Reference column in list box that is not the bound one

    Hi there, I have a list box that has name and userid as the two columns. The userid is my Bound Column because I use that in most of my queries and code. But, I have at least one case where I want to show the name selected -- like in a report header. Is there a way to reference the unbound...
  3. wandan

    Build Query that Joins Two Queries

    Thanks for the help. I have narrowed down that it is a Crosstab query that is causing the problem.
  4. wandan

    Build Query that Joins Two Queries

    That's what I have now, but it doesn't work. To clarify, it works when I run the query the form reference is in. It doesn't work when I use that query as the source in another query.
  5. wandan

    Build Query that Joins Two Queries

    That makes sense. Currently I have two access queries (not the two in my sample - that was just to illustrate a point) that look to a form for some criteria. Then, I have been trying to create a third one that left joins those two queries. This third query doesn't work because it can't seem...
  6. wandan

    Build Query that Joins Two Queries

    Hello, I am using Access 2010 with VBA code. I need to create a SQL statement that I can use for docmd.RunSQL (strSQL). I know I have done this in the past but haven't been able to figure it out. I have Query1 and Query2. Then, I need to do a LEFT JOIN of the two results. Below is basically...
  7. wandan

    Check if spreadsheet is open

    Hello, I am using MS Access 2010. I have links to several password protected Excel 2010 files. In order to access the file, it has to be open. So, I added a call shell to open the file. I need to be able to check to see if the file is already open before running the Call Shell. Can anyone...
  8. wandan

    Don't Allow New Records to be Created in Subform

    I don't see the "Allow Additions" property for the subform. I created the subform directly in the main form. I did not create a form and bring it in. Thanks for the advice. I will see about creating a seperate form and bringing it in. Thanks again.
  9. wandan

    Don't Allow New Records to be Created in Subform

    Hello, I have a form with a subform. The subform is displayed in datasheet format. I need for the users to be able to edit the existing rows in the data set, but I don't want them to be able to create any new records. I can't figure out how to turn that off. Can anyone help me? Thanks.
  10. wandan

    Display multiple levels in Table of Contents in Word?

    That's got it... thanks!
  11. wandan

    Display multiple levels in Table of Contents in Word?

    I have a Word 2003 document created by someone else that has a Table of Contents. There are 3 levels to the TOC, but only the first level appears in the actual TOC. How do I expand that to show the second level? Thanks for the help!
  12. wandan

    Hide "select all" link under multi-select prompt?

    Hello, I have found code that allows me hide the "Select All/Deselect All" under a multi-select prompt. Is there a way to hide only the "Select All" side and leave the "Deselect All" side available? Thanks.
  13. wandan

    Audit Database Unit of Measure

    Hello, I am trying to convert the Execution Time from the Audit database to minutes (or seconds). Does anyone know what the unit of measure is for the Execution Time? Thanks.
  14. wandan

    Noncontiguous Range for ComboBox Row Source

    Ummm... how do I go about doing that exactly??? :-)
  15. wandan

    Noncontiguous Range for ComboBox Row Source

    Hi There, Is there a way to set the row source for a ComboBox to a noncontiguous range? I need the selection options to vary based on certain criteria. So, sometimes it might be just "A1", but in others it might be "A2,A3,A6", etc. I have found how to create a noncontiguous range (ie...
See more

Part and Inventory Search

Back
Top