I used Stephan Lebans Access Report to PDF , and it worked great except an ole photo of a signature, which I need, goes to black when attached to email, although it is fine on the viewed PDF at my end as well as one printed, . Any one have an idea on fixing that.
Ken
akirekab
Last Activity: Nov 2 '08, 06:54 PM
Joined: Oct 12 '06
Location:
-
OLE photo of signature goes black on PDF from report
-
selection from several diff listboxes
I need to show 9 headings, with a list under each heading on my main form.
Then I need to be able to select an item in any of the lists and cause a form ot open with information about that item.
I started putting 8 list boxes under 8 headings, is that the best way for me to do this. -
Thank you so much for answering.
I think this was a Duh question, but then I am getting old...
Thanks again
Ken -
using code from ver 2002 in ver 2003
I had a complaint that one user in an office was having difficulty with the access app. When I chkd, the pc had access 2003. I had written all in access 2002.
When I went to look for references in tools, reference it seems it is not there.
Do you know where I can check to see if any missing references are shown, and do you know of known issues when someone does this.
I don't have 2003, and my connection to his... -
word document opens in background VB6
I have a word document which I open with win32api off vb 6 form, and for some users it goes to background. Any idea on how to correct that. -
NeoPa
I have looked over documenter, now should I be just checking the table, report and query I am worrying about or really check everything??
KenLeave a comment:
-
Sorry had typo in the SQL in frame above
Code:SELECT tblPatientProfile.*, tblInterviewRecord.* FROM tblPatientProfile INNER JOIN tblInterviewRecord ON tblPatientProfile.PatientProfileID = tblInterviewRecord.PatientProfileID WHERE (((tblInterviewRecord.InterviewID)=[Forms]![frmPatientProfile]![frmInterviewRecord subform]![InterviewID]));
Leave a comment:
-
Ok I ran the query,
[CODE=SQL]SELECT tblPatientProfi le.*, tblInterviewRec ord.*
FROM tblPatientProfi le INNER JOIN tblInterviewRec ord ON tblPatientProfi le.PatientProfi leID = tblInterviewRec ord.PatientProf ileID
WHERE (((tblInterview Record.Intervie wID[B])=[Forms]![frmPatientProfi le]![frmInterviewRec ord subform]![InterviewID]));[/CODE]
Got dialog asking for the
[Forms]![frmPatientProfi le]![frmInterviewRec ord...Leave a comment:
-
Actually it is titled
Enter Parameter Value
Then above the input of dialog box it says tblPatientProfi le
with no quotes
it has the normal ok button, and when I click it, without entering anything, the report prints or previews normally and correctly.
Thanks
KenLeave a comment:
-
The dialog, box, has nothing in it except the table name
'tblPatientProf ile'Leave a comment:
-
Confused by parameter error dialog
I am running a report in Access. When I click to run report, a dialog comes up for missing parameter, showing just the name of a table in the box.
Now if I just click ok without typing anything in, the report dispays perfectly.
But user wants it gone, and I am at a loss. Here is click Event code:
...Code:Dim stDocName As String Dim strFilter As String stDocName = -
Hi Stewart,
Well neither of these picks up the last day. Between is supposed to and the other I would have thought would, but some internal stuff keeps it from happening I guess.
In both cases though data from the 31st was left out.
I can't believe that something this well used doesn't have a basic function that works quickly, simply and without fail, as it so important.
I can make it work with...Leave a comment:
-
HI and thank you Stewart
Both of the expressions returned an access error
"The expressions you entered returned an invalid date value"
any thoughts on that.
KenLeave a comment:
-
getting proper dates covered for reports
I would like some advice on the best way in MS Access, in query builder to get criteria that will include certain days.
something similar to this code:
I basically need to be able to run reports from a query that will gather data for all days of the month. Of course I would like to use the Between() function,...Code:>=[Forms]![frmReportMenu]![txtStartDate] And <=[Forms]![frmReportMenu]![txtEndDate]
-
Thnks Killer
First I would like to apologize, I had to leave state, and didnt get back to this till now.
One question on your comment, is the control you reference going to work in VB5 ?
KenLeave a comment:
-
I am not sure how the filelistbox works.
But my objective is to retrieve a set of files with criteria of a number, and only that set of files. It may be one or a dozen files starting with nxxxxx, I would like the file name and date in the list box or file list box if thats possible and in descending order.Then the customer can double click and display the file.
I do not want all the files currently active showing.
...Leave a comment:
-
Retrieve date with file for listbox and sort
I am using the following to retrieve a file and put in listbox. It is working fine.
I would like to build on it to include the datecreated of the file and be able to also sort with that date.
[CODE=vb]
Const iPath = "C:\patient\sca ns\Insurance\"
Dim myInsFile As String
Dim strPatientId As String
myInsFile = Dir(iPath & strPatientID & "*.*")... -
ADzeii,
Thank you very much. I appreciate you taking the time .
KenLeave a comment:
-
Open a file with file name from listbox
click on name, and open with windows explorer.
I tried using shell
(Code)
Shell "explorer.e xe " & sPath & lstYellow.Value , vbNormalFocus
(/code)
sPath is a variable set earlier and is ok, but I need to get the file name out of lstYellow, and value is not a good property. I have tried selected, listindes and others, but I think I just need some help in formatting, as the code is... -
Thank you very much for the insight. As I am still working on this I will try to understand and use what you have here. Thanks for taking the time. Ken...Leave a comment:
No activity results to display
Leave a comment: