Date Base Validation
Nov 25, 2007
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
ADVERTISEMENT
May 3, 2006
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 6 Replies
View Related
Feb 15, 2006
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 2 Replies
View Related
Mar 22, 2006
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 1 Replies
View Related
May 12, 2006
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 1 Replies
View Related
Jun 5, 2006
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 3 Replies
View Related
Apr 24, 2005
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 1 Replies
View Related
Dec 1, 2012
I have a table with 2 field:
1. StartDate (format : Short Date)
2. EndDate (format : Short Date)
How can I validate for field EndDate must occur after StartDate using Validation Rule?
View 2 Replies
View Related
Oct 12, 2013
I need to restrict data input to the following: "09:00" Or "11:00" Or "13:30" Or "15:30"
This rule works when the data type is set to text, but not on Date/Time with short date set as format
How to get a Date/Time type to accept only one from these four values.
View 2 Replies
View Related
Nov 20, 2005
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 1 Replies
View Related
Oct 12, 2013
I need to restrict data input to the following: "09:00" Or "11:00" Or "13:30" Or "15:30"
This rule works when the data type is set to text, but not on Date/Time with short date set as format
get a Date/Time type to accept only one from these four values.
View 4 Replies
View Related
Oct 2, 2014
If a new record is created, insert date only if customerID is not null
Private Sub Form_Current()
If "CustomerID", "TblDietPlan" = <> 0 Then
If Me.NewRecord Then Me.MealDate = DMax("MealDate", "TblDietPlan")
End Sub
View 1 Replies
View Related
Dec 6, 2006
I have a theoretical solution to making a basic form for an Access Database, but how can I create a form from the VB IDE?
The toolbox cannot be selected from the dropdown menu.
I have 3 small tables in the database and am trying to create a form which will enable me to update a total on one of them, but as I say I can't even make the basic form, let alone program it.
Please advise.
View 7 Replies
View Related
Jul 11, 2006
Hello all,
I am a new registration chair person for a small convention for 200-250 persons.
I would like to set up a database that I can access to print out address labels and name tags, by selected specific cells or sections.
Is there a way to do this with a Microsoft Database or Spreadsheet programs?
Any help would be appreciated
Thanks
Leneda
View 2 Replies
View Related
Mar 22, 2007
Hi people...:)
I create a form with 2 buttoms
The first running in VBA and the second In MACRo
Why the MACRO buttom don't work?
Thanx in ADVANCE...
Johann
View 4 Replies
View Related
Dec 13, 2007
I am just beginning to design a small data base, where end users will mainly use an Access Form to search and view data.
The (lab) data will be arriving to our group occasionally over the next 2 years, and will be put into an Excel file (formatted the same, each time). The new data could be appended on the end of a master file...so I could link just one file to a table in Access. I need to build a Form, based on this data.
But, I am not sure if I should link the file from the beginning (since I've read that I cannot change data types or field sizes, if I link)....
Maybe I should import one existing file, manipulate the table parameters as needed, then design my Form....then link later?????? :confused:
what would you do in this situation?
thanks!
View 6 Replies
View Related
Oct 29, 2004
I am very new to Access, I do work for different companies inputting data.
I usually use excel and then I have to retype the information into another database.
One of my companies is a school. I have to print certificates when the class is complete, but what I'd like to know is,
is there a way I can take the names of the students and using Access just have the names appear on the certificates without having to retype all of the names individually?
I would appreciate any information you can provide for me, this sure would save lots of time.
I hope I explained my question clear enough.
Tim
View 2 Replies
View Related
Jul 6, 2005
(this is a repost )
I will skip the basic intro of "Hi im new to access and i dont know.."
anyways, what I am trying to search for and I dont know what Im looking for is this.
Q1) I would like to be able to open a zip file, read the NFO/txt file from within and import certain areas of the NFO file,the NFO file of course is layed out with ascii art but there is a predetermined area where certain info is obtained. for example: I would like to capture/import the URL, testers name, date avaliable, zip file name.THEN the text imported would be written to the database. It would be nice to figure out how you go about importing certain lines but im not sure how to ask the question and find the answer the right way. ie...(ascii art found here http://www.ascii-art.de/)
-= I did search import text and get text and didnt find what I was looking for=-
Q2) How do I write to an ascii file/nfo/txt using access, there is a template or a layout that is pre done,and i need certain fields filled out, just like they above layout.
thanks for all your help, you guys are awsome, and keep up the good work!
View 6 Replies
View Related
Aug 2, 2005
I am looking to basically update the hyperlink base every time the database is opened to be the folder that the database is currently in.
We are trying to make the database and supporting information portable, so that people can copy the entire folder anywhere on their computer and all of the links will still work. I can't put all of the info in the database because we are already pushing the size limit.
I would like to keep it from getting terribly complicated, as others will have to update this database with more info in the future and make the links themselves.
If there is a better or different way of getting the same result without going through the hyperlink base, that is fine.
Any help would be appreciated.
Thanks.
View 14 Replies
View Related
Nov 8, 2005
I want to create a new data base from an existing one in Microsoft Access. I want to use all the fields but not the data. Can I do this? I also want to keep the form that I created. Can anyone give me suggestions? Thank You!
View 1 Replies
View Related
May 21, 2007
hi i want a call out database with a calender with blocks in to represent slots booked and free, with a form with time start, duration (default 60mins) address, work to do, and milage. and the a report for the customer to sign. i have tried for about 6 months with different ways and means, to no aval, it would help if i had som knowledge of vb programing, ect, i have basic knowledge of access, eg add data, search data, and reports. please can someone helpme design one, as i would be very greatful, thanks in advance
View 2 Replies
View Related
Jun 3, 2007
Hey,
I'm from Portugal, i need asap a Access DB demo - example about a DB that controls Hotels reservations.
Is there anyone that can help me?
My mais is E-Mail address blocked: See forum rules)
Many thanks
View 1 Replies
View Related
Jan 2, 2006
Does anyone know of a simple database for investment tracking. Basically, investment names, buy and sell dates, and return info?
View 1 Replies
View Related
Jan 13, 2006
Hello All,
So much has been discussed on the main boards about the techniques available to solve technical problems.
When you read books on data base design; much is discussed on the structure of databases and much more is left out concerning how people actually work. A properly designed data base enhances work flow and changes workers bad work habits into useful and efficient ones.
My primary market is emerging small businesses. Typically my customers have been using spread sheets and Quick Books to keep track of ordering, scheduling, resource allocation, and accounting.
As you can imagine it’s a disaster. Individuals in the company have spent much time working out their problems in Excel. This poses a real challenge, many of the user are very emotionally attached to the existing non-system, and they are often determined that the “new database” will function in the same way as their tried an true spread sheets.
So to open the discussion.
I’m curious. What do ya’ll do to ameliorate this and what is the general theme you prefer when creating a system for people that have never had one before?
View 3 Replies
View Related
Feb 5, 2006
When pressing F11 to access the data base window, somehow I have docked it in an awkward position on the screen where as the top of the box containing the minimise, maximise and close button are not visible, how can I drag the data base window to the position I want i.e in the centre of the screen? :confused:
View 4 Replies
View Related
Mar 25, 2006
I am trying to create a database to create a purchase list of parts for a final assembly. There are several subassemblies that make the final unit. There are also subassemblies within subassemblies.
I want to be able to create a list of parts for purchase for the completed unit.
I have a table of part numbers that assigns part numbers to parts as ewell as subassemblies. in this table there is field that designates what type of part it is, System, assembly or base part. I am trying to query the "system" to get a quantity of all base parts contained in it. The feils in the table are part number, part name and what type of part it is.
I am having trouble with the queries or what should be in the table.
View 3 Replies
View Related
