Results 1 to 5 of 5
  1. #1
    Skootr is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    2

    Make Table using Form Value

    Hello all,
    I am attempting to make a table using a Form to populate 2 of the 9 fields. The other 7 fields are all populated as title:"data" for what I need for the first record. Those all work fine. The other two fields I have are..
    Transaction Date:[Forms]![Start Form]![TX Date]
    Post Date:[Forms]![Start Form]![Post Date]

    The problem I am having is that when run, all the fields get populated just fine except the date fields. Those end up null.

    What am I missing?

    SQL below
    Code:
    SELECT "Header" AS Detail, "GJ" AS Line, "USD" AS Account, [Forms]![Start Form]![TX Date] AS Division, [Forms]![Start Form]![Post Date] AS Branch, "" AS Center, "" AS Debit, "" AS Credit, "" AS Adjustment INTO [export]
    I'm using this to prep a bunch of data for export as CSV, and the first line needs to have the data I'm setting in the make table query. All other data will be selected via query and appended to this one from existing tables.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,641
    Had to go to Firefox to see the SQL.
    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
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Can't see your SQL.

  4. #4
    Skootr is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    2
    Code:
    SELECT "Header" AS Detail, "GJ" AS Line, "USD" AS Account,
     [Forms]![Start Form]![TX Date] AS Division,
     [Forms]![Start Form]![Post Date] AS Branch,
     "" AS Center, "" AS Debit, "" AS Credit, "" AS Adjustment
     INTO [Coast to Coast export];
    Sorry, copy and paste out of access (from design to SQL view) didn't seem to work well with the forums.

  5. #5
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    The SQL you posted works fine for me. But you have to move from the one Text Box to the other to let it update. If you just type in the one but don't move out of it, there will be no value to use.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-15-2012, 05:05 PM
  2. How to make table from button on form
    By JackieEVSC in forum Forms
    Replies: 3
    Last Post: 11-04-2011, 06:44 PM
  3. Replies: 3
    Last Post: 01-10-2011, 10:31 AM
  4. Refreshing Make table queries within a form?
    By umass02 in forum Queries
    Replies: 2
    Last Post: 09-03-2010, 09:14 AM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 AM

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