OK Guys/Gals,
PHV - At that thread I couldn't get anywhere with the suggestions. Looking back at the thread again, there is one entry that I may have missed or misunderstood that is promissing as a possible solution to what I want to be able to do.
Now, that I have some time to get back to...
lespaul,
You have the concept correct. There is a SINGLE Letter Head image file stored somewhere on the network that is the letterhead that should be on EVERY report. When a doctor leaves and/or a new one comes in to the practice the old Letter Head image is replaced with a new Letter Head...
Lespaul,
All of the reports (12 reports so far) still have the actual Letter Head text in a text box and a logo in an image box in the report's Header section.
I have put the actual image of the medical practice's Letter Head in one report to test how it would work out and was going to do...
How to Place Letter Head Image from path in table in Report's Header section
OK, I have asked this before. But all of the posts have not helped me figure out how to do what I really need to be able to do. May be I just didn't ask my question clearly enough last time. So let try it again...
The MS site talks about BMP image format. Although TIFF or JPG should work as well.
However, I still don't see the syntax that includes both the table name and the table's field in the line of code.
Well Remou,
The above thread didn't do it. They made the assumption that the report was bound to a table. They also assume everything in the report is under the Details section. Or at least that is what I perceived they did in the first reply of the thread.
My reports are bound to a query...
Thanks Remou,
I'll look at the thread when I have a moment latter today.
I tried several searches before submitting a post. Didn't find anything. I guess I didn't word my searches correctly.
Best Regards,
I want to have a "letter head" image displayed on a report. Easy enough. Ahh, but, I would like to have the "letter head" image displayed on the report pulled in to the report through the path where the image is located stored in a field in a table.
The table...
I am constantly entering new patients into my database. Is there a way I can create a FIND form without having the find section be directly on the form that I want to look for the patient's records?"
Perhaps you might want to rethink how you set up the Access app so that the work flow process...
Its been a few weeks. Well, actually a couple of months now. But I just got back to this project again today. I have found the solution to my problem. Duh, on my part.
The reason, as I see it, I was getting the error message about a Null value being passed to a variable that wasn't a...
Bill,
"Out of curiosity, is PT_DB_Number an autonumber?"
Yes. It is the primary key (index) in the table Tbl_PT_DB_Number and is set to be an autonumber.
I created the Access app so I know it pretty well inside and out.
I'm still taking some mid-winter time off from work. But next Monday...
This Access application and its database, I have created, is a freebee project I got myself in to a couple of years ago. It is now, thankfully, nearing completion. Its now a matter of resolving a few details and adding some additional functionality, like an audit log - a necessity for medical...
I need help resolving the cause of a data entry problem on a form/subform.
The details . . .
1) This Access application is being created under Access
2000.
2) In my Access application I have a main form called
ECMR_Main.
The main form ECMR_Main allows selecting a patient from...
Thanks for the reply Jebry.
Well, I tried some other ways of laying out the patient data Edit/Add New patient. None of which satisfies what I need to do and how I want to be able to have the user do it. Plus, because of the amount of data fields that need to be filled in, it just doesn't fit...
Thanks for the reply Jebry.
Quote from jebry's reply: "You are getting the first message because anytime you move from the main form to a subform Access automatically saves the current record."
Duh...on my part. I missed that simple fact. OK, I have just "dope slapped" my self. Now on to...
I need help resolving a data entry problem.
I have a main form (ECMR_Main), where on the Patient's tab of the main form, allows selecting a patient from a list box that is associated with the table Tbl_PT_Demographics that contains patient demographic data.
On the Patient's tab of the main...
use the Office Links button to Publish it With Microsoft Word" Yep, does work . . . except.
1) Microsoft in their attempt to . . . unless one clicks on the "expand" part of any drop down menu one doesn't see all of the options. I didn't see the "Use Office Links . . ."
2) The "Use Office...
Thanks. I'll have to try that when I have a momentand provide some feed back on this post as to how well it worked out.
I appreciate the help.
Best Regards.
I need to have the contents of an Access report end up in a MS Word Doc.
I have a medical practice Access App and database. There are several patient/clinic visit reports in the app.
I need to some how, easily, have the contents of a report end up in a Word doc. The Word doc would then be...
I need to display and edit the data of records from a table that is the MANY part of a one to many relationship on a pop up form. The table that is the ONE part of the one to many relationship has its records displayed on the main form. I need on the pop up form to only see the records that are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.