User Profile

Collapse

Profile Sidebar

Collapse
smorrison64
smorrison64
Last Activity: Sep 19 '08, 01:44 PM
Joined: Dec 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • smorrison64
    replied to Calculating 2 fields in subform
    Can you send me a copy of the database? << e-mail removed >>...
    See more | Go to post
    Last edited by NeoPa; Feb 21 '08, 02:46 PM. Reason: e-mail removed as per site rules

    Leave a comment:


  • smorrison64
    replied to Reference Library
    The other users are getting missing link errors for the libary when they open it because the libraries are referencing the C drive. Just becuase I have something on my C drive doesn't necessarily mean they have it on their machine. That is why I tried to move the library to the X drive which is mapped the same on everyone's machine since it handled by the network logon script. The problem is that I can't get the reference in the reference list...
    See more | Go to post

    Leave a comment:


  • smorrison64
    replied to Calculating 2 fields in subform
    On the help page below, it appears that the syntax in your code may be incorrect for the Nz function. You shouldn't have a null value for an extended price. If the item has no cost, I would use 0.00 in that field and just use =sum([ExtPrice]).

    http://msdn2.microsoft.com/en-us/library/aa172237.aspx...
    See more | Go to post

    Leave a comment:


  • smorrison64
    started a topic Reference Library

    Reference Library

    I have a database that references a particular type library from my C drive (PhotoShare from Yahoo Messenger). The database is actually housed on a network drive so the library reference is missing when other users try to use the database. I thought I could just copy the library to the network drive and change the path on the reference but I can't seem to get it to work.

    How do I solve the issue?
    See more | Go to post

  • I am not binding it because as I understand it bound can only support .bmp files and I'm using multiple formats.

    The file name is being stored in the Steps table which is part of the query on which the report is based. I just want to display in an image control the picture associated with the step, if there is one, for that particular step in a process.

    I've tried using pieces of the code from above and adapting it...
    See more | Go to post

    Leave a comment:


  • I don't know if this will help but I was having the same problem and I used code from the sample Northwind database.

    [code=vb]Option Compare Database
    Option Explicit
    Dim path As String

    Private Sub AddPicture_Clic k()
    ' Use the Office File Open dialog to get a file name to use
    ' as an employee picture.
    getFileName
    End Sub

    Private Sub Form_RecordExit (Cancel...
    See more | Go to post
    Last edited by Denburt; Dec 5 '07, 04:14 PM. Reason: Code Tags

    Leave a comment:


  • Display Pictures in Access Report through VBA code

    I have a form that is coded to open a File Dialog boc to pick a picture to display on that particular item on a subform. My form is not based on query, but rather two separate tables (one primary, one sub). That code is working properly. How do I get that to translate to my report? I use VBA code because I use formats other than BMP for the pictures. Would basing the form on the qury that the report is based on solve the issue without further...
    See more | Go to post
    Last edited by Denburt; Dec 5 '07, 04:04 PM. Reason: Code Tags
No activity results to display
Show More
Working...