Forms :: Conditional Format One Field To Alter A Second Field

Jun 26, 2015

Have a continuous form with 2 date fields in each record .

If dateField1 is empty ,Then I want a way to make DateField2 Take its Place .

I know how to make things happen with conditional formatting on one field by UsingIsNull ,I have tried sending datefield2 to back.But cant work out how to bring it to front If DateField1 IsNull.

View Replies


ADVERTISEMENT

General :: Alter Field Format - Date Time

Feb 2, 2014

I need to alter filed 24-gen-64, in 24/01/64... how to?

View 5 Replies View Related

Reports :: Conditional Format Date Field For Current Month

May 20, 2014

I have a short date field 5/20/2014

I would like to set up a conditional format to format those fields in the current month. For example, this month is would format all fields with "5".

Next month all fields with "6"

In the month space.

I can't seem to figure out the expression, I know I'm close.

View 4 Replies View Related

Forms :: Assign Field With Special Format Based On Date / Time Format

Feb 17, 2014

I wanted to assign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".

So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-

I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.

But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?

View 2 Replies View Related

Forms :: Subform Conditional Formatting If One Field Has Value?

Apr 10, 2015

I wanted to use a conditional formating when in a subform the field "Field_Name" has the value "Case Status New" and then the field "New_Value" should become orange color.

I guess it can be put togheter like a formula (expression) in the Edit Formating Rule.

View 4 Replies View Related

Forms :: Conditional Formatting Field Color

Apr 16, 2014

I would like to have a conditional formating colour of green if the field contains a value like 10%..If the field has no value and is blank there will not be any background color change

View 1 Replies View Related

Forms :: Conditional Formatting On A Lookup Field List

Mar 5, 2014

My table fields are as follows:

1. Issued? (This is a lookup field with the following lists "Yes"; "No"; "NA")
2. IssueDate

I created a subform bound to the table.I wish to accomplish the following on the form:

1. If "No" is selected on the [Issued?] field, I want the [IssueDate] to gray out.
2. If "Yes" is selected, I want [IssueDate] to be required.

I set Conditional Formatting as follows:

Expression is ([Issued?]="No"), condition is disabled.

When I tested it, [IssueDate] grayed out when "No" was selected. However, when I select "Yes", it still remained grayed out.

View 5 Replies View Related

Queries :: Alter Table With Auto-increment Field?

Mar 10, 2015

I am attempting to update an oracle table using MS Access.

One of the fields to be updated is a primary key number field.

I'd like to use the autoincrement field to update that field.

My sql is:

Code:

Alter table testAutoNum Add column progid autoincrement (1001,2)

This sql nicely creates the new field in the table, but it doesn't start at 1001 and increment by 2; it starts and 1 and increments by 1.It is also creating an autonumber and I need it to be a number.

What am I doing wrong?

View 7 Replies View Related

Modules & VBA :: Creating Temp Table - How To Alter ID Field

Nov 19, 2013

I have some code that creates a table based off another table. This code works perfect but Im trying to alter my ID field and change it to an auto increment. How can I fix my code so that it alters my ID field?

Code:
Private Sub Command0_Click()
'OBJECTIVE: to build a table by extracting some fields from a main database
Dim rst As Recordset
Dim strSQL As String
Dim strSQL2 As String
Dim intCount As Integer

[Code] ....

View 5 Replies View Related

Forms :: Conditional Formatting Of Currency Field In Entry Form

May 26, 2015

I have some Conditional Formatting of a Currency Field in an Entry Form. The cell is conditionally formatted with a yellow background when the value is zero.

I now wish to add an additional condition to the expression such that even if the value is zero it will not be formatted if a specific check box is TRUE.

I have tried modifying the expression such that it reads;

[currency field]=0 AND [check box]<>TRUE.

It correctly turns off the conditional formatting if the check box is ticked, but does not turn it on again when the check box is unticked.

View 14 Replies View Related

Forms :: Conditional Formatting Text Boxes Based On Yes / No Field

Jan 8, 2015

I am trying to get the text in a couple text boxes to turn green if a certain Yes/No field is left blank.

I know the conditional formatting is working, because condition 1 and 3 are working fine (those expressions are referencing text fields).

I would like to have Condition 2 look at [DM_Approval] from the bound query and if it is unchecked, execute the conditional formatting.

I've tried all kinds of statements, but i'm starting to think that the expressions in the conditional formatting window just won't work when referencing a yes/no field.

Specifically (at the very least) i know i tried [DM_Approval]=False, [DM_Approval]=No, [DM_Approval]=0, and [DM_Approval] is null.

View 3 Replies View Related

Alter Date Format With SQL?

Jun 18, 2007

I need to change the format of a date column from Short Date to a custom format. Does anyone know how I can do that with an ALTER TABLE command in SQL? I know how to alter a column and set the data type, I just can't figure out how to set the format for the date.

View 2 Replies View Related

Modules & VBA :: Alter Table Statement To Add Field And Make It Unique

May 18, 2015

I am using the following to add a column to an existing table. How do I make this column indexed with no duplicates?

db.Execute "ALTER TABLE [BrandTBL] ADD COLUMN UPCGroupName TEXT;"

View 1 Replies View Related

Forms :: Conditional Formatting Changing Field Color Based On Hours Passed

Jan 7, 2015

I'm having a spot of trouble trying to get conditional formatting to work. I have an overview form which displays current quotes going through the system, the QuoteStartTime field is generated from the Now() command.I Would like if possible to show, 1 hour = Green, 2 hours = Amber and 3+ hours Red.

I've tried variations of
hour([QuoteStart])>1
DateAdd("h",1,[QuoteStartTime])

I've done this before with a date only field before, but working with time is taking too much time.

View 1 Replies View Related

Forms :: Text Field Format

Apr 11, 2013

we would like to enter text that is always in this format,2013 04 11 / 09:15...I have tried using the field as date, with the formatting of yyyy mm dd / hh:mm...but the records keep showing a data entry problems with this format.

View 3 Replies View Related

Forms :: Format Double Field As Long Time

Feb 17, 2015

I have recently upgraded my Access 2003 application to Access 2010. I am running into a problem when formatting a textbox to 'Long Time' that is linked to a Double type field. The error that I get is 'The value you entered isn't valid for this field. You may have entered text in a numeric field or a number that is larger than the FieldSize setting permits.'

The textbox is linked to a field (double data type) and displays as the time in long format (4:06:17 PM). When I try to change to 4:07:17 PM I get the error. I tried removing the 'PM' and the colons but the error still occurs. The only way that I can get it to work is if I use a double value (0.735405092592593). In Access 2003 the time value would display properly, allow me to change the time and then save the time as a double to the database.

View 3 Replies View Related

Forms :: Changing Format Of Field Based On String Length

Jun 11, 2014

I have a continuous form that displays data from a table. What I am trying to accomplish is to change the format of the field if the string length is equal to 11, to "@@@-@@@-@@@@-@". Otherwise if it is greater or less than 11 then no format.

I have tried it using code:

If Len(Me.FormFieldName)=11 Then
Me.FormFieldName.Format = "@@@-@@@-@@@@-@"
End If

Is it even possible and if so is my syntax correct or am I way off base?

View 8 Replies View Related

Forms :: Format Numeric Field In Forms

Sep 25, 2013

I have a table (Table 1) with a field (F1) that has a numeric value. The data in this table is imported trough an excel and is going to be updated regularly.

F1 consists of a four digit number (1234) but if the first one, two or three numbers are a zero (ie. 0033) Access only display "33". I have solved this in Querys by using: Format([Table 1.[F1];"0000").How do i use Format([Table 1.[F1];"0000") or similar when i display data from Table 1 -> F1 in a form?

View 14 Replies View Related

Forms :: Format Memo Field To Ensure That Sentences Begin With Capital Letters

Nov 4, 2014

Is there a way to format a memo field to ensure that sentences begin with capital letters. There might have been something in the strConv function, but it seems my hopes are dashed?

View 1 Replies View Related

Forms :: Format Memo Field To User Specification - RichTextBox Members Not Found?

Mar 16, 2015

I have a pop up window that maximizes and the need to format a Memo Field to users specification.

Unfortunately the Mini Popup Bar that comes up when you select text is very shy and annoying when it doesn't show up. It's Completely Unreliable.

So I thought I'll make the Controls on the form for Bold,Italic... etc but I can't seem to get the code to work.

My TextField is a Memo and I have changed the TextFormat to RichText, but I cannot use any of the commands like .SelBold or .SelColor etc.. It gives me a Compile Error: Member or Data Member Not found.

I don't understand why? Is there a Add In/Reference that I need to include?

View 2 Replies View Related

Query To Calculate Conditional Field

Feb 5, 2007

Dear all,

I have a query that is based on orders table and contains "Qty", 'UnitCost', and "ctualUnitCost", in addition to yes/no control to indicate if "SalesTax" is applicable.

I want an expression in the query to calculate total cost in one of 2 conditions:
if no sales tax then TotalCost = Qty*UnitCost
if sales tax is applicable then Total cost = Qty*UnitCost*1.1

how can I write this expression

thanks

View 2 Replies View Related

Conditional Locking Of Form Field

Feb 17, 2005

I am developing a simple database in Access 97, where users have to enter values manually into a form. There is one field called product. Depending on that entry, either field language or country would have to be blocked to avoid invalid entries.
Do you have any ideas on how to approach that problem?

View 2 Replies View Related

Conditional Formatting Based On Another Field

Mar 28, 2006

Is there a way to apply conditional formatting on a field based on the contents of another field?

For example, lets say I have the following fields

START_DATE
APPROVED_DATE
CAT#
DAYS_OPEN

The DAYS_OPEN field is automatically calculated in the query and is not a stored date.

My criteria is that if CAT# is 3, my days open should not exceed 30 but if my CAT# is 1 or 2, my days open should not exceed 60. I want to apply conditional formatting so that it turns yellow at approximately 80% of the date limit and red at approximately 90% of the date limit, otherwise the conditional formatting is green.

I know how to do conditional formatting, but no sure if it can be modified based on the content of another field.

Thanks for any suggestions.

Jim

View 4 Replies View Related

Average Of Calculated Conditional Field

Jul 4, 2007

I have a calculated field on the detail level of a report which is calculated as follows:

=Iif([BREAK]>1200 AND [LUNCH]<>0),1800-[BREAK],IIF([BREAK]<>0,900-[BREAK],0))

This calculates correctly, however when I put the following calculated field in the Group footer section of the report, I receive a "statement too complex" error message:

=1800-Avg(Iif([BREAK]>1200 AND [LUNCH]<>0),1800-[BREAK],IIF([BREAK]<>0,900-[BREAK],0))

The calculation for the Group footer works in Access 97 so I know that syntactically the statement is correct.

Can anyone tell me why this will not work in Access 2003 and provide a work around so I can get the Average of the calculated Detail section field.

Thank you.

View 2 Replies View Related

Conditional Formatting On DateTime Field

May 6, 2015

I have a form that pulls in open project information that has a datetime field called "Duetime". What I'm attempting to do is that when this datetime field is less than 1 hour away, to turn the field background orange. Also, if less than 30 minutes to actually being past due, then it would be red.

View 3 Replies View Related

Modules & VBA :: Getting Code For Conditional Default Field Value?

Jan 17, 2014

convert the following into VBA code for an Access 2007 field on a form. It is needed to create a conditional default value based on another field's category: (Note: TransType, MembershipYear and Dues are field names and are all on the form). Based on the TransType (which is really a category of membership) I want the Dues field to have the applicable default value automatically entered.

For MembershipYear > 2008
If TransType="Individual" or TransType="I" Dues=35.00
If TransType="Family" or TransType="F" Dues=50.00
If TransType="Founder" Dues=100.00
If TransType="Student" Dues=10.00
If TransType="Lifetime" Dues="" or is Null
If (TransType is Null or TransType="") and TotalPaid >0, Dues=35.00

View 3 Replies View Related







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