Search results

I know there are benefits to compacting an Access MDB file. What are there except for saving space???? Rob

anyone???

I knew that could have been the problem. I have checked that again just incase and still have this problem. This is the order that when saving on the form that I get error for null InitialDate HIVPRETEST Trimester EXP Del DOB LName FName Insurance I want : LName FName...

can someone explain to me how to use modules. Is it used if you are going to repeat code often??? how do I call on them in an onclick . Rob

I am just curious to know in a table that i have inorder I have MRN, Firstname, last name, initialvisit, and other fields below. I have set validation on those fields as is not null give an error. Now when Iput this into a form with a save button. If the user enters just the MRN number the...

the reason why I have that big if statement is becasue I am checking the 2 fields. If they have both have info or both dont have info then put a not infront that means that one of them might have a null. Which then I will test for which one. Thats why I can leave that statements out. ROb

I just found the answer but is there away to automatically hit the ok button on this error so the user doesnt see it

anyone know what this means Invalid reference to field 'form_beforeupdate' this is the code Sub Form_BeforeUpdate (Cancel As Integer) If Not ((Not IsNull(Me!HIVPOTC)) And (Not IsNull(Me!Result)) Or (IsNull(Me!HIVPOTC)) And (IsNull(Me!Result))) Then If (IsNull(Me!Result)) Then Cancel...

the only problem is this doesnt work for dates ex 10/08/1981 if I put a date in then take it out the error message that I have created still comes up. Rob

hey man thanks that works by adding the cancel event. Thanks so much just one more question. Now if the user descided to go back to one of those fields and blank it out. I want it to allow it to save it. Which means I cant test for null. Can I test no empty or blank.. I dont remeber the...

thank you

I want to run a query that looks at a date and ruturns all info for a given year. Is there away to do this Instead of searching for example 01/01/2003-12/31/2003 criteria is Between [From Date] And [To Date] I wouldl like to be able to search by typeing in 2003.

I have several fields on my form. there are 2 fields that need special attention. if one of them has info in it the other one has to have info in it. I know how to check for null then setting focus to the one I want to add info in it. I put this code in the before update on the form. But if...

thank you

when I click on the ado control on the form I want to be able to set the focus to the first field. I know how to use setfocus but I dont know where to put the code.????? Thanks in advance.

ummm I see how it would work but for me its a no go. I have this in my table (Patien): Name, DOB, Initialvisit now with the sql statement I have SELECT Patien.ID, Patien.Name, Patien.DOB, Patien.Initialvisit FROM Patien WHERE (((Age([DOB],[InitialVisit])) Between 13 And 19)); when...

I see how it works. but what is it comparing the dob to. the current day.??? See the problem I am having is I need to compare it to a date that they come in for a visit. When looking at the sql statement WHERE (((Age([DateOfBirth],Date())) Between 13 And 19)) I am not sure where it compares...

is there a way of adding to a query.

I posted this in the report section by mistake. I have a table that has name, number, address, dob, and initialvisit. I want to be able to compare the DOB to the InitialVisit which are both dates. MM/DD/YYYY. In the report I want to only show people who are teenagers >=13 and <=20. I am not...