Validation Text For An Expiry Date On A Credit Card
Basically, i have a field where the expiry date of a credit card is input, but i want to set an input mask so that it loks something like this:
MM/YY but i cant find a way of doing this!
I then have validation text which makes sure that this value is either equal to or more than todays date! this looks like this:
>=int(now())
So the input mask has to accept this validation...
If you could help, i would be very greatful!
Cheers
View Complete Forum Thread with Replies
Related Forum Messages:
Date Expiry
Hi I am doing a date expiry query which has worked for one of my other queries i have copied the same criteria for another table but for some reason it does not work now Below is the SQL i am using SELECT Computers.[Machine ID], Computers.[Machine Type], Computers.User, Computers.Department, Computers.[Installed Applications], Computers.[Serial Tag], Computers.[OS Installed], Computers.[Pc Brought] FROM Computers WHERE (((Computers.[Pc Brought]) Between DateAdd("d",30,Date()) And DateAdd("d",-30,Date()))); I have 3 records which are within the criteria but for some reason i do not get these. Any idea why this does not work but works for my other query Many thanks
View Replies !
Expiry Date (edit)
I have a issue date and an expiry date feilds, the below script in my query is to automatically increase the date by one year, this works fine but i would like to be able to back date the script if necassary. i have checked the properties and the field is not locked. but it wont let me change the date. any ideas Expirydate: DateAdd("m",12,[Issueddate])
View Replies !
Expiry Date In Access
Hello, im new to this forum, and i need some help fast. I have a database which is a list of all of member with some information and an expiry date for there membership. What i would like to be able to do is run a query and for it to search a table and give me the names of the people whos member ship has run out or is going ot run out within a month of the query being run. I have tried several things already but access isn't realy my thing, i do Visual basic .net . If any one has any ideas about how i could sort this would you please be able to respond, thanks in advance!
View Replies !
Receipts/Credit Control
Hi, I am currently building a database which holds information on insurance policies. Each policy holder has the option of paying their annual policy either monthly, quarterly or annually. At this stage I won't get too in depth, but I have built a table (TblReciepts) which the User enters each receipt as they arrive. I would like to be able to match off each receipt against the outstanding balance on a realted policy, in this instance the policyholder should give their policyno as a reference in the receipt so that is where the relationship should be. Can anyone suggest the most effective method of allocating a recipt to the outstanding balance in the table (TBLPolicy) Regards
View Replies !
Checking Credit Limit
Hi, I'm trying to do up a database for a furniture company. I used Northwinds as a guide and made a similar Orders form. However, I need another functionality which Northwinds do not seem to have. I want to check whether the currect Order would cause the customer to exceed his credit limit. WHAT I DID For this, I made a query to find the amount any single customer owes to date and the amount that he can still borrow(creditlimit-amountowed+amountpaid). I then made a button which launchs this query. PROBLEM The problem is I want when i click this button, the query prompts me for CustomerID, which i have to key in again. Then, it launchs the datasheet showing me the credit he would have remaining if this order went through. It would be better if I do not need to key in his ID again, since it is already on the form when i keyed in the Order. Further, it would be much better if I could get the button to display APPROVED/REJECT(postive/negative balance) and also display the amount of the remaining credit. Sorry for the long description. Thanks for reading and please let me know if I missed out any crucial details.
View Replies !
Credit Code Get No Return ?
Can some one help me with this code, I get no return, ??? . Private Sub cust_credit_score_1_AfterUpdate() If [Forms]![Customer Form]![cust_credit_reply_1] = " [Bad Credit]"Then [Forms]![Customer Form]![cust_credit_score_1] = 5 ElseIf [Form]![Customer Form]![cust_credit_reply_1] = "[PoorCredit]"Then [Forms]![Customer Form]![cust_credit_score_1] = 10 Else [Forms]![Customer Form]![cust_credit_score_1] = 15 End If End Sub Thank You For Your Help Johnny C.
View Replies !
Using Form/subform For Sales & Credit
Hi, I have a table with pk- Index that stores customer details. I have a second table that stores the items sold, description, barcode number, sale price and discount. On the main Invoice form, that is linked to qrySalesInvoice, the customer records are displayed/updated by telephone operator. In a subform that is linked via Index, the sales details are displayed for that invoice. This works well, but we often need to credit one or more items. Business practice dictates that we cannot amend the original invoice, so we need the credit to be raised as a new record, but as negative values. Before I split the sales detail into another table, there used to be 10 sales fileds that were stored in the same table, and using code borrowd from the forum, I worked out how to copy the invoice, add "CR" to the invoice number and multiply all values by -1. But using the subform method I am lost as how to proceed. I have gained so much from this forum in the past, and for that Many Many Thanks. Regards dazadd
View Replies !
Date Validation
Basically i have a booking system and on certain days i need to allow an "extension", to do this i am using a yes/no and a check box. I need to creat a validation rule so that the box is only tickable if my Event_date field is a friday or saturday. Do i need to use something like Weekday(Date()) = ?
View Replies !
Date Validation
I want to verify that the [#Closed Date#] is not less than the [#Initial Date#] in a Form. =IIf([#Close Date# <#Initial Date#],"Error in Date",[#Close Date#]) This does not work. What do I need to do to prevent this kind of input error?
View Replies !
Text Only Validation Rule
i need some help with a validation rule, i need a rule that permits only A to Z characters of any length. i searched but i could only find rules that allows A to Z but of a fixed length. thanks ashkan
View Replies !
Text Box Validation Question, Please Help!
At present I have existing data being displayed in text boxs. My requirement is to be able to view this data but not be able to edit it.(ok just lock the field) but the problem is that I need to be able to add new records and thus be able to input data into the text boxs which wont be allowed if it is locked. So basically not allow editing to existing records but allow new records to be added. Not sure if that makes sense, it seems like some sort of validation issue, can anyone help. Cheers
View Replies !
Date Validation In Pop Up Box Of Form
Hi guys i had developed report which, pops up form to pass on info to generate report. in that pop up box i have StartDate and EndDate. The start date should not be Null The end date should not be Null and greater than start date. otherwise through message. Can anyone help me Thank you
View Replies !
Date Validation In Pop Up Form
Hello guys I had developed report which, pop up form and i have StartDate and EndDate in form the MiniCalendar is use to input date in these. Now i want to validate both dates StartDate should noot be Null EndDate should not be Null and less than StartDate I searched for similar information for help. couldn't find Can anyone help me Thank you
View Replies !
Date Base Validation
I am a doctor working in Sri lanka wanting to use access to make our clinic work faster. Only fields required are clinic number (Unique), patient name and last clinic date. What i want is 1. In the form when i enter the clinic number the name should come up where i need to confirm to proceed. 2. Once a patient has come to the clinic that clinic number cannot be entered till 4 weeks are past! I tried and tried to write macros or vb...(i'm a novice in these) but failed. This looks simple though. Can anyone help? any suggestion welcome. ps:- this is a charity work. i'm not earning money from making this database!
View Replies !
Definiing Validation Rules/text In Vba
Hi, I have the following code which adds text and number fields as required, but I need to add validation rules and text as well within this code, but have no idea how to do this and have not found much help on the net.any help appreciated...tan Dim db As Database Dim tbl As TableDef Dim fld As DAO.Field Set db = CurrentDb() Set tbl = db.TableDefs("4WeeksFollowUp") Set fld = tbl.CreateField("text", dbText, 30) 'for text - 30 is field length Set fld = tbl.CreateField("CO3", dbLong) 'for number tbl.Fields.Append fld
View Replies !
Verify Date Validation Rule
I'm sure this is on the forum somewhere but have searched and searched... and had no luck. I want my date feild to be set to enter a date no more than 2months in advance but a minium of a week in advance. I have done this lol week(1)<"">month(2) I don;t actually have a clue, do you use "" to represent the value? also how do i do this date verify thing :P. Thanks in advance
View Replies !
Date Validation Gives Uncontrollable Error
I have code in a BeforeUpdate subroutine of a text box to validate the date. The user can choose to keep or discard the value but the warning only appears if the date is in the future or at least a month old. This is my code: Private Sub txtDate_BeforeUpdate(Cancel As Integer) Dim dtCurrent As Date Dim objResult As VbMsgBoxResult If (Trim(txtDate) = "" Or IsNull(txtDate)) Then Exit Sub End If objResult = vbYes dtCurrent = CDate(txtDate) If (dtCurrent > DateTime.Date) Then objResult = MsgBox("This date is in the future. Are you sure you wish to leave this value?", vbYesNo, "Warning") ElseIf (DateDiff("m", dtCurrent, DateTime.Date) > 1) Then objResult = MsgBox("This date is at least one month old. Are you sure you wish to leave this value?", vbYesNo, "Warning") End If If (objResult = vbNo) Then Cancel = True End If End Sub It works fine when I answer "Yes" but if I hit "No" I get this message: The value in the field or record violates the validation rule for the record or field. This control doesn't have a validation rule. In fact, there are no validation rules in any of the controls on this form nor on any of the attributes in the control source (table). The date is a required attribute of the table though. I can't hide this extra error message by turning off warnings because it happens after I exit the subroutine, so I wouldn't be able to turn the warnings back on. I also can't trap this error because it occurs after the subroutine ends. If possible I would want the text box to be cleared and be focused if the user selects "No" to discard the date.
View Replies !
Format For Validation Rule On Date
I have a date field in a table which is Short Date with an input mask of 99/00/000;0;_ I do not want (for reasons too complicated to go into here) to put this as a required field even though it is a required field (makes sense from my end!). If I set Required Field to "No" what format can I put in the validation rule field so a message (from my validation text field) comes up if the field is left blank??
View Replies !
How To Make Validation Text Give Different Error Messages
In of my tables called Employee Payroll, I have several earnings fields, and in a previous post I mentioned that I have implemented a validation rule for them which is £2.50 or £2.75 or £3.10. I have also used an error message in Validation Text to help the user if they enter an invalid value. How can I change this message to reflect what the user types in? For example, if they enter an erroneous value like £9.34, the error message would say, "You have entered an erroneous value" or if they type an extreme value like £3.40 or £0.01, the error message would say, "You have entered an extreme value". I understand that I would need to state when the data becomes erroneous and when it becomes extreme- so I thought, anything above, £4.00 should be erroneous and any negative values too. Extreme data would be anything between £0.00 and £3.10. Would I need to use some kind of code in VBA? Thanks
View Replies !
Converting A Text Date String To A Date For Calculations
Hi there. I'm just jumping into Access and have the following question. In my Purchase Order Table, I have a date field calcualated as text, i.e. "01/12/04". I need to convert this to a date format in my queries so I can do calculations, i.e. 01/12/04 - 01/05/04 = 7 days. Can someone help me with how to convert this text date to a date format. Sorry if this is an easy question. - AJS
View Replies !
|
TRACKER
