Remove Form Icon
Feb 9, 2006I read some solutions to replacing a default Access icon for forms. However, I was wondering if there is a simple solutioin to removing them all together without causing an error?
View Replies
ADVERTISEMENT
Reports :: Remove Restore Window Icon On Report Menu Bar
May 2, 2013I have created a custom menu used on my reports which contains all the icons I need and anchored them to the right side of the report. I have been able to remove the min, max and the close icons from the default report menu bar at the top right hand side as well as the "Ask A Question" dropdown. But I am not able to remove the "Restore window" button that comes with the report print preview.
How do I remove the "Restore Window" icon from the report's menu bar?
I'm using Access 2003...
Creating Help Field Icon On Form
May 8, 2006I would like to create a series of help fields for various text boxes on a form to free up space that is currently displayed in several labels.
Does anyone have an example that will allow me to create several help field icons on a form. Clicking on each individual icon will display a help message for that particular icon? I would prefer to store the data on a table. If I write this, I will probably use a recordset and display the data in a label.
I just wondered if anyone else has any other ideas.
Forms :: Change Form Icon Next To Caption?
Jun 12, 2014how to change a form icon and make that icon embed to my database, I have tried the Application Icon property in Access Options but when I copy the database to other computer then the icon disappeared.
View 3 Replies View RelatedModules & VBA :: OnLoad Event To Change Icon Of The Form
Sep 26, 2014I currently use code in a module and code on each form in the on_load event to change the icon of the form.. the code i use is as follows..
in a module:
Code:
Private Declare PtrSafe Function GetSystemMetrics Lib "user32" (ByVal nIndex As Long) As Long
Private Const WM_SETICON = &H80
Private Const IMAGE_ICON = 1
Private Const LR_LOADFROMFILE = &H10
Private Const SM_CXSMICON As Long = 49
Private Const SM_CYSMICON As Long = 50
[Code] ....
And on each form on load:
Code:
SetFormIcon Me.hWnd, "k: est directoryhsicon.ico"
What I am wondering is would it be possible to store the .ico file within the DB file itself (i know access can store bitmaps) and reference the .ico in the form load event code?
Overtime the db file will probably move to its own dedicated storage so using a direct reference to the file wont work..
I have tried the following but get an error (it tries to reference the .ico file as to being in the root directory of the db file)
Code:
SetFormIcon Me.hWnd, Left(CurrentDb.Name, Len(CurrentDb.Name) - Len(Dir(CurrentDb.Name))) & "hsicon.ico"
How To Remove Navigation From Form
Feb 24, 2006I'm trying to create a form without the standard navigation arrows on the bottom of the form. Is it possible to hide these? I want to use my own navigation buttons instead as they will be more intuitive to non tech users.
appreciate it
Need To Remove Line That Prints From Form...
May 26, 2006I am creating a form that is a letter. This letter will get printed off a lot. A line at the bottom of the sheet makes it look tacky. I am told this line prints on our other databases also. How do you get rid of it? Our company uses access 97 :mad:
View 6 Replies View RelatedRemove Duplicates From Query/form
Nov 10, 2005Hi,
I have the following set up on a form to pull together a query (by form) and resulting report:
Publication
Sector
Product
Region
Each publication can have multiple sectors/products/regions. The resulting query therefore duplicates the publication, for example:
Publication 1 Sector 1 Product 1 Region 1
Publication 1 sector 2 product 1 region 1
publication 1 sector 2 product 2 region 1
etc etc...
The report ONLY has publication on it, but as it is based upon the query utilising the 4 factors above, the resulting report is:
Pub 1
Pub 1
Pub 1
Pub 2
etc
I want the report to only list the publications once - i have tried "hide duplicates" from the form field properties, however this hides the text but leaves a big gap on the resulting report when generated where the duplicate would be if it were not hidden.
There must be a simpler way to acheive this than getting another query to create a table based on the first query which (the table) only includes the publication name, and is filtered to remove duplicates through a primary key...
Can anyone help!?
cheers
amx
How To Remove The Bar On The Left Of The Access Form
Oct 4, 2004Heiiii Everybody
I have s small problem please pay think for a second to answer me. !....
I have some forms and in those forms there is bar I don't know what is that , but there is something on the left side and I wanna remove it . what ever I do with form properties it is not going , may be I am doing wrong.
I am sending the screen shot of one form please have a look and tell me how to remove it.
thank you .
Kiran Karnati.
Modules & VBA :: Remove Column From Form?
Feb 23, 2015I have a multiple record form that displays fine. However, on the left hand side there is a column that when a record is selected, an arrow appears there. I don't know what this is called in order to suppress it.
View 4 Replies View RelatedRemove Link To Related Records In Form
Jan 23, 2006I have a Datasheet view of a form and it displays a "+" symbol. When expanded it returns a list of related records. How do I get rid of the "+" in my form?
View 8 Replies View RelatedForms :: Remove Blank Row On Continuous Form
Feb 26, 2015On a continuous form, I would like the user will add a new record via button click instead of popping open a blank record at all times. With AllowAdditions set to False on Form load, and turning it back on button click I can get a new record added. I am having trouble determining where to turn it back off. After Insert - doesn't seem to delete the blank row until I move to the blank row, so this doesn't accomplish what I am looking for.
AfterUpdate (for each field on continuous form) - this did what I wanted, but I was only able to update one field on the form for the new record. The combo boxes then were viewable, but I could not make a selection.
Can A Refresh Button On A Form Remove The Current Filter.
Mar 5, 2006hi, i have a search form, and when you double click on the record, it opens that record in my main form (which opens filtered)
this is fine because it displays the record that i want to see
however, when i try to perform other tasks on my main form, such as choosing the id from a combo box and finding that record, it wont work because the form is still filtered, one way to get around this is to open and close the form, but is there a way that i can implement something into my refresh button that removes a form filter.
Private Sub Refresh_Page_Click()
On Error GoTo Err_Refresh_Page_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
Exit_Refresh_Page_Click:
Exit Sub
Err_Refresh_Page_Click:
MsgBox Err.Description
Resume Exit_Refresh_Page_Click
End Sub
Forms :: Cannot Remove Unknown Line When Creating Form
Jun 24, 2014I have created a form and insert, delete some columns, controls in layout view. When all 's completed, i saw a dark vertical line on top right of the last colulmn but i could not delete it. I deleted column, set property but they all did not work. What i have to do now? Below is a screen capture from my situation.
View 5 Replies View RelatedModules & VBA :: Remove Specific Filter From Split Form?
Jun 27, 2013So I have been developing a database tool that needs to have multiple ways of filtering data. I wanted to be able to display the data nicely so I'm using a split form.
As usual, there is an easy to read form on the top half and a datasheet on the bottom half. On one side of the form half I have some comboboxes that are associated with fields in the datasheet. The comboboxes apply multiple filters, narrowing the search results down. It all works fine.
However, I've been trying to figure out a way to remove just one filter at a time. There is a button to the right of each combobox that is intended to clear just one filter.
So far this is what I have. This code clears all filters.
Code:
Function removeFilter(source As String, combo As ComboBox)
'source is the field being filtered and combo is the current
'value of the combobox
With Forms("PART_QUERY")
.Filter = "[" & source & "] = " & Chr(34) & combo & Chr(34)
.FilterOn = False
End With
End Function
I had some success using another method with select statements. Every time I cleared a filter, I would also check every other combobox to see if they were not null, then reapply each one of there filters. That seems way over complicated. I'm sure I'm missing something.
How do I remove one, specific filter from a split form, after I have applied many different filters?
Filtered Form - Remove Toggle Filter Button?
May 16, 2012I have a form that opens with a filter on depending on what the user is supposed to see. When I deploy this, I don't want them to see the "toggle filter" button at the top. I tried making a custom ribbon like this:
Code:
<customUI xmlns="http://schemas.microsoft.com
/office/2006/01/customui">
<ribbon startFromScratch="true">
<tabs>
<tab idMso="TabHome" visible="false" />
[Code] ....
But it didn't seem to have any effect. When I applied it, it didn't even create "A Custom Tab". That might be because I have disabled everything that I could disable on the "Current database" options, I'm not sure.
Icon Most Wanted
Jan 25, 2006Hello fellow users,
Just a quick note, i would like to know if anybody has come across any good internet site for download of icons ideally free ones.
Alastair
Office XP Icon Dll
Apr 5, 2006Hello Folks, i was wondering whether any one knows any dll or file that stores office xp icons. I wanna extract them.
View 2 Replies View RelatedChanging Icon For Mde!
Apr 24, 2006hello guys,
firstly thanks to all the guys here without whose help, I would not have been able to finish my database. However, there remains one question to which I havent found a satisfactory answer. I have checked through all the threads here.
I have made an .mde for my application and I want to customize my application icon to my company icon. The DB by default shows the access icon which I would like to change.
The threads here deal with issues of changing the desktop shortcut icon or changing the icon for forms. These threads do not address the problem I am facing.
I want the icon to be changed from access icon to a customized icon.
I am using MS access 97.
Any help will be greatly appreciated. If there is a thread which I may have overlooked, plz point me out.
Thanks in advance
FXP.
Icon Troubles
Aug 19, 2007Hi, this is my first message on this forum ;)!
I have a little problem with my Access 2000 (with 2003 too on another compuer), in fact when I put an icon on a page of my Tab Control, the background of that icon is white and not transparent (the file I use is an "ico" file and so it HAS a transparent background, anyway I treid all the possible file types); the strange thing is that when I put an icon on a button, the icon is shown properly. Here is an image of my problem:
http://img529.imageshack.us/img529/9922/testuu9.jpg
Thank you,
StockBreak
Can't Use The Toolbox Icon
Jan 24, 2006I'm working on a user's database that needs some cleaning up; however, when I go into the "View" menu, the option to use the Toolbar is greyed out and I therefore can't utilize the Toolbar.
What do I have to do in order to have use of the Toolbar?
Thanks in advance.
Icon Ghosting
Nov 13, 2006when a toggle button object is selected on a form, it becomes ghosted. What property is changed? I want to reset all the other toggle button images when a new one is selected.
View 1 Replies View RelatedIs It Possible To Do A Systray Icon?
Oct 10, 2007I trying to find out if it is possible to have a systray icon load when you start a access database or form? This way I could do pop up messages and icon changes thru out running access. Any advice, links, or imput would be great. Thanks !
View 1 Replies View RelatedForms :: Cannot Save Form - Remove Layouts With Empty Cells
Dec 8, 2013I have added a delete button to my form but now I cannot save the form.
I get the error message:
"In order to save your changes you must remove any layouts that have empty cells in them and/or set the has module property for the form to no."
How do I locate empty cells.
Modifying An Icon's Properties
Mar 21, 2006I have an Access database split into FE/BE. For the front end, each user has his own directory on the lan. The directory is named with the UserName.
I've created an installation program in Access. It basically installs the icon on the user's desktop using Environ("UserName"). It also installs an Excel file the program needs on the hard drive.
Here's the problem...Right now, the installation program grabs the shortcut off the lan and installs it, but that shortcut has one user's UserName hard coded as the target. That one piece of information needs to change for each person. Is there a way for the program to modify the target based on the username of the person running the installation program? Without this piece, I need to visit every user after he runs the installation program and modify the properties of the new icon to point to his specific directory.
Thanks for any help you can provide!!
When Specifiying An Application Icon...
May 11, 2006I can't hide the database window...but when I take out the application icon, I can hide the database window.
Why can't I do both at the same time?:confused: