I would like to have a picture appear in the detail section of my access report if a certain condition is true.
For example, if [Membership] = "Gold" I would like to have a small bitmap logo displayed (clip art of a gold star).
So, in effect I want an unbound image to be visible or not visible based on some other field in the report.
i have a table calle "tstaff" and one of the fields in it is named "picture" which hold a link to the picture of the staff membe, the picture is stored on my pc, not in the database.
so in the picture field would be something like this...
Picture
c:documents and settingsall usersdocumentsmy picturessample pictureslue hills.jpg
what i am trying to do now is to create a report that displays all the patients data, including the actual picture that the link refers to...
how should i do this please
cheers
Andy
I have a database "report" that is actually a letter head statement that will be sent to different hospitals based on the donor and different procedures completed.There will be a total of 6 people using the database.What I want to do is have a "hidden" picture of their signature and based on who the choose in the drop down (sending the letter) it will show their signature.
What I can get it to do:Show the signature when I place the code in the "on current" event...but only after they actually click on the report.
Get it to save the report to a folder, open an email object and attached that report.The problem: Show the signature "right off the bat"..Saving the signature to the "Saved" file.how to show this signature? Below is the code I have it the report:
Code:
Private Sub Report_Current()
If Me.Text31 = "User1" Then
Me.User1.Visible = True
ElseIf Me.Text31 = "User2" Then
Me.User2.Visible = True
End If
End Sub
I've got a report/invoice that i want to print out with a simple header picture for the company. For reasons i cannot fathom the picture will not print. Print preview, Report view, print as PDF, XPS and even copy to a word doc all display the picture, but when i send it to any printer the header does not show.I have checked every setting i can find.
Visible = Yes
Display when = Always
deleted, save and closed, re-inputted, still nothing.
compact and repair after delete re-input after compact, still nothing.
Added the file to local directory, still not showing
I can even add a border around the picture which it will print but not the image itself.I've tried .png .jpg and .jpeg file types (Same image its just a logo).
Hi I created an access with a picture I copied from the internet. When I run the report in Access, I can see the picture but when I export the report to a text file, the picture is lost. Is there anyway I can have the picture everytime I export the report to word format ?
View 3 Replies View RelatedI have a report called "orders" and on this is records for orders of the day inputted.
On this report I have a control called "urgent" and a picture called "UrgentPicture" with the picture set to visible.false?
If any of the controls for Urgent is True then this will show my image, but this is not happening?
I am using this in the current event on the report
If Me.Urgent = True Then
Me.UrgentPicture.Visible = True
Else
Me.UrgentPicture.Visible = False
End If
I have set a conditional format for a report...very basic, Now()+7 and set it to format to turn red, but it will not turn red unless I click on it.
View 3 Replies View RelatedI am using Access 2010 and have set up a contact database using the contact template. On each Contact I have put a picture of the person but if I attach an attachment to the contact sheet it then changes the picture to paper clip for the attachment and I wonder if there was a way of stopping this?
View 1 Replies View RelatedI am struggling to format a field on a report.
I believe it is because special charachters are in the text string
I want to highlight the field if it contains the following text
Stage 6: Won and Deploy (shipping)
Regretably, I believe Access see this as code.
I suspect I need to encapsulate it some way, but nothing seems to be working
What am I missing?? How can I force Access to see it as a text string??
In my Access 2010 report, I am attempting to perform conditional formatting of one field based on the difference between two fields. In particular, one field is "Time Scheduled" and the other field is "Time In". If the "Time In" is equal to or greater than 60 minutes of "Time Scheduled", I would like to format it to be red font. If it is less, I would like to format it to be green font.how I can conditionally format to do this?
View 12 Replies View RelatedI am trying to add conditional formatting to a several fields in a report. So far i can use the contional formatting to set a field called [colour] to set that field to red and bold. But i believe I need to use an Expression for all fields, so I can make all fields that = red go red. I have used the the expression:
[colour] = "red"
but nothing happens.
Expression Is [Subtotal]+[Freight] > 50
I have a text box on a report from the Control Source CSCS Expiry Date. The format in the table and query and report is Short Date. The Text Format is Plain Text.
I have named the text box txtCSCSExpiryDate. I would like to make the background red when the date is 01/04/2013. I have ensured the text box back style is normal.
I am using expression
[txtCSCSExpiryDate]=#01/04/2013#
And in case it was the Control Source:
[CSCS Expiry Date]=#01/04/2013#
I also tried:
[CSCS Expiry Date]<Date()
[txtCSCSExpiryDate]<Date()
I applied the formatting each time, tried closing and re-opening the database. Changed the background format colour to green instead of red and even restarted my computer and it just stays exactly the same.
I've just noticed something else. I have a screen only button on my report header with
DoCmd.OpenReport "All_CSCSExpiry_Rpt" acViewPreview
Which has also stopped working. I get an error:
The expression On Click you entered as the event property setting produced the following error: A problem occurred while Employee Details was communicating with the OLE server or ActiveX Control.
Is this linked to my formatting not working?
I've just checked and on my 5 reports all of the print buttons are giving me this error! (I added the button as they are part of a navigation form menu which only shows report view, I am editing in the original report design view though.) They were working yesterday! Is it because I compacted and repaired the database?
I am playing with a report. Crosstab report works, but I would like to print check mark if value is "X". Other values are "A" and "E" and they need to remain as they are.
View 4 Replies View RelatedI have a access program and recently I began getting this Error out of the blue . I really need to fix this error because it shuts down my entire program . When I go to save a pic like i always do and it will not recognize the "quote Main ".
Code:
Forms![frm_Quote_Main]![HousePicture] = Me.PicSave
Forms![frm_Quote_Main]![ZoomValue] = Me.ZoomValue
Forms![frm_Quote_Main]![GoogleZoom] = Me.GoogleZoom
Error I receive
Runtime access error 2450 ............. ? Capture2.PNG
Capture.PNG
I saw a demo that the user could copy and paste a JPG format file physically to ACCESS, and then something happened, and ACCESS could read the JPG length and width size (e.g. 1.3 meter length and 1.15 meter width) into 2 individual ACCESS cells which is acted the same as user input to that 2 clells.
View 14 Replies View RelatedI am having trouble applying conditional formats to my access db they work in excel but cannot seem to put them in to access I have one table that my forms and queries look at
These are the conditions i had used in excel
formula is =AND($H18>=TODAY(),$H18<TODAY()+14)
this turns red if within two weeks of today
formula is =AND($H18>TODAY()+15,$H18<TODAY()+43)
this turns amber if between two and six weeks of today
less than =<TODAY()
text is struckthrough and turned red
Any help with implementing these in access either similar or new method
I am making a planner in the access 2010 report. I am showing which activity finished when but I also want to highlight/ shade the cell to the corresponding month on the planner to the right. See picture above. I tried conditional formatting with date rage 1/1/2014 and 31/1/2014 but it does not gives me accurate result.
View 3 Replies View RelatedI have a table in access and I need to format it so that when column "Status" = "Closed" column "Closed" = "yes". so it will automatically mark column "Closed" "yes" if "status" says "closed". Instead of having to change both columns all the time.I know how to do that in MS Excel, but is it possible in MS Access 2013?
View 3 Replies View RelatedHi all-
I work for a staffing firm and I'm trying to figure out a way to turn exports from our vendor-based sql gui (i.e. I can only get .xls files out of it, can't just run SQL queries) into spiffy reports using Crystal Reports. My grand plan is to use Access to process these various XLS files (one for each client) by linking them to an Access DB and coding a table to conditionally tally individual records based on different criteria.
The criteria are company name, position name, date submitted, active, and status. I was able to code an Excel template that did the trick perfectly, but required each file to be edited to reflect the new report format, and updated as more positions are added. My question is this: is there some way for me to create a DB that links to the XLS files for each client and puts each company name, position name, date submitted (pulled straight from XLS files) and then the following tallies:
submitted (just # of pos name by date)
accepted (status != "s" AND active = "y" by date)
etc.
I don't really expect someone to do all my coding for me, maybe just point me in the right direction, as the only coding outside of excel formula coding (which I feel doesn't really count despite my proficiency) that I've done has been over a decade ago. Any suggestions?
I have a continuous subform with a fairly complex snapshot query as its record source. I have controls on the main form to allow criteria parameters for the query and a command button to requery the subform based on the selected criteria. I also have conditional formatting on a number of the continuous controls in the subform (the conditions are fairly straightforward, i.e. highlight if null, true/false etc)
When the subform is (re)queried, it seems to repaint several times (3 or 4 although it appears arbitrary to me) before it eventually settles. And it really louses up the aesthetics as controls flicker between colours; sometimes I even lose the background colour on parts of the detail section, or controls disappear altogether. And this continues as I scroll down the subform (or even click anywhere on it)
I don't mind that the query itself takes some time to run - of the order of a few seconds each time - but I'd prefer for the screen to wait until the query is completed, and all of the CF applied, before refreshing itself, instead of 'sweeping' top to bottom repeatedly. It's a snapshot query so once it's run, there should be no changes to the dataset.
I've tried Application.Echo but it has no effect whatsoever.
I can generate an email by clicking on a button on a MS Access Report. In the body of the resulting Outlook email you have formatted text. I have also included an array of values which are displayed in this email but I need to highlight certain items in the array in red based on whether or not another column for that record is checked. Here is an image of the email. Notice that I have circled "ZWO" and that it is red. I need for this to happen programmically.
View 7 Replies View RelatedDoes the MS Access Report support Hide/Show specific fields according to parameters or even by click?
View 3 Replies View RelatedI'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "
how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error
Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work
I'm just wondering, is it possible to put a graphics in the code? the reason I want to know is that I will put a sad face on each customer every time they call. so if they will call me 5 times i will see a 5 sad smiley face on the customer information. Can you please help me with this one. or if you know any way to do just let me know. thank you so much.
View 6 Replies View RelatedHere is my situation. I have a database with a table in which contains all of the names and members of our club. Every member in our club has a rank, the rank is held in a field called "rank". I also have a form which is used to add and edit the information into this table. The form that i have create is a bog standard form with nothing special on it. What i would like to be able to do is when the form loads and the information from the table populates it, i would like a picture box to hold a picture that represents there position like an avatar. I have tried doing this myself however my attempts just resulted in errors about not have the form focus. I use the code editor to do this. I know this is possible to do as i have seen it on some other projects.
If any one has any idea or hints about how i can do this please reply.
As an added thing i would prefer if it was done in the code editor as the machine it has to run on has macros disabled.
Hi guys.
I have been told to make my database look 'sexier' but I am a bit worried that the pictures may slow it down or increase it's size unneccesarily.
Speed is an issue because we have some offices that dial in and access it that way and as such are limited to their connection speed.
So what I want to do is created a few images, link to them, and put in code that can 'turn them on'.
The question is how?
I have created a new image object. Changed it's properties to linked.
Now I need some code that reads:
If myvalue = "Yes" then
myImage.visible = true
Else
'code to delete image
End If
I am a bit worried because that means that the images will always be there on load up, so loading the form will be just as slow because the images are there.
Or maybe I can do
If myvalue = "Yes" then
'code to create image
End If
Please help.
Edit - Part two to this question is: How do I use relative links for images? I have a folder of images and I want them to work no matter where the database sits.
Edit again - Just another question: Is it possible to have Images appear and disappear depending where the mouse is?