Results 1 to 4 of 4
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    After Update Add Check Number and Date To TextBox

    I have a information textbox on my form that I would like to add the check number and date to after the user enters the criteria.

    Field to update is EventDescrip and I want to add the value of ChkNo which is a check number and the date, just 01/09/2013 as the format. (Current Date) to be clear.


    I would like to add this to the far left if possible.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Is this saving ChkNo and Date to more than one field in same table?

    After user enters what criteria?

    What do you mean by 'far left'? Set textbox TextAlign property.
    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.

  3. #3
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    This textbox is for user info ONLY, it does not appear on any form or report. Check Number is assigned automatically by code. YES, that data is already captured via the form and in the table. After user enters clicks on Enter to complete the event, then the check number is assigned.The form is getting kinda cluttered and hence the need to make use of all real estate.Because it is so complex, I have had to use other fields as criteria for the requirements. Since it is a textbox, the need to align the newly added text to the left of existing text is preferred.If I go back and set textbox property ok, but I need to display certain things on the form for the user. Had not thought of using the default value and adding it that way, maybe that would work?
    Me.TransType.DefaultValue = ([ChkNo]) And Date And " " Will this work as vba code ? And still allow for user input?

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Thanks, I found a workaround!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Check if record exists, Check Number
    By burrina in forum Forms
    Replies: 9
    Last Post: 01-06-2013, 03:49 PM
  2. Replies: 4
    Last Post: 07-07-2011, 06:34 PM
  3. Check dosent update current date
    By bsunuwar in forum Access
    Replies: 10
    Last Post: 03-23-2011, 09:46 PM
  4. Getting #Number ! on addition of 5 textbox
    By Grooz13 in forum Forms
    Replies: 0
    Last Post: 08-18-2010, 07:49 AM
  5. Replies: 1
    Last Post: 06-01-2009, 04:05 PM

Tags for this Thread

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