This is one of those postings about a world-shaking discovery on my part that was boringly obvious to everone else. But here it is.
To make a colored button, create a button like rectangle or, if you want a label, a Label, and overlay it with a Button. Set the Button's Visible Property to No.
Hello everybody,
I’m new here and I have a question for you..
Is it possible to place round buttons or oval buttons on your forms instead of the normal square ones?
Greets,
Tom
Here's (http://www.lebans.com/tabcolors.htm) a dynamite site with an A97 dowload with code for "colored tabs" which I stumbled onto. I converted the A97 code to A2K and it ran.
Many of you will be able to put this to good use.:)
Hi everyone....
I have imported a data sheet into Access that had certain columns a different color...green...they were colored so that the end user would
know which columns were to have input. (visually)
Is there anyway that I can keep this format or color the columns in Access?
Also the end result is from a Query...does that make a difference ?
Thanks....
I'm creating buttons from images I''m pasting on the forms, but all buttons are having these 3 pixels red, green, blue down in the left corner.
http://img150.imageshack.us/img150/16/accessbuttonln4.png
Any way to get rid of them?
Is there a way to have alternating colored records so it is easier to read in a report..Is there a way to have a line around each record to set it aside from other records so they don't blend together.
View 3 Replies View RelatedI have a series of records that I would like organised into groups.For example everyone with the surname Jones who lives in Wales and is between 18-30 years old.I would like a Combobox that has that group sorting visible in some way, possibly with colours.for Example if i had the records:
First Name Surname Country Age
Dave Jones Wales 24
Bob Jones England 28
Fred Jones Wales 19
Jim Jones Wales 22
Ian Jones England 29
Frank Smith Scotland 32
I would like a Combo box that shows the names Dave , Fred and Jim with a background colour of Red then Bob and Ian with a background colour of white and Frank with a background colour of blue.how I group (maybe you can add spaces between the names Dave , Fred & Jim and bob & Ian).
I am creating a table in access and I would like to color code some of the fields if it is possible. There would be multiple green fields to represent it has usable data, Yellow to represent the data is in process and Red to represent bad data. I do not want to color code fields using queries, forms or reports I want to color code the fields in the tables only.
View 3 Replies View RelatedIs this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
i have constructed a switchboard/main menu and have set up buttons which link to forms. i have also made a 'return to main menu' button which does as it says, the only problem is that after going back to thge main menu both forms are now open...any ideas on how to stop this problem
View 12 Replies View Relatedhow would i get a button to be able to delete a record that is present on screen?
any help would be brilliant :confused: :confused:
I have been making some custom buttons and noticed that the size of my db went up 360kb after I added two buttons. One button consists of two images and the other button one image. The original file size was 2kb for each image. Is 360kb a normal increase in db size after converting images to buttons?
There might be a hefty price to pay, in db size, if I get carried away and add my "up market" buttons to all my forms!
Hi everyone,
I am trying to create a button on a form that will export only that record. On the command options I do not see there being an option to do such. Can anyone help? Thanks. I would like to export to excel or anything that will capture what I am looking at. I have noticed that Yes/no boxes do not export to excel?
I have a form that's unbound (Music) with a subform (Arist Info)that is bound. This subform also contains two other Subforms (bound).
Their names are (Album Info) and (Song Info). The subform (artist Info) contains some pagebreaks, which I'm trying to use to bring up
the two other subforms .The cmd buttons used to control the pagebreaks are located on the main form (Music). My problem is with the third & fourth cmd buttons. I can go back & forth nicely with the first two, and even go the the third. That's were the problem starts. I can't go back to the secound or first from the third or go to the four. The VB code haults and the GoToPage line is highlighted. The code use on the on click event is as followed:
Forms!Music.SetFocus
Forms!Music![Artist Info].SetFocus
Me.GoToPage 1
The only thing that changes between all four of the is the page#. I hope someone can help me with this, it's driving me crazy not knowing what i'm doing wrong. If you need to look at a smaple DB there's one on a post called "Problem dealing with macros". I just posted this one a few days ago.
Thanks,
Rich M.
I'm a bit tired of the buttons I have been using both default MS and my custom ones. I'd like to find some more interesting versions that I can use and have been searching on google etc but the options are limited. Does anyone have any favourite links I can follow?
View 1 Replies View RelatedI have created a floating toolbox much like the floating toolbox you see when you design a form. I want my buttons to stay depressed the same way they do in a real toolbox. It must be possible... I just have no idea how..
any info is greatly appreciated
I am a newbie at Access and I am currently learning it for my job...I have a database going and I am wanting to do two things and I can not figure it out for the life of me.
Little background, the database I made is a continuous form. I am wanting a command button that when pushed will put it in data entry mode, and when pressed again will put back in a 'view all' state. I know it is a simple If Then, but I don't know VBA very well =
Other thing, is I wanting to be able have button that when pressed will output to an excel sheet, right now I have it when it is pressed it asks me what kind of format I want outputted, and I want it automated to just go straight to excel.
Any help would be appreciated, thanks.
Hi,
Does any body know how to remove/disable the record buttons at the bottom of forms and subforms please?
Thanks,
B
I have a field (DueDate) that will blink (flash) if it passes its value
problem is the text to the right of the navigation buttons is not showing the number of records unless I navigate till end of the records.
I tried Me.Requery and Me. Refresh but with no success
How do I make the command buttons on my form actually do something, the only one that attempts to work is "DELETE RECORD" the others dont do anything at all
View 8 Replies View RelatedI need help combining both text and images on an Access button. Does anyone know how to do this? Bryant
View 2 Replies View RelatedThe detail section of my (continuous) form may or may not have a scroll bar on the side depending on the number of records. When it is there, it is way off to the side and the user may not notice that there are more records to view. I'd like to add Up/Down buttons to the footer that become visible when the scroll bar is visible, and work like the Up/Down buttons on the scroll bar.
Can anyone suggest how I might code this?
Thanks,
Sup
First time user - so please forgive if this is already out there.
I want to hide the navigation buttons on a form and create a custom set of controls. I can create the buttons themselves but am having trouble with the "N of X", where:
X is the total number of records in the query, and
N is the current record showing in the form.
I can get X but how would I capture and display "N".
Any help would be appreciated.
Please help!!
I have a form with a "filter by form" button generated by a macro and it works fine. Now I need a button so that the user will not have to use the funnel button in the toolbar to apply the filter. When I tried to place an apply filter button in the form, both buttons become greyed out and the only way is to click the funnel in the toolbar. Any help!!
Tony
I searched the forum on custom navigation buttons and found great posts about it. I downloaded 3 samples and the one that fit what I needed was SJ McAbney's dbNavSubform.zip. sfrmNavigation (http://www.access-programmers.co.uk/forums/showthread.php?t=87791) I imported sfrmNavigation per SJ McAbney's on the post into my database.
I didn't want to start a new thread so I posted on the thread: http://www.access-programmers.co.uk/forums/showthread.php?t=88880
But I didn't get any responses.. I don't know if it's been overlooked.
I am encountering problems when I use dbNavSubForm in my database.
1. I made 2 copies of sfrmNavigation and I am using it on 2 of my forms.
On the main form that I am using it when I first open the database it shows record 1 of 1 when really there is more than 1 record. When I click on the next button it then goes to say 2 of 15.
How can I fix this so that when I open the database it will say 1 of 15 and not 1 of 1?
2. I have a Main form ex: frmMain and a subform on frmMain. I added the the subform (dbNavSubForm) onto my subform. Make sense? Here the navigation buttons do not work. When I try to add a new record it tells me "The object frmTOItems isn't open" When I try to click on the next or previous it tells me "Object variable or With block variable not set. How can I fix this?
I have captured a picture of my form so that you can see what I mean.
Thanks in advance