User Profile

Collapse

Profile Sidebar

Collapse
berndh
berndh
Last Activity: Jun 14 '07, 03:57 PM
Joined: Aug 5 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • berndh
    replied to Timeline display
    in Access
    Hi again,

    Problem....

    As far as I understand, Gantt charts do no allow for "multiple item" listings per line...

    Ie, we have Paul and it shows him to have two appointments (or three or four etc), underneath him would be Mary, with a few appointments etc etc, now there needs to be one line per person / resource which shows they availebility. A gantt chart will add a new line for every new event.....
    See more | Go to post

      Leave a comment:

    • berndh
      replied to Timeline display
      in Access
      Stunning, thanks for the input. Will fiddle.
      See more | Go to post

        Leave a comment:

      • berndh
        replied to Timeline display
        in Access
        It looks very similar to MS Project indeed, but was designed in another package using the web as front-end and SQL as a backend, I was just given a sample to see if it can be done in ACCESS to save on costs.

        I was thinking along the lines of 365 boxes in a table, start gets an image and everyting between another, the ending then gets another image to make it look nice???

        STUCK...
        See more | Go to post

          Leave a comment:

        • berndh
          started a topic Timeline display
          in Access

          Timeline display

          Hi all,

          I'm working on a litle project and have run into a snag.

          I would like to read the starting/ending dates of specific users and display then in a timeline.

          This is just to show when a user is booked and for which days ie



          Can anybody assist in how to create something like this in Access?

          Regards...
          See more | Go to post
          • berndh
            replied to Update SQL from Excel - newbie question and a challange
            in SQL Server
            Thank you,

            Very interesting read. I shall get into this and see if I can make it work for me.

            Regards
            See more | Go to post

              Leave a comment:

            • berndh
              replied to Update SQL from Excel - newbie question and a challange
              in SQL Server
              Hi,

              Now please excuse me for sounding dumb, I've been dumped in the deep end here and am treading water, no SQL experiance, rading book after book....

              You mean to import into a temp table (got this working) and then update, sounds fine, but how on earth do I update, that is my big problem. How do I get this thing to match the ISBN numbers and then accordingly extract the price....

              STUCK.

              ...
              See more | Go to post

                Leave a comment:

              • berndh
                started a topic Update SQL from Excel - newbie question and a challange
                in SQL Server

                Update SQL from Excel - newbie question and a challange

                Hi,

                I have a need to update all price fields in an SQL database. The new prices are in an excel spreadsheet (c:\db\update.x ls).

                Unfortunately the structure of the Excel file is not the same as the SQL DB, as it is formatted for printing hardcopies and hence contains merged cells (purple) and formatting etc....(see excel.jpg) Also it uses different sheets as categories.

                The only real similarity that can...
                See more | Go to post
                No activity results to display
                Show More
                Working...