hello friends
if anyone of the access gurus here had a chance to download and use the Form demo from Microsoft website you would have notieced that the background is actually a bmp picutes of cloudes. Can anyone tell mehow they manage to put that pictures in the foms. i tried using the autoformat but the autoformat has specific formats and not the one i saw in Forms Demo from Microsoft webiste.
Please tell me how to include pictures like these in the form.
I would like to change the color of the actual access database background. I've done my forum searching and found many many threads explaining how to do this but i cant open any of the sample DB's. Access says the file is readonly and you need to be able to edit upon the first opening or something to that affect. I assume its becuse the sample is a newer or older access than im running(XP)
Sorry to rehash old threads but i cant get the info from them. Can anyone help..Grey sucks ha
I have a flash file that jerks when run in access but if i run it with a pop up it runs fine so I want to run the pop up but, keep it hidden. Without using minimize.
I am trying to put a jpg of a logo onto the top of a form and no matter what I do, it is imported with a white background! I have put it on a transparent canvas in Adobe photoshop, which usually works when I import it into word and other programs, but not access. I have tried looking at the properties of the image in access, but it says that the background is transparent. Help!
I am looking at being able to run a query but would like the results not to be displayed. Ie I would like the query to run in the background. I open the query using a command button from a form.
I have a subform that returns a bunch of records. Each of the records returned has a LANE_ID, so in this example, there are 10 records returned, 5 with LANE_ID = 11111and 5 with LANE_ID = 22222. Is it possible to alternate the backgrond color for each of these groupings?
I have found examples of how to change the color of alternate rows, but I can't find anything that would tell me if what I want to do is possible.
I have a .gif I set up as the background, but it doesn't stretch for the full length of the form. As you can see in the picture, at the bottom where the record selector/scrollbar would be, my background picture is not filling.
This should be an easy one for somebody. I'm a newbie to access and I'm experimenting with a tabbed form. My problem is if I create a new form with (say) two tabs, the area to the right of the tabs(where more tabs would be inserted) is white and I don't know how to change it to blend in with the rest of the page. Hope I'm making myself clear.:(
pls Help, I knw how to change the background of a form. but i need a particular file for the background. and i want to knw where the file is stored? the file which i want is a texture file in a WORD. i.e. in word when we try to set the background of a page, the option Background gives us some textures for the background. i want a file called "water droplets" as a back ground in access form. from where can i get the texture file? i searched the whole Microsoft Office folder in c:program files. this file is not there. then where are this texture files stored? can anybody help me to find this file pls?
Hi We have created some forms using (in some cases) the form wizard. As you may know you have to select a "Background Style" when using the wizard. Now we want to change the background from one of these styles to a colour - but when we select it in Properties and try to apply it, it seems to flicker but does not seem to have any effect. Can anybody help us out please ? many thanks ajm
I have a master form with a picture as the background with a timer event that fires every 5 minutes. I have a subform (a clock) with a timer event every second to update the text. How do I make the sub form background transparent so that I see the master form back ground?
I did it this way so I didnt have to update the master form data every second.
i have an application and the user was asking me to give him the ability to change the backcolor of the main form i had done that with one color option.
but now he wants to mix two colors together any one can help me with that , if code or sample would be posted, that would be appreciated .
I have some code here that is changing the color of a txt box in my form based on the value in the text box. Everything is working great. The only problem is that I have a sub form with many tabs and many, many txt boxes. I would have to replicate this code hundreds of times....
Does anyone know a better (LESS CODE) way to look in the form and change the color of a txtbox based on a value. Something more generic. RIght now I am targeting specific txt boxes...
I just want a general statement that targets the entire form
THANK YOU ALL FOR YOUR HELP.....THIS IS A GREAT FORUM AND LEARNING TOOL....
CODE:
Private Sub Lower_Level_Concession_Inside_COUNTERS_AfterUpdate () If Lower_Level_Concession_Inside_COUNTERS = "2" Then Me.Lower_Level_Concession_Inside_COUNTERS.ForeColo r = 255 'The New color. Me.Lower_Level_Concession_Inside_COUNTERS.FontBold = True Me.Lower_Level_Concession_Inside_COUNTERS.BackColo r = 65535
ElseIf Lower_Level_Concession_Inside_COUNTERS = "1" Then Me.Lower_Level_Concession_Inside_COUNTERS.ForeColo r = 0 'The New color. Me.Lower_Level_Concession_Inside_COUNTERS.FontBold = True Me.Lower_Level_Concession_Inside_COUNTERS.BackColo r = 255
Else Me.Lower_Level_Concession_Inside_COUNTERS.ForeColo r = 0 'The New color. Me.Lower_Level_Concession_Inside_COUNTERS.FontBold = False Me.Lower_Level_Concession_Inside_COUNTERS.BackColo r = 12632256 End If End Sub
I use forms to display client info and i would like to know if the following is possible, and if so, how ?
When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that paticular client.
eg/ if the clients installation date was 7 months ago, the form's background would change red - but only to that client.
I have been searching for a setting that enables me to change the background colour of a tab control on a form. It may be something obvious that I have missed.
Changing the type to 'transparent' and setting the form background colour does not seem to work.
How do I change the background color of a tab or can you? The form that I am looking at has a tab button, but it looks like a normal form for the background. It has the grid and has a color for the background. I have designed a new form and added a tab control. But the background is grey and I would like to change it. Please help, if you can. Thanks.
I have created a db with a picture linked to every form as a background. The mdb file and the jpeg file are on the server but if it is open and someone else tries to open it it will give an error and the bg won't be linked to the forms. If the picture is embedded the db becomes sooo large (from 700 kb to 43 mb!!!!) so that's also not the solution. Hope that someone can help.
I want to change the background color to a plain white color. So I used the coloring bucket to fill it in. The problem is that it does not have any effect. In the picture you can see that the greyish color with the white dots remain.
This is some kind of standard template. Is there anyway I can remove it so I can fill in plain colors?
I have a Data Access Page that I need some help with some of the code.
I need to do a comparison to see if the TimeStamp Control is less than one hour old. If it is, it should have the background turn red. If not it should stay white.
Form = BLine_Messaging Control = TimeStamp
Code:<SCRIPT language=vbscript event=onload or=window><!--If (BLine_Messaging.TimeStamp.value > DateAdd("H", -1, Date)) THEN BLine_Messaging.style.backgroundColor="white"else BLine_Messaging.style.backgroundColor="red"end if --></SCRIPT>
The FrontEnd is published on a Citrix server, so is the backend. It works well, but I have issues with images in report.
We have a lot of suppliers that demand that we use their standardized forms for entering customer information.
Most of these forms are quite simple and basic (logo in the corner and so on), and this does not represent an issue to just mock them in a new report.
However, one of our suppliers has multiple pictures, their own font for text, "complicated" boxes with text (for example they do not use rectangles, but cut of corner rectangles) and so on. It's a nightmare to recreate.
The FrontEnd file was about 25mb when i startet, and after creating 2 reports of 6 pages, the frontEnd size increased to over 350mb.
I have saved the pdf as an image (jpg). I need high resolution because of small tekst in the pdf that needs to be visible. I have managed to get the size down to 2mb, some 4mb. Any lower and the image is unreadable. I have also tried BMP (I've heard that bmp i preferable).
All of this is quite time consuming, and I have used hours after hours recreating these reports, without satisfactory results.
Sometimes the images are visible on the print, other times not. The same with the print preview.
So my question is... How can I "create" a report, based on a PDF?
I have installed Windows 10 & Office 13.The Background color of MS Access 13 is white in color which is irritating. Is there a way to change the background color?
Facing a small little problem -I have searched the forum but to no avail...I have designed a macro which runs a two separate OpenQueries, Save and Close statement based on a timer in an attempt to mimick the running of a silent 'SELECT QUERY' in my Access 2003 database project.Is there a cleaner way to silently run this 'SELECT QUERY' in the Background and thus without the using the Open and Close query commands, to prevent the as my screen slicing effect as a result of this.Thanks.