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!
View RepliesHow can I remove the white space that follows the last record in my datasheet forms? Please refer to attached image. This happens in two different forms, scrolling in two different directions.
View 8 Replies View RelatedHello,
Is there a way to configure Access so SQL View saves white space changes to a query? By white space changes I mean tabs, spaces and carriage returns added to make the query more readable in SQL view.
For instance:
When I'm editing a complex query in Access, I space it out nicely like:
SELECT ((field1 * field2) + (field2 * field3)) / field4 AS [Weighted Avg]
FROM table1, table2, table3
WHERE table1.field = 'xxx'
or something similar, with spaces between fields, parenthesis, and carriage returns or tabs in between major blocks of logic to increase readability. It's simplified above but I hope you get the point.
When I save it and return to SQL View later, Access compacts the query to:
SELECT((field1*field2)+(field2*field3))/field4 AS [Weighted Avg]
FROM table1,table2,table3
WHERE table1.field='xxx'
The above example isn't so bad, but with multipe selects, joins and mathematical calculations using parenthesis, it becomes really unreadable after Access "compacts" it.
Any way to change this lovely "feature" ?
Thanks,
-Scott
Our client has about 10 end users on Terminal Serve, and they occasionally get white screen error. The event log show following error message
"The program MSAccess.exe version 14.0.7104.5000 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Problem Reports and Solutions control panel. Process ID: 51cc Start Time: 01cfb681b4d13efe Termination Time: 0" Event ID 1002.
Server has MS Access 2010 (SP2) runtime installed. The error happens randomly, and happen on a particular form. When user has updated form details, click EXIT button, the white screen occur.
how to remove the white space between fields. See attached image for an example
So far I have tried hiding gridlines, setting them transparent, removed margins, removed padding, and setting just about everything that is to do with borders to transparent in the properties list.
None of the above seems to affect how the fields display, in fact turning gridlines on and setting them really thick and a different colour doesn't change how it displays. Is this a bug with conditional formatting in Access, or am I missing something obvious that's overwriting my formatting selections?
I have a checkbox that determines whether or not to display certain form controls. How can I also hide the resulting white space that comes from hiding the form controls?
Can I put all of the controls in some sort of container and hide the container? The form objects are all displayed in order, so it shouldn't cause issue.
Can I create a subform for the objects and hide it? This would make the main and subforms based off of the same table.
Occam's Razor would be the preferred philosophy in this case. Nothing too fancy is needed.
I've got a piece of VBA scripting which runs as an event linked to a button on my MS Access form.
I maintain a database of members of staff at my organisation. It's pretty outdated...
I'm basically wanting to pull in their updated data (extracted from on our payroll system) from a spreadsheet, into a form, when clicking a button on a particular person's record.
This is what I have so far.
Code:
start = Forms!frm_main2!txt_start_row.Value - 1
conv = DDEInitiate("EXCEL", "Staff List.xlsx")
cell_employee_number = "R" & start & "C1"
cell_surname = "R" & start & "C2"
[Code] ....
The function "CStr(DDERequest())" converts the cell number into the readable data, however I seem to have whitespace below the value.
What would I need to do to strip out this whitespace? Would I use strtrim? If so, I am unsure of the syntax... how would I incorporate strtrim into the above?
I have a form which I would like to enable scrollbars both horizontally and vertically (the main reason being, the application is designed for users with large / wide screens but may at some point be required on smaller screens)
Currently I have the scrollbars switched off and the form maximises but everything goes to pot if I resize the window. I'd like to add the scrollbars so if a user wants to resize the window to, say, half the screen, they can still scroll across to the 'hidden' parts of the form.
The problem with this is, if the form is maximised - or at least large enough to show the entire form - the area of the screen where the horizontal scrollbar resides is white (whereas the background colour of the form is a pale green) Which is quite unsightly.
I know I can remove the problem by removing the horizontal scrollbar and the navigation bar (which is already gone!) but then I can't scroll?
Is it possible to have a horizontal scrollbar but not have that white space at the bottom when the scrollbar is not required?
(Doesn't appear to be a problem with the vertical scrollbar?...)
I have a datasheet on a form that is unable to show all records in the size allowed. Consequently it has a vertical scroll bar. However, the scroll bar allows scrolling to the bottom whereby there is white space almost the same size as the data records. The horizontal scroll bar does much the same.
Is it possible to just show the records and only the width of the data in them.? No extra records exist in the table to cause this.
I have a lovely report that includes a small color photograph. I'm sending the report to print on my HP Color LaserJet, but it is printing in black and white.
I can't find anything in the Properties that specifies whether this prints in color or black & white.
How to print this in color?
Hi
I have a form, which users print out. On the screen, it has a light grey background, but I do not want this to be printed as it is just a waste of ink
Is there anyway of making the background colour "screen only"?
Chris
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
thanks
I want to run a pop up message "invisibly".
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.
Hi
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.
thanks for any help
Paul
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.
Any help would be appreciated.
HI
How can I use/set an image (picture) as a background in a form? I can't seem to find this option...
thank you
regards, Miha
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.:(
View 3 Replies View Relatedpls 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.
help would be much appreciated.
regards
hi every one
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 .
thanks in advance
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
Hi,
I'm currently using MS Access 2002.
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.
Kinds Regards
Chris
Hi all,
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.
Any ideas?
Cheers,
Rob