Search results

  1. A

    Solved Trouble with SQL in VBA when I try and change the Rowsource property of a combo box

    Bingo! I had never heard you needed a space there. Thanks so much for the help.
  2. A

    Solved Trouble with SQL in VBA when I try and change the Rowsource property of a combo box

    Now I am getting "Missing operator in query expression"
  3. A

    Solved Trouble with SQL in VBA when I try and change the Rowsource property of a combo box

    Hi ArnelGP Thanks for your help. You've assisted me on a few occasions. I'm not sure what you mean by blank lines. I think this may be due to the fact that I put code containers around SQL This is what it looks like without them cboTicker.RowSource = "SELECT tblEquity.EquityID...
  4. A

    Solved Trouble with SQL in VBA when I try and change the Rowsource property of a combo box

    Hi I would like to change the RowSource of a Combo box based on another combobox. I'm having some problems, so I tried to change the SQL in the RecordSource property of the ComboBox to what I actually want to reset it to. This SQL runs fine. SELECT tblEquity.EquityID, tblEquity.Ticker...
  5. A

    Which Joined Table to Put Foreign Key

    Your first reason for a 1-1 relationship is the reason I asked this question in the first place. I have a situation exactly like that, where there are not only many options, but many types of options. Thanks for the examples
  6. A

    Which Joined Table to Put Foreign Key

    First off I just want to make clear that I am not saying anything about my example needing a join table or not not needing one. I'm using a simple example to try and demonstrate my question. I guess what I'm trying to say is --In the event that a one-one relationship exists are there any...
  7. A

    Which Joined Table to Put Foreign Key

    Hi and thanks for the comments. My brain was busy digging down a rabbit hole when I was thinking about this and I missed the obvious fact that the type of relationship determines which table contains the Foreign key. However, what about the case of a one-to-one relationship? e.g.: You are...
  8. A

    Which Joined Table to Put Foreign Key

    Hi I'm operating on a pretty basic level with access and have just started using ID fields as foreign keys to join tables. Given the following example: tblInventory has two columns InvName and InvID tblSupplier has two columns SupName and SupID I could join these in two ways: 1) Add a...
  9. A

    Arranging tables in the Access Query Builder

    O.K. It's a no go then. Thanks for the help.
  10. A

    Arranging tables in the Access Query Builder

    Thanks for the answer. It didn't solve the problem but got me one step further. I don't often use the Query Builder to build and save a query as a query. When I do that the tables stay in the same position. Normally I use the Query Builder to define the Record Source of a form or the...
  11. A

    Arranging tables in the Access Query Builder

    Hi. Bit of an odd question but. When I look at a query in the Query Builder and arrange the placement of the tables, included in the query, so as to make it easier to read: Access discards that arrangement the next time I open that query. I'm sure in the past that they stayed the way they...
  12. A

    Solved No Data In Form

    O.K. That absolutely worked!! But why? I'm pretty sure I have continuous forms that allow data entry and work. In any case thank you, thank you, thank you!
  13. A

    Solved No Data In Form

    P.S. The table with the bank info is tblInvBank. The name of the form I am having trouble with is frmInvBanks
  14. A

    Solved No Data In Form

    Here is a copy with a lot of extraneous tables and forms not included. I have a menu system that I use that allows me to add a submenu, or a form, to a menu. So I have included the table and form for that operation as well. To navigate, you use the two graphics to the left and right of the...
  15. A

    Solved No Data In Form

    I'm super stumped on this one! I have a few templates that I use and one is for a continuous form. I've used it many times and it works fine. I am trying to use it to build a very simple summary form. I have a table tblInvBank which I have cut down to the bare bones and it only has two...
  16. A

    Rowsource of Unbound Query for a ComboBox

    So, I finally did touch base with Ken Sheridan, who offered his version of how to do a "drill down" on his onedrive page. Indeed it was an error. His reply was: Mea culpa! The SortColumn value in the second part of the UNION operation should of course be zero, to force the 'All Counties'...
  17. A

    Rowsource of Unbound Query for a ComboBox

    Hello and thanks to all of you for helping out with my question. I really do appreciate it. Here's a summary, as best I can do it, of what I think the situation is. First of all, this code was posted by Ken Sheridan. Here is the location, the file in question is called ComboDemo, and the...
  18. A

    Rowsource of Unbound Query for a ComboBox

    Thanks again CJ. This has been a huge learning experience for me and at this point my brain is a little burnt out. I'll have a closer look at what you posted in a few days. I have posted a summary in a separate response.
  19. A

    Rowsource of Unbound Query for a ComboBox

    Thanks again arnelgp. You're right (I think the original SQL is wrong). I have a summary posted in a separate reply.
  20. A

    Rowsource of Unbound Query for a ComboBox

    Hi and thanks for taking the time to help out. I summed up everybody's comments in a separate reply.
Top Bottom