Search results

  1. M

    question about command to save record

    I've been looking at 2 lines of code in 2 different modules and it looks like they both do the same thing. Can someone tell me if there is any difference between these 2 lines of code? DoCmd.RunCommand acCmdSaveRecord versus DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
  2. M

    Passing a total from one form to another

    I have "LossForm" to record loss of inventory items due to damage, theft, etc. It has "Loss Subform" for input of multiple items. The row has a calculated field "TotalLoss" (from qty * itemcost). The footer of subform has unbound text field =Sum(nz([TotalLoss])). This all works fine. The...
  3. M

    need to track inventory and information for financial reports

    Hi, I hope I am posting this in the right place. I have an inventory database with tables for Inventory Transactions, Purchases, Sales, etc. Everything is fine with that. But my boss wants to be able to pull reports at random to see cash flow. I created some tables that are not related to...
  4. M

    Question about fields, table relationships & sql

    I have 3 tables. The field in red is the problem area. tblTypes: (PK)TypeID, Type tblAccounts: (PK)AcctID, (FK)TypeID, AcctName tblJournalEntries: (PK)JournalID, Date, (?)TypeID, (FK)AcctID, Amount screenprint uploaded here if it helps--> h t t p ://imgur.com/ktRdNNE So my confusion is with...
  5. M

    hello from california

    Hi, I'm kinda new here. By "kinda" I mean that I have visited the site many times in the past to read other posts and have found it to be a good reference. I have an AS degree in Computer Info Systems. I worked with Access a lot in the past, at which time you could say I was at an intermediate...
Top Bottom