+ Reply to Thread
Results 1 to 4 of 4

Transfer from text box to field

  1. #1
    Forum Contributor
    Join Date
    08-06-2007
    Posts
    105

    Transfer from text box to field

    I'm very new to access - so please bare with me here (I'm more of an excel guy)

    I have a database with a form. When you click the button on the form, it opens an input box which asks you to "enter the date in YYYYMMDD format"

    Once you enter 07012009 it looks up a text file in a specific folder with that same end trail, then imports it with specific delimited specs I have pre-set.

    It then imports all the records into it new individual table (using the end date trail) but also dumps it into a master table as well.


    Okay - so knowing this - heres my quesiton:

    How do can I get the input box "YYYYMMDD" into the column called "Date imported" within the master table and formated as "MM/DD/YYYY". Also, how can I get it to automatically put the text "IMPORT FILE" in the column called "Media" for each record?

    It's VERY important that it only does this for the imported records. Is this possible?

    Here is the code I have so far:

    Please Login or Register  to view this content.
    Also - everything I have works so far, I just need to add the features I said above.


    Thanks!!

  2. #2
    Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    270

    Re: Transfer from text box to field

    I ask this question to most people, what version of Access? Lots of things change in access from version to version.
    "I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
    If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!

  3. #3
    Forum Contributor
    Join Date
    08-06-2007
    Posts
    105

    Re: Transfer from text box to field

    Thanks for the quick reponse! I have Access 2003

  4. #4
    Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    270

    Re: Transfer from text box to field

    I would use an Update Query to add the data you want to each column that you want to update. Then call the Update Query from the code.

    Hope this helps,

    Dan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1