I would like to use icons and interactive buttons for my forms to give them a more professional look. does anyone know where i can get such icons? i'm quite an illiterate fool when it comes to making the icons using icon editors. i tried searching on the web but it always throws up stuff relating to windows xp. i use office 2003. can i use them? if not can anyone tell me where i can find such icons?
:(
I'm running Access 2000 and want to use some different icons than available through Access on some command buttons. So far, I can only get it to accept bitmaps. This isn't a problem if bitmaps can have a transparency. I don't think they can though. Any suggestions?
I searched without success for a solution to show small pictures (icons) in a table field to show up in a continous form.
Purpose is: a communication log table has comm codes such as - mail out - mail in - tel call in - tel call out
the comm log table has the fields CustomerID, datetime, CommCode
The CommCode table hast the fields CommID, CommCode, Icon
The form (subfrm) should show in continous form mode to each customer..Datetime, (commCode), and to visualize the Commcode the small image (icon) presented by an envelope with an arrow right, an envelope with an arrow left, etc.
I cannot find a solution for storing those little images and retrieving them from an OLE-Field.All my other pictures I do not have stored in the tables, but only the image path, but for that I would prefer to store them directly into a table field as they do not blow up the database.
Is there anyway to change the icon on a microsoft access database. I mean the actual File Icon, eg. the icon of Database1.mdb etc. I do not mean the icon once the database has loaded. Thanks for your help.
Hi everyone, does anyone know how to remove the little replication icons next to the db objects when a replica is converted back to a design master. I know there is a way cos i've seen it here before but I can't find it searching. Thanks.
i am having no end of trouble trying to display just the print preview buttons and print button at all times during my Database being open.
i have tried adding various options through the startup option but i find that when i activate things so that i can print via an icon i also get the option available to go to the database window, which i want to prevent.
well the highlighted stuff are the things i have to put into an Access database...so ive just setup a table but how do I add boxes so they can tick whatever option? And what do I need to do to make it save. Also would it be better using forms because i wouldnt mind using a background image as well.. thanks alot.
I have an access icon (*.ico) file associated with my DB. But when I try to access the database from a place other than my desktop where the icon is located the icon doesn't show up. Is there any way to embed the icon into the application so that when the database is loaded on a different machine the icon loads too..
I would like to create some custom icons and use them in Access. Does anybody have an experience doing this that can start me down the right path? Thanks:)
I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.
=Sort_1("Sort_1_Query1","LAST_NAME")
This is the Public Function Public Function Sort_1(SortName As String, FieldName1 As String) DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'" End Function
I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.
I have created a master form, which is a tab style. I have five additional forms that I want to use as sub-forms within each tab. I also want to include master navigation buttons that will work for each sub-form in unison. In other words if I navigate to record 10 on tab 1 and switch to tab 2, I want the new tab to show the information related to record 10. It would appear that I need to link them together in some fashion.
So I have made all the necessary forms to start working with my Access, and now I need a main form, a home where I should put all the buttons to enter each form.I have used the Navigation Control on a New form URL...
A row with buttons appeared, and I complete the property: Navigation Target Name with the target form, but it is giving me some trouble with a searchForm and a Query. Every time I enter this form (using nav control), Query asks for an Input.
I have created a form in Access 2003 based on a query, the form has a sub form( basically the form shows different projects, the sub form shows the stages of the project, one project can have many different stages). I want to put a command button to add a new record for the data in a sub form, I have managed to create one for the main form, but not the sub form.
Im doing a project and i have two different views i.e. Branch View and Staff View but i dont want Staff view to be able to access Branch details and visa versa!! Is there any way i can do this??
I have a Access program that I have used for 10 years with out problems. The program is used to track work done for various customers. When I try to go to a new record for the customer using the New Record Button on my form, the program stopped and I got a Microsoft error saying it had encountered an error and needs to close. No error Number shown. I can use the Last Record button with out problems, but when I hit Next Record i.e. new record, again I get kicked out. I have tried to trap the Error Number with no luck. I have purged a lot of early records thinking possible the data base was to large - no luck. I am at a lost for what I need to do to be able to use the data entry form.
I have a frmUserLoginScreen that opens frmMainSelectionScreen, which has 4 command buttons on it. Dependant on user level, some of the command buttons are disabled.
I have four user groups, manager, admin, IT and guest. When the guest logs on, the frmMainSelectionScreen only has one command button enabled. Once clicked, this opens frmClientDetails which has a command button that enables the user to add a record.
Basically, I want the add record command button to be disabled on the frmClientDetails if the user is a guest.
I've tried all sorts of code to reference the other forms but I'm not having any luck. Has any kind fellow got any ideas?
I have a form based on a query that has 16 options for values in one of the fields. I wanted to put an option button for each value on a form that would allow the user to view the records based on which option buttons were selected and have the form update accordingly.
The way I've gone about it is to have some code in the after_update event thingimy of each option button that updates a boolean value in a table that's linked to the underlying query the form is based on - but this just seems a long way to go about this... plus it's not working...
I've searched the archives for clues on this but haven't come up with anything. So I just wondered, is there a better way than what I'm doing. I'm not after somebody to do this for me, just point me in the right direction.
Hi All I have a main form which displays some basic info aboute a site. I would like to be able to place multiple buttons down the right side of the form. This would be similar to having a seperate column which is not affected by the number of records on show. I have considered placing them in the form header but think a column down the side would look much neater. Any help would be much appreciated. ChrisD