Search results

I have a textbox (txtEnddate) and another textbox (notebox), i want if txtEnddate is empty then display a message in notebox. Is there any wrong with the following code: Because it doesn't return any error but it doesn't do anything. If IsNull(Me![txtEndDate]) Then Me.notebox.BackColor...

Thanks Dave and Rich, its working.

Rich, no it didn't do it, For example, lets say i have a column with 4 rows...one of the rows is blank and the other 3 filled with dates, if i use "not is null" then it will not count the whole column...but what i want is to skip the blank and find the minimum for the other 3 dates.

Thank you Dave, It works but there is one problem... There are some blank fields...For the "Min", it will count the blank and insert the blank field as the minimum...but how can i avoid counting blank fields???

I think i wrote too much in the previous message, so may be you gus got confused. Ok,here is the first step that i need to do: I have a number of text boxes in a column named txtplannedStartDate. How to loop through a column(all the text boxes) and find out the lowest or the earlier date...

Some one help me please with this challenge. Let me first give you a short summary about my DB, Lets take an example, there is budgetRef(ProjectNumber), each budgetRef has 7 phases(Activities) these phases are standard, each phase has a number of SubActivities. For example, P30158 has all the 7...

I got it but its not a good way.... Thank you Any way

But how to get to this Article ID: Q109724 ?

I have a number of combo boxes in my tabular form but i don't want to show the arrow (the drop down arrow). Is it possible to hide the arrow of the combo box? if so, how. Note: I know there is enable property but i don't mean this one. Thanks in advance.

I have a form with 3 comb boxes and one subform. First combo box contains project numbers. Second combo box contains Activities. Third combo box contains SubActivities. The subform displays all the projects numbers, Activities, subActivities and planned and actual dates. When i select a project...

Thanks i set RecordsetType property to Dynaset (Inconsistent Updates)and it works. )

I have a query consists of 3 tables and one crossReference table. I built a form that display my query but the problem is I can't update and insert data in my fields and i can't add new record...It says that "This recordset is not updatable". Any help is appreciated. Thanks.

Perfect. Thats what i want ) Thanks a lot J.Windon

Jwindon, It works but I still have one problem. I got the message before i open the form or i see the first record..Is there a way that i can attach my "mdb" file?

Jwindon, We are almost there but can you explain to me this sentence: DateDiff("d", Me.StartDate, Date). what is "d" I am getting wrong numbers. what i want is for example, if the "end date" is 2/16/2002 and today is 1/29/2002 then i should get the difference and if its passed the "end...

Lawson, you are right, If the date falls at the weekend then how it can be solved...I have never done such a thing. Also, each project has start date and end date, for example, lets say i just got an alert, then how can i tell to which project does this alert belong. Any help.

I have "project number","start date", and "End date" text boxes. I want to diplay an alert, let say for example 2 weeks before the "End date". I have lots of "project number" records. For example, prj1, prj2, prj3,...Each "project number" has different "start date" and "End date"...but they can...

I wan to retrieve data in text fileds(in form2) based on passing value from a command button in form1 to form2. I have a form1 that contains several text boxes, one of the text boxes is a "project Number", for example, the project number for the first record is "P14X" and the project number for...

Thanks Jwindon it works, )

I have a form that contains several text boxes, one of the text boxes is a "project Number", for example, the project number for the first record is "P14X" and the project number for the second record is "P14XZ" and so on.. Lets say i am viewing "record 1" and the project number is...