Search results

  1. H

    Solved Should (some) non-keys in tables be set to "indexed?"

    Otherwise, I believe I got my answer: there is no significant advantage in marking it indexed. TY all.
  2. H

    Solved Should (some) non-keys in tables be set to "indexed?"

    Thank you @CJ_London . But I did not have such "indexes" button. So I looked in the ribbon commands, and added it under db "tools" tab, "custom" group. But still, I selected a table in a previous database that I know has multiple indexes and the button remains greyed out and non-selectable...
  3. H

    Solved Should (some) non-keys in tables be set to "indexed?"

    Recently I have heard from a forum member that one should not mark a table field as "indexed" before adding a query that selects records based on said FK field, claiming that Access will (sometimes?) create a duplicate index (if you create the relationship before marking the FK as indexed or...
  4. H

    Solved Help setting up a new Investment Portfolio database using normalization

    So now that I already have, should I turn off indexing, in (table) relationships, for the FK's? I made the FK's indexed first, before adding the relationship(s). Except maybe CashAcctID, I'm just not sure about that one.
  5. H

    Solved Help setting up a new Investment Portfolio database using normalization

    HalloweenWeed said: "One thing though, I hate Access comboboxes. I tend to get elaborate with the vba to avoid their use." Just another reason I hate them: I was getting the wrong AcctID value from my AcctID combobox in frmXactnEntryMstr. It was throwing a 'entry needed in tblAcctDirectory'...
  6. H

    Solved Help setting up a new Investment Portfolio database using normalization

    So, just to confirm I understand this correctly: I can leave indexing ON for these FK's? That won't cause a fail to make (add) a record if the value is Null? EDIT for clarity: I mean "indexed (duplicates OK)" and field not "required."
  7. H

    Solved Help setting up a new Investment Portfolio database using normalization

    OK, it seems my understanding of relationships was not flawed, and I didn't know about the corresponding SQL type associated, but I did perceive the similarity previously. Thank you @mike60smart , that's very helpful. (y) THIS: This is what I needed to know! TY very much @Pat Hartman ...
  8. H

    Solved Help setting up a new Investment Portfolio database using normalization

    Yes, I read all comments carefully, and give them thought. I tried reversing the relationship, tried only incl. rows where both fields equal, and still it refused to make a new record. So I had to remove enforce referential integrity, it was the only option that worked for me. Sorry, but I have...
  9. H

    Module Error Handling Question

    Hello, just noticed this. I have code for a function in a general module, to be used in vba, SQL (Access), or code on controls: Public Function WorkDayNext(SearchDate As Date, NumDays As Integer) As Date '.................................................................... ' Name: WorkDayNext '...
  10. H

    Solved Help setting up a new Investment Portfolio database using normalization

    I had to remove "enforce referential integrity" on 3 of my relationships to get the transaction entry form working (frmXactnEntryMstr): Is this bad? I read somewhere something that made me think it was strongly inferring that all relationships should have "enforce referential integrity."...
  11. H

    Solved Help setting up a new Investment Portfolio database using normalization

    OK, thank you. I'm currently working the bugs out of the transaction form.
  12. H

    Solved Help setting up a new Investment Portfolio database using normalization

    OK, it works (before entry) now. IDK if it works on entry yet, not tested, not the point. But I needed to remove the linking between the master and child forms, then put in this bit of code: Option Compare Database Option Explicit Private Sub Form_AfterInsert() If txtCashAcctID < 1 Then...
  13. H

    Solved Help setting up a new Investment Portfolio database using normalization

    The top form is the Broker header subform. It works off the default broker (Broker table), depending on the setting of the default Broker in the database default settings table. The other subform is the cash account, which is also set by the Broker table, according to the default broker. I yet...
  14. H

    Solved Help setting up a new Investment Portfolio database using normalization

    In other forms, when adding a record, when I put in one value in any field, and close the form, it saves. I don't know how to stop that save. In the past, I have made the form work entirely in vba recordset to mitigate this. I am looking for the ability to abort the use of the form altogether...
  15. H

    Solved Help setting up a new Investment Portfolio database using normalization

    Thank you for your time @Pat Hartman , that means no I can't use the before update event for my purpose. Perhaps I should rephrase. I have the following form: and it is a "single form" with record selectors, you can either edit or add transactions. However, there are rules about what is...
  16. H

    Solved Help setting up a new Investment Portfolio database using normalization

    Pardon me if I'm asking a question that is too basic or popular, but I am having trouble Googling it as there are too many non-relevant hits: Does the Form 'before update' event fire before a record is added, e.g. can you use that event for some VBA validation of combinations of field settings...
  17. H

    Solved Help setting up a new Investment Portfolio database using normalization

    I'm trying to decide whether to include my "cash transactions" (deposits/withdrawals) in my (securities/main) transaction form. Cash transactions are the only transactions that don't both add an amount in one account, and subtract from another. It might be tricky to adjust the (securities/main)...
  18. H

    Solved Help setting up a new Investment Portfolio database using normalization

    Hello guys, I've done some forms and accounts, working on building up to my first entry, haven't finished my transaction form yet, and considering using a separate form for my cash deposits/withdrawals. I've added a 'Cash account' field to my transactions table, due to the need, and when I went...
  19. H

    Solved Help setting up a new Investment Portfolio database using normalization

    Thank you for that @LarryE :) That's a bit more complicated than I want to get. I keep my retirement portfolio separate. This is just for my stock market forays. I may at some time put some money from this coffer into a mutual fund, and that's why I need it in the account types. But as far as I...
Top Bottom