Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    Join Date
    Apr 2017
    Posts
    1,673

    Quote Originally Posted by d9pierce1 View Post
    The reaason why i made that option with a hidden txtbox field to show the lable was i couldnt figure out how to just put the label in the table for this. I want to see if a transaction is Credit / Debit, Cash, and so on when i view the
    account detail form and i didnt want the sub form to show a 1, 2, 3, 4 or 5.... I want it to show Cash, Credit/Debit, Check, Deposit, or EFT in that subform and i was unable to figure out how to put lable into a different table.
    Use combobox as field control in form. With RowSource like "1,'Cash',2,'Credit/Debit',3,'Check',4,'Deposit',5,'EFT'", BoundColumn = 1, ColumnCnt = 2, and ColumnWidths = "0,2.5".

  2. #17
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    thank you so much! I made some changes, still have a few issues but working on them. I though about the case but have never done one before and wasnt ready for
    an education, LOL..... but it worked great. I just have to re work some things and will let you know how it all works!
    Thanks again!
    Dave

  3. #18
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Or create a table of those 5 payment types and use table as source for combobox. Or use an UNBOUND textbox with expression in ControlSource to convert number value to descriptive text. Don't need to save Method to table. Saving both MethodOpt and Method description is redundant.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #19
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Saving both MethodOpt and Method description is redundant.
    I thought I mentioned that too but upon reviewing I see that I didn't.

    FWIW, I agree - don't save both. Furthermore, saving the option would not be my preferred approach. That would be to list options in a table as was mentioned, and relate the numeric PK option value as a FK value in the transactions table. I would also vote for the combo approach rather than coding for multiple buttons.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 05-10-2019, 10:40 PM
  2. Insert INTO SQL Statement
    By tecknologikal in forum Programming
    Replies: 3
    Last Post: 02-12-2019, 09:31 PM
  3. INSERT INTO statement
    By berderder in forum Programming
    Replies: 4
    Last Post: 06-03-2016, 06:00 PM
  4. Insert Into statement
    By TimMoffy in forum Programming
    Replies: 7
    Last Post: 07-13-2012, 07:10 AM
  5. Insert statement
    By crowegreg in forum Programming
    Replies: 2
    Last Post: 08-19-2011, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums