User Profile
Collapse
-
Can you send me a copy of the database? << e-mail removed >>... -
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...Leave a comment:
-
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...Leave a comment:
-
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? -
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...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...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...
No activity results to display
Show More
Leave a comment: