Search results

Hi, i would like a form, set to go on new record on load, Having in Header a textbox to inform reader as for " Employee Surname Name " every time is set to go around between records What i d like is form not to show anything when it opens with no records using so far =IIf("[ypalillosID]"="...

I undrestand and thank you for the complete answer. By your answer i am trying to say that by undrestanding what is going to take (my DB has many many forms) it is not easy to get in such trouble for achieving what i was seeking. That was very helpful to me

All i am trying solve is how to make things easier to a user's eyes, as for instance a user faces forms and he/she is obliged having to see combos instead of nice textboxes where there in most of times lyies a fixed value which souldnt be in a selectable to choose option for a user.. The...

Yes

Please help, I am trying to replace combo boxes in my forms, to text boxes and.. i have a particular combobox with rowsource SELECT Tbl_Courses.courseID, Tbl_CourseNames.CourseName FROM Tbl_CourseNames INNER JOIN Tbl_Courses ON Tbl_CourseNames.coursenameID = Tbl_Courses.coursenameID; then...

I wanted to accomplish a query for the case: " Every athlete needs to renew Fed's Registration Id, (annually every year), and user should be informed that it is due to renew 30 days before completing a whole year (since [FedRegDay]) - because whitout renew athlete cant compete in races- I was...

I ll reply as soon as i can thank you its close

Maybe in the true part, i should nest a second Datediff

Isaac i wrote it by mind to explain what i have in mind and i am asking whether some calculation inside the true part in above field could show instead of a simple "DueReq" indication of days as from -30 or -29 etc to 0 coming to fulfil whole one year since [RegDay]

All i imply is can the above true part of the Iif be differently calculated to show days left to one year from [RegDay] Excuse my English

Could your suggestion be accomplished in a single calculation field?

Hello Trying to have a query that its records warn when date [RegDay] of a person [athleteID] comes as 30 days or less to complete 1 year passed from then to Date() , and if so in the calculation field [RenewReg], indicate if minus 30days, the days left to complete one year, if passed year...

its GREAT!!! what have you Done??

Please try yourself in your example. It s been weeks since i try accomplish what i want. In your attachment with no deletions do you see not that when reopen db does not hold records? It making me crazy. This is your upload reopened and untouched..

I have had erased records both in tbl_times and Tbl_Races and when using correted (your form with subforms), same problem in fact there is a problem with coding in afterupdate of Frmsub_Race (attached pictures), and again when close and reopen Main form, records made using Frmsub_Time dont...

I shall erase records and try again and i let you know

I appreciate help but something happens when inserted, records dont reappear next time db opens..

Hello, i would appreciate help on my problem Having 2 subforms linked child/parent i am facing problem to have my athletes in second subform chosen by their gender selected in first subform ist subform is bound to Tbl_Races, second to Tbl_Times subforms are linked with textbox on main form...

I have tried that Larry, test it does not work.. wait if in 1st sub and in the after update event of genderID is put to requery athletesID in second sub form, with Me.Parent.Frmsub_Time.Form.athleteID.Requery , then it works... but i t has some issues though.. If athletes and times are...

These are the true conditions for selecting either male or female athlete swimmers when referring from Tbl_Times (athleteID) to Tbl_Races (depending on Gender) between record sets DLookUp("agenderID";"Tbl_Athletes";"athleteID=" & Nz(DLookUp("genderID";"Tbl_Races";"raceID=" &...