User Profile

Collapse

Profile Sidebar

Collapse
ghowells
ghowells
Last Activity: Feb 21 '07, 03:52 PM
Joined: Oct 5 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ghowells
    replied to Add columns by clicking a button
    in Access
    Thankyou for all your help, I am finally i hope moving in the right direction.
    I have created a new table where each issue of each document is a new entry, i then found that if i create a crosstab query, using DocID as the row heading and Date as the column heading i can create the exact table i've been looking for, with the added bonus of having the current revision displayed in the second column.
    Without thinking 'out of the box'...
    See more | Go to post

      Leave a comment:

    • ghowells
      replied to Add columns by clicking a button
      in Access
      If there is an easier way, i'm all for it, simple is in my book always best.
      However, Keep It Simple is sometimes easier said than done, i agree i'm probably thinking more in terms of excel than access, but can't get past the fact that for numerous documents in a list, i need to show not only the revision that has been issued (Of which there could be many) but also the dates at which each revision has been sent.
      So there are 3 parts...
      See more | Go to post

        Leave a comment:

      • ghowells
        replied to Image Database
        in Access
        Thankyou for all your help.

        It may be a while before i can get to using it, restriction on my time at the moment. But i will let you know how it goes.
        See more | Go to post

          Leave a comment:

        • ghowells
          started a topic Add columns by clicking a button
          in Access

          Add columns by clicking a button

          I am creating a document management database using access.
          Each job will have it's own database to log the documents for the job.
          These documents will be issued over the period of the job as different revisions are created (rev A, B, C etc).
          To create the issue sheet i need to be able to create a new column (Field) and specify the name of the column (Which will be the date of issue), The row will be the document and the data...
          See more | Go to post
          • ghowells
            replied to Image Database
            in Access
            Thanks for all your help.

            I managed to get the images to show correctly on a single form, but will only show one image on a continuous form, presumably because it only sees one record at a time as being current, by using this code:

            Function setImagePath()
            Dim strImagePath As String
            On Error GoTo PictureNotAvail able
            strImagePath = Me.txtImageName
            Me.ImageFrame.P icture = strImagePath...
            See more | Go to post

              Leave a comment:

            • ghowells
              started a topic Image Database
              in Access

              Image Database

              I've been trying to create an image database using Access 2000 linked to all the images on our server, as per the instructions on the microsoft website.

              The code to link the photos is as follows:

              Private Sub Form_Current()
              On Error Resume Next
              If Not IsNull(Me![ImagePath]) Then
              Me![Imageframe].OLETypeAllowed = 1
              Me![Imageframe].SourceDoc = Me![ImagePath]...
              See more | Go to post
              No activity results to display
              Show More
              Working...