Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    task in Excel (2000)

    Hello,

    I am enquiring if there is a good way of putting the attached screen into an excel spreadsheet as l think this
    would be a lot easier.
    I am finding using Access to do this task a bit cumbersome.
    It is difficult to make the screen shot shorter as otherwise it would be awkward to show you the example.
    As l know you mentioned you prefer the screenshot to be smaller.

    Justin.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: task in Excel (2000)

    You can create a custom form in Excel which is similar to how you would do it in Access, though access has more control. Here is a little tutorial.

    You could also make a worksheet that looks like that but you would have to build all the excel functionality with macros or formuls depending on what you needed.

    My impression is that Access gives you much more control and has builtin routines to handle and validate data.

    You can also use excels "builtin" data-form but it won't look like like your example. John Walkenbach has a <img src=/S/free.gif border=0 alt=free width=30 height=15> Enhanced dataform that has added functionality though has limited customizability unless you buy the password from him.

    Steve

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: task in Excel (2000)

    The simple answer is Yes, you could build something similar in Excel. However, from a quick look at the form without the data behind it, it looks like it would be much simpler in Access.
    Legare Coleman

Posting Permissions

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