Results 1 to 3 of 3
  1. #1
    runabout6 is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    2

    Novice question about using established forms


    Greetings,
    I am new to this forum and new to access and excel, so please excuse this question. I am very definitely a novice.
    I am trying to use an old Excel form that I have in the computer currently. I need to transfer this form to Access. I want to be able to collect data on that form and revisit the collected data some time in the future.
    The Excel form has the company logo on it and the layout is perfect for what we use it for.
    I can't believe this a really difficult thing to do, I just am not familiar with this kind of computer stuff.

    Thanks

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    You will want to purchase a textbook in the version that you have. Available from Amazon or any big box book store. One can import data from excel easily. This will be covered in the textbook.

  3. #3
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    I would start by copying all the buttons, text boxes, and other things from the excel form into a new form in MSAccess. Then put in the coding for the buttons and other events. When done, then import your data.

    Or you can import the data from excel into MSAccess and then use the nice Form Wizard to help design a new form from scratch against the imported data table.

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

Similar Threads

  1. Access Novice - Looking to learn from scratch.
    By Javaman in forum Database Design
    Replies: 1
    Last Post: 03-13-2010, 08:53 PM
  2. newbie-real NOVICE
    By SHCC in forum Database Design
    Replies: 1
    Last Post: 02-09-2010, 03:42 AM
  3. Help me i'm a novice!
    By andrew99 in forum Access
    Replies: 2
    Last Post: 12-30-2009, 10:19 AM
  4. Some advise for a complete novice...!
    By 450nick in forum Access
    Replies: 1
    Last Post: 09-11-2009, 02:23 AM
  5. Replies: 1
    Last Post: 02-27-2006, 07:46 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