Results 1 to 5 of 5
  1. #1
    ac13 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    3

    Access 2007 & Infopath 2007

    Hi All,



    I am trying to create a form on Infopath 2007 based on a table in access 2007. I want my users to be able to fill in this form and submit it back to me in such a way that it will directly populate the table in the database. I know I can do this. However, I am unable to modify the infopath that access 2007 creates from the table. I want to change the date format. By default it takes up the date as "date and time" and I want it to be the date only.

    Please help!!!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    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
    ac13 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    3
    Quote Originally Posted by June7 View Post
    Thanks June7

    Unfortunately it does not help. I know that you can change the format if you create the form in Infopath. But the infopath form is automatically created via access 2007 (I am using the collect and update feature of access 2007) and this is where I would like to modify a date field to date only. By default it takes date and time...Does this make any sense?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I have only done some limited testing with the Collect Data feature and it's been a while. Don't remember testing InfoPath. I don't even have it installed now. Sorry, guess can't help.
    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.

  5. #5
    ac13 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    3
    Quote Originally Posted by June7 View Post
    I have only done some limited testing with the Collect Data feature and it's been a while. Don't remember testing InfoPath. I don't even have it installed now. Sorry, guess can't help.
    Thanks June7. Can anyone else help please?

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

Similar Threads

  1. Export Table in Access 2007 to Multiple Workbooks in Excel 2007
    By hutchinsm in forum Import/Export Data
    Replies: 5
    Last Post: 03-01-2012, 05:23 PM
  2. Ms Access 2007 report export to excel 2007
    By Stan2man in forum Access
    Replies: 6
    Last Post: 11-23-2011, 01:24 PM
  3. Linking Access 2007 to Outlook Calender 2007
    By izzygrace3 in forum Programming
    Replies: 1
    Last Post: 11-10-2011, 11:53 PM
  4. Replies: 2
    Last Post: 06-18-2011, 09:55 AM
  5. Replies: 0
    Last Post: 11-17-2009, 02:35 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