Recent content by AJJJR

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

Now I am getting "Missing operator in query expression"

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

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

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

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

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

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

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

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

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

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!

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

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

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