Forms :: Quick Style And Change Shape Formatting Buttons Grayed Out

Oct 17, 2014

The Quick Style and Change Shape formatting command buttons greyed out. What setting do I need to change to make them available?

View Replies


ADVERTISEMENT

Forms :: Converting Old Flat Buttons To Newer Rounded Style

Aug 15, 2013

I have Access db's that were originally created in Access 2003, I have upgraded them no problem to accdb and am using them in Access 2010.

When I create a new form and add a button it is rounded/shaded/white/blue etc - looks good.

When I add a button to an existing form, or reformat the existing form buttons (back colour Accent 1, Lighter 40%, Use Theme Yes etc) it remains an old style button (unrounded, solid colour etc).

How to convert old style buttons to new style buttons ..

View 2 Replies View Related

General :: Shape Effects And Conditional Formatting

Oct 25, 2013

Having recently upgraded to Access 2013 I've noticed when designing forms or reports the Shape Effect button is greyed out. Also, when I click Conditional Formatting no dialogue box pops up. This is happening on all old Databases and new ones created with 2013. (Windows 7 64 bit)...

View 6 Replies View Related

XP Style Buttons

Nov 7, 2006

How do I use XP style buttons like the "Inventory Management Database" example? I am using Acess 2003...

View 3 Replies View Related

Forms :: Access Style And Window's Style Form Border?

Nov 15, 2014

In my current database there seems to be two different types of borders in my pop-up forms! The best way to explain it is that some forms will have the Access style border while others have the glass style border that you see in windows. I can't seem to find any settings that will change this or even determine what causes it.

View 4 Replies View Related

WindowsXP Style Command Buttons

Mar 6, 2006

does anyone know how I can get the Windows XP style command buttons to work in Access 2000? I'm on an actual XP pro machine and I'm sure there's an active x control somewhere... just don't know where to look

View 1 Replies View Related

Modules & VBA :: How To Change Cmd Window Style

Nov 11, 2014

I am using the following code to open a cmd window and wait while it executes, but I would like to run the cmd window minimized but cannot work out how to do that

Code:

Option Compare Database
Option Explicit
Private Type STARTUPINFO
cb As Long
lpReserved As String
lpDesktop As String
lpTitle As String
dwX As Long
dwY As Long
dwXSize As Long

[code]....

how to change the cmd window style.

View 2 Replies View Related

Change Colour Of Navigation Buttons And Command Buttons?

Mar 17, 2006

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:

View 2 Replies View Related

Change Colour Of Navigation Buttons And Command Buttons?

Mar 17, 2006

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:

View 4 Replies View Related

Forms :: Change Color With Conditional Formatting

Oct 18, 2013

I have a subform that is purely to display information (no edits will be made on it). The subform has a special color on it (company color) that I can not deviate from. My problem is the first record in the subform (displayed as a continuous form) gets the focus. The font is white and standard access has a white background. My end goal would be to elimnate the focus for any record in the subform (if it is possible). I know that I could change the color with conditional formatting but the colors in conditional formatting do not match the company color.

View 4 Replies View Related

Forms :: Conditional Formatting - Change Back Color Of Fields

Aug 1, 2013

I have a form in datasheet with the fields "Date In" and "Date out" among other.

I want to be able to Change the backcolour of the "Date In" to red, yellow, or green depending on the length of time elapsed between current date and date in. This works fine on the conditional formatting, but now I only want to apply this formatting IF the "Date Out" is empty.

Access 2007.

View 3 Replies View Related

Tab Style Master Form - Navigation Buttons For Each Subform Within Form

Jan 26, 2015

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.

View 1 Replies View Related

Forms :: Use Buttons On A Form To Change Sort Order On A Continuous Form

Jul 23, 2013

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.

View 4 Replies View Related

How Do I Change The Size Of UpDown Buttons?

Nov 9, 2005

Good afternoon. I am brand new to posting on this forum but I have been using this forum for help since I started my new job and I would like to start off with thanking you all for that. :)

Now onto my problem:
I am currently trying to create a form in Access 2003 that can be easily read and seen because it will eventually be used as a touch screen interface. I have several text boxes on this form that simply display a counter's value that is updated by a neighboring updown control. The text displayed within the textbox is just the value of the updown control. This updown control is more specifically a Microsoft UpDown Control ver. 6.0 (SP4). Due to this interface ultimately being used as a touch screen, each and every button needs to be large enough so fingers can easily touch only one button at a time.

My problem is that I do not know how to change the size of the actual Up/Down buttons on this updown control. I can alter the height, yet I can not alter the width of these vertically oriented buttons. If anyone knows how to correct this problem, I would greatly appreciate it. The sites I looked through that deal with Visual Basic reference do not deal with resizing the updown buttons, but with other properties of the updown controls. Thank you for your time and assistance.

View 3 Replies View Related

Change A Listbox Recordsource With The Use Of Option Buttons

May 27, 2005

Good afternoon

I have been helped out so many times in the past here I thought I would try my luck again.

Is it possible with the use of option buttons to change the row source of a listbox?
I want to use the listbox for a search criteria and thought it might be easier to have 1 listbox been updated from the choices made using a group of buttons.
I would like like the row source to be based on different tables maybe I might need to use queries.


Can anyone point me in the right direction?

View 6 Replies View Related

Forms :: Default Formatting Option In Conditional Formatting Dialog?

Aug 1, 2014

Need to confirm whether the Default formatting option in the Conditional formatting Dialog won't work in datasheet view of a form. Please note that all conditional criteria are working fine but not the Default Formatting option - only in the Datasheet view (In Single Form view the default formatting is working fine)

View 11 Replies View Related

Tabular Style Forms/Reports And Information

Jul 20, 2005

Hello all - Working on a form that is supposed to display order approval information. In the database I'm working with, people are stored as in the approvals table by a reference to an autonumbered value. However, I want to display their name, which can be obtained normally through an SQL or DLookUp Command. This tabular form style though is giving me a problem. If I put new textboxes on the form and load it as I normally would, like:

ApprovalName.Value = DLookup ("[UserName]", "Users", "Users.UserID =" str(ApprovalID.Value*))

*ApprovalID is a hidden textbox that stores the number that is used to represent a particular user.

The problem becomes that using an OnLoad or and OnCurrent Form function, the boxes only load one value. I want them to load the different values for the different entries, but I am lost as to how to do this. Any help would be appreciated.

A similar issue that I've been having with reports is that I don't know how I would do this at all... I want to do the same thing (retrieve the Name or whatever that is related to a numerical value) and put it on the report. I'd appreciate any info on how to do this.

Thanks

View 1 Replies View Related

Formatting Change Month From # To Mmm

Aug 31, 2005

The months in my query are recorded as numbers 1 for January, 2 for February, etc. I was wondering how I could format in a query or report the months so that they automatically format themselves into text.

Thank you

View 1 Replies View Related

Setting The Right Shape Of A Form?

Sep 25, 2015

When I am working on the Lesson 37 shown here:[URL]

I get to the point

Click the label that was added to the subform and press Delete (to remove the label). You may also need to move the subform and resize the tab sheet.

Now I assume the label to be removed is the original title of the subform or sbfVideos. That is the label that must be removed. It also says "You may also need to move the subform and resize the tab sheet." I will say that you do. My tab sheet is about 2 3/8 inches in width. I want to move it so the width increase to 3.25 as shown in the figure in the tutorial right after it says that you need to resize tab sheet.

When I grab the far right orange line and pull to the right the whole subform moves! That is not what I want.I merely want to increase the width of the form as I said above.Also in this narrow initial file when I switch to form, it cuts off parts, usually the Length. Of course, that is not what I want.

View 5 Replies View Related

General :: Change Formatting Of Number Columns?

Nov 21, 2014

Is there a way to change the formatting of a numbers column to the formatting :

1 = 0001

11 = 0011

111 = 0111

1111 = 1111

But that would have to apply to this also

1 - 2 = 0001 - 0002

11 - 22 = 0011 - 0022

111 - 222 = 0111 - 0222

1111 - 2222 = 1111 - 2222

If that makes sense ....

View 14 Replies View Related

Modules & VBA :: Why For Loop Collapse When Cutting A Shape

Feb 3, 2015

Code:

For Each Shape In pptslide.Shapes
If Shape.Top > pptshape.Top Then
'MsgBox Shape.Name
Shape.Cut
newslide.Shapes.Paste
End If
Next Shape

If I keep only the message Box inside the loop, it iterates all the shapes in the slide. But when I cut and paste the shape, it comes out of the loop after cutting and pasting.

View 1 Replies View Related

Round Buttons Or Oval Buttons Instead Of The Normal Square Buttons

May 30, 2005

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

View 2 Replies View Related

Reports :: Change Text Formatting Of Control In Report Based On Boolean

Jul 10, 2015

I would like to change the text formatting (color, italics, bold etc) of the contents of a control based on a boolean value in the underlying datasource of the report.

For instance, I have a report that generates a "Proforma Invoice" i would like to ability italicize the prices of certain items based based on a boolean value (EstimatedPrice) in the underlying datasource.

View 2 Replies View Related

Modules & VBA :: Change Formatting Of Unbound Text Field On Continuous Form

Apr 16, 2015

I have a continuous form with a text field that says "Select". There are two other fields, one of which is Brand. When the Brand Combo box has nothing in it I want the text box to appear (instructing the user to select a Brand) But once the user selects a Brand and goes to the next records, I would like the "Select" in only that record to become not visible. I tried conditional formatting but can't apply that to an unbound control ( or at least it is grayed out when I select the text box) and any other possible solutions I have found changes all of the selects - not only the one in the changed record.

View 7 Replies View Related

Quick Access To Forms

Jan 5, 2005

Was wondering is there a way I could have a button that would give me direct access to a specific form. example. I have design a form for my Ranch and was wondering instead of me clicking on form than add cattle. Is there was a way i could have a button on my database that would when i first open it to automaticly take me to that form.

thanks
Roger

View 4 Replies View Related

General :: Conditional Formatting - Change Backcolor Of Process If Status Field Contains Certain Text

Jan 8, 2014

I have a subform with two fields [status] and [process], i am trying to get the backcolor of procces to change to red if the status field contains the text "expired".

I have tried vba. plced on the after update

if me.status = "expired" then
me.process.backcolor = vbred
else me.process backcolor = vbwhite
end if
this

Changes the color of the field [process] but also all process field colors to red even if the status field does not contain "expired".

I think conditional formatting is the way to go but i think i need an expression to complete this.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved