Forms :: Custom Alternate Row Colors On Forms?
Jul 4, 2013
I have a sub form in datasheet view and need to custom alternate row colors with criteria from the main form.
E.g. If the Criteria field in the main form is 4, row colors must alternate after every forth record in the sub form. First 4 rows not shaded, next 4 rows shaded. If the Criteria changes to 6 then first 6 rows not shaded, next 6 shaded etc. I can do this in a Report with the Format Event but in a Form there is no Format Event.
On the Home tab, under Text Formatting group, using the Alternate Row Color drop-down list, changes every row, which is not what I need.
View Replies
ADVERTISEMENT
Dec 6, 2006
Dear All:
I have a report in Access 2000 showing names, ID numbers, Address and dates.
I wish to have alternate colors instead of the default white backgroud Access has.
Any ideas on how to start?
Many thanks,
Dion
View 2 Replies
View Related
Jul 29, 2015
Is there a way to permanently set the alternate row color in access, so that whenever you create a form it will always be what I want.I know that I can make a template and always use the template, but I would prefer to just change the access settings if that is an option.I checked the access settings but couldn't see an option to do this.Also if you can set sub-form's to always have a transparent border, so that you don't have to change it every time you add a sub-form to a form.
View 7 Replies
View Related
Nov 8, 2014
I am trying to see if it is possible to store colors in a form or table and then reference them while in VBA. What I am hoping to do is when I write all my code for command buttons to change On Got Focus, instead of writing xxx.backcolor = RGB (255,255,255) i could do something like xxx.backcolor = Forms!HiddenColors!Command That way if i want to ever change the color scheme of the db, I can change it in one place rather than hunt lines of code.
View 6 Replies
View Related
Mar 30, 2014
I have to create a control on a form that will be able to change to one of ten colors, some of them are subtle shades. I will be doing this from vba on the control. I know how to do all of this except defining the colors.
I keep seeing the 3 part RGB(xx, xx, xx) etc. but I can't find the values for it that will give me the exact colors that I need!
I also saw a possibility of using a the hex equivalent for the color but I couldn't make that work?
View 2 Replies
View Related
Dec 5, 2014
I am trying to see if it is possible to store colors in a form or table and then reference them while in VBA. What I am hoping to do is when I write all my code for command buttons to change On Got Focus, instead of writing xxx.backcolor = RGB (255,255,255) i could do something like xxx.backcolor = Forms!HiddenColors!Command That way if i want to ever change the color scheme of the db, I can change it in one place rather than hunt lines of code.
I have played around but with no success. Technewonline is a website that specializes in introducing the latest technologies such as Best Tablet Android Have Price Under $200 and Best tablet of Apple in 2014 and The Best Midrange Smart Phone In 2014 and Top Best Ultrabook Of 2014 and The Best Phones 4G Valued At Under 300 USD is also a website for sharing your tips about computers, mobile phones and tablets, products are available from leading supermarkets will surely satisfy you.
View 1 Replies
View Related
Nov 1, 2013
We use access to enter our service tickets in at work.What we have are three date fields.
Call Date
Start Date
End Date
We are 24/7 operation.Currently all 3 just autopopulate with the current date.What i would like to do is ADD a CHECKBOX next to each Date Field.And make it work like this.
1. let them autopopulate as they are currently
2. if you end the call AFTER MIDNIGHT (the next day). CHECKING the box would automatically populate yesterdays date in each of the fields that has the check box CHECKED
View 3 Replies
View Related
Aug 24, 2014
I've got buttons (on the header of my form) that I plan to make act as tabs for a single record.Each button should display more information for the same person (basically, more fields from a different table, but with the same primary-foreign key).So, when I click (one of) these buttons, a different form should open and display the record assigned with the same primary key.I don't want to use the default tab control because it's ugly and doesn't go well with my theme or my layout.
View 14 Replies
View Related
Sep 24, 2013
I am using Microsoft Access 2010. It provides great filtering and sorting options in the ribbon for any object. But what if I hide the ribbon and want to create custom buttons on the form to do the filtering and sorting job? There are some filter options available in macros but are not quite like the ribbon's own Filter button. When the Filter button is clicked from the Robbin, a filter menu pops-up under the active field, which doesn't happen when I try to do it using Macro functions like "Apply Filter" or "Set Filter" etc. I want to have that big "FILTER" button from the Ribbon on my form.
View 2 Replies
View Related
Apr 24, 2013
In Access 2007.I have a Main Form with (1) subforms that have a differenet .RibbonName set. When switching focus to the subforms, the Ribbon Tab for the Main Form stays active and the subform's Ribbon is not activated. I have put the ribbons assigned to the subforms on a main form, and they activate as expected. This is a major issue to which I can find nothing on the web!If i open subform directly, ribbon functioning fine
-Allow Full Menus = false;
-start from scratch = true;
View 2 Replies
View Related
Aug 12, 2013
I need to create an "autonumber" field in the following format:
FYYMMXX
Where F is a constant, YY is the year, MM is the month, and XX is an incremented number. So for example, the first record in August of 2013 would be "F130801".
I've been checking other threads but haven't been able to follow them to a resolution. I think there is a way to do this within my form...
View 3 Replies
View Related
Apr 28, 2015
I have a subform with year and month, subform shows result of a select query.
When I open query separately it show data as required order but when i show data in subform related to this query, data show in rearrange order.
How can I set order in subform as query result.
View 3 Replies
View Related
Aug 5, 2015
I have tried the code below, but I am not getting what I need. I have a table [Student Info] with a field [Student ID] as the primary key and many other fields. I added the Student ID field to my form, [Student Add]. When I input an ID that already exists I get an error code as expected but then my form still loads. I currently have a second form for updating student info [Student Update] for which I have a parameter form that asks for the Student ID. I would like to use just one form to add and update students if possible. So, if you add a new Student ID you can enter all pertinent data. However, if you enter a duplicate Student ID the form should populate with that student's information.
If I must have two forms (1 to add and 1 to update) and a duplicate Student ID is entered into the Add form, the user should get a message stating that the record already exists. Then, (Option 1) force the Add form to close without saving or (Option 2) give an option for opening the Update form. Either option is acceptable at this point because I am stuck.
When attempting to use the code below, I get a data mismatch error on the "Answer = DLookUp......" line.
Here's one I use on Social Security numbers for a pop up when a duplicate....
SS# is stored in table "tblApplicant"
Private Sub SocialSecurity_BeforeUpdate(Cancel As Integer)
Dim Answer As Variant
Answer = DLookup("[SocialSecurity]", "tblApplicant", "[SocialSecurity] = '" & Me.SocialSecurity & "'")
If Not IsNull(Answer) Then
MsgBox "Duplicate Social Security Number Found" & vbCrLf & "Please enter again.", vbCritical + vbOKOnly + vbDefaultButton1, "Duplicate"
Cancel = True
Me.SocialSecurity.Undo
View 14 Replies
View Related
May 23, 2015
I got an image bitmap that I want to use to customize my button. I got following error pop up."Image Generator" - "search key not found in any record".I'm using access 2013
View 1 Replies
View Related
Aug 18, 2015
I am using Ms Access 2007 and I am new to it..I have table of following fileds
ID (as a primary key)
AccountingYear (Filed for current accounting Year e.g., 14-15; 15-16)
Series (text- as R, Y, B etc to denote series code)
OrderNo (field to store custom autonumber Order No e.g., for Series R-1, R-2, for series Y Y-1, Y-2, etc)
I have created a form using all these fields..Now what i want to do is I want to create custom order no as first 2 digit of accounting year+Series+Autonumber of respective series as
14R-1
14R-2
14Y-1
14Y-2
14Y-3
14B-1
15R-1
15R-2
15Y-1
15Y-2
Means autonumber starts with 1 for every accounting year of respective Series..how to do this and what code or formula should be applied and where the code should be inserted as I am new to Ms access
View 1 Replies
View Related
Sep 15, 2014
How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.
View 3 Replies
View Related
Sep 6, 2013
I'm using access 2003. I've got a textbox placed ontop of an image that I want to make it seem to disappear on a conditional format.
The back color property of the textbox I want to set is "13160660". How do I choose this colour when applying conditional formatting as I only seem to be able to choose from the swatch of 40 default colours and no option to define custom colours.
View 4 Replies
View Related
Dec 11, 2013
I'm trying to track daily production at a manufacturing company running many different processes at different locations each running multiple parallel "lines." The tricky part is that the number of lines running and the shift schedules e.g. 2shifts 10hrs/day 4days/week or 3shifts 8hrs/day 5days/week change frequently for each process.
Right now I have a form for process data that specifies the schedule and number of lines running each day. Then I'm running an append query to a "production" table that generates blank production records associated with each item made in each process for the correct shift/line combinations.
Up to now I've been manually changing the date on the append query each time I run it. Then I have a seperate query for each process that pulls out the production records for each day. My problem is that the preferred interface for production data entry is a spreadsheet with the following layout:
--------DAYS LINE 1 DAYS LINE 2 SWING LINE 1 SWING LINE 2
ITEM 1 100
ITEM 2 2250
ITEM 3
which changes each time the shift/line schedule changes for each process. The only way to achieve this layout I know of is a crosstab query which isn't updateable. Ideally, each day the manager will specify the shift schedules and forms will be automatically generated with the correct structure and sent to the process supervisors. I'm open to different form layouts and even redesigning the database completely.
View 2 Replies
View Related
Feb 10, 2014
I am trying to make something like custom bar chart on a form using rectangles. I made 4 rectangles (BarBZ, BarBA, BarKI and BarMA) and have the following code:
Code:
Dim PctBZ As Double
Dim PctBA As Double
Dim PctKI As Double
Dim PctMA As Double
PctBZ = Me.BZ / (Me.BZ + Me.BA + Me.KI + Me.MA)
[Code] ....
It works perfectly except... the rectangles grow/shrink downwards and not upwards. As a result the bars are aligned to top, while I would like to have them aligned to bottom.
View 3 Replies
View Related
Jul 22, 2013
I've been working on a database for work for the last few weeks and this forum has been a Godsend many times over, but now I have a problem that I can't find any reference to.
Using Access 2003, I have a form that uses 3 cascading combo boxes in the header to find a unique record, and a command button that brings up the rest of the record into unbound fields in the body of the form.
It works fine for finding records, but whenever I enter/change data on it, the record doesn't save. The navigation buttons at the bottom don't work - the Next/Previous record buttons are disabled, and the First/Last Record buttons do nothing.
Navigation buttons are enabled/activated in the properties.
I tried getting around this by creating a Save Record command button - first using the wizard, then using VBA code DoCmd.RunCommand acSaveRecord as advised by [missinglinq;696351], but this still doesn't save the changes.
View 4 Replies
View Related
Aug 6, 2014
Having set a table short text field to 'Indexed (No Duplicates)', I have a form which produces a '2105 runtime error' when the user attempts to submit a duplicate value. I would like to replace this default error message with a more user-friendly MsgBox.
My code for the SaveRecord button is:
Code:
Private Sub SaveRecord_Click()
DoCmd.GoToRecord , , acNewRec
MsgBox "Record successfully saved", vbOKOnly + vbInformation, "Record Saved"
End Sub
My code to capture the 2105 runtime error is:
Code:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 2105 Then
MsgBox ("This villa booking has already been logged.")
Response = 0
End If
End Sub
Unfortunately when the save button is clicked (when attempting to save a duplicate value), the 2105 error still runs. What are I doing wrong?
View 12 Replies
View Related
May 15, 2014
I am currently in the process of creating a pop-up menu to allow my users to do some simple text formatting.I have used the following code to do so:
Code:
Dim cmbShortcutMenu As Office.CommandBar
' Create the new pop-up menu instance
Set cmbShortcutMenu = CommandBars.Add("popupFormatMenu", msoBarPopup, False, True)
' Add the bold button
[code]....
The problem is that I now want to add the FontColor picker control and I keep getting an error.I think the problem lies in the type of control I want to add. According to the Microsoft support files I downloaded the fontColor control is of type Gallery and ID = 11949, so the code should look something like this:
Code:
cmbShortcutMenu.Controls.Add Type:=msoControlButton, id:=11949
I need to replace msoControlButton with something else.
View 1 Replies
View Related
Apr 29, 2015
how to change Access default error messages with custom messages? Like, if I enter some data in a sub form where the parent form is empty new record, default error message says that 'You must enter a value in the 'column name' field'.
I want to disable this default message and display my own error message. Now I know MessageBox and MsgBox fuctions to display custom messages, but how to disable the default message.
View 6 Replies
View Related
Aug 19, 2004
Is there a way to use a command button to perform the exact same function as the "What's This" (?) button on the title bar? Is there code I can give it "On Click" that will make it do the same as as the What's This button?
View 2 Replies
View Related
Aug 7, 2006
Hi,
I am trying to produce either a report or a form that displays records 1 to a line. That bits easy enough using a tabular layout.
I would like to make text boxes that hold the data a differnt colour on each alternate line. So the background colour changes from white, then green, white , green etc.
Anyone give me a starter on this one please?
Thank you
David Williams
View 4 Replies
View Related
Aug 30, 2004
I have 3 unique numbers that can identify a specific customer. I would like to my form to locate a specific customer by using whichever parameter the customer can find. Is putting 3 seperate queries on the form the best way to acomplish this?
View 1 Replies
View Related
