Search results

Thanks! seem to be working :D

Hi Guys, I had a combo box on my form with multiple choices like "yes", "No" and "Maybe" and what I have in mind is that the moment user choose "Maybe", a warning window will be displayed and remind the user that the answer "Maybe" will not be taken into account. Please do advice how this can...

Hmm, is this doable? Do tell me if you guys have any idea on this. Thanks in advance

Hi there, Thanks for your input. The number of task is actually based on the number of tasks for a particular project in Task:table, for example, if you look at the given attachment, in Task: table, you have Mitsudo project which has 5 tasks under it and out of the 5 tasks, users had indicated...

Hi guys, Just want to know if this is doable, Really need some guidance here. Thanks in advance!! :)

Hi all, I had created two table, one is to track the user's progress and the other one is to track the project progress. The user will update the task based on the task assign and each task belong to certain project. Every time they completed a task, they will need to update this ticking "Yes"...

Hi raskew, I am not sure what you mean? You mean I need to download the sample data? If Yes, from where? Thanks

Hi raskew, Data type for Date_start is "Date/Time", I did not specify any format for it. Thanks!

Hi raskew, Thanks for the effort in answering my question. I am a total noob when come to programing stuff. My module name is "Networkdays"> anyway, I believe it is a problem with the formula I am using. I am using Expr1: DateDiffExclude3(Date(),[Date_Start],"17") but it seem run into error...

Hi raskew, Do you have any idea why my form still unable to calculate by business day? Do I miss out any steps?

Thanks a lot, seem to be working now. :)

wow, thanks a lot for the sample code. I have pasted it in the module,seems not working? Any idea? I am a noob when it come to programing, so pardon me if my question sound dumb

Hi there, Just one more question. If let said the user unclick the yes/no field, are there any way to erase the date automatically? Thanks in advance

Thanks a lot, seem to be working. How about if I want it to countdown based on working days only? ( Mon-Fri). In excel, we have something like Networkdays( a,b), how about Access?

Hi DCrake, How to use this function and always compare it against today's date? For example, Day_Due: DateDiff("d",[Date],[Today_Date]) So what should I put in the column for Today_date? In Excel, we can use simple formula such as =now() for today's date but what about Access? Thanks in...

Hi all, I need to do a simple countdown for number of days left from the due date for a task. Anyone know how this can be achieved using query? Thanks

thanks, this look great :)

Hi all, this might sound an easy question to most of the expert out there, but I have a hard time to do this as I am a total noob when come to programing. I have a date field (DateSent) that I want automatically filled in when information in another field (SentDone) in another table is...

Hi guys, any idea or solution? :(

Hi John Big Booty, Thanks a lot for your suggestion. Hope you will bear with me cause of my near to 0 level knowledge in programing. I have another question, as I have created a frontend form that will open the task form and it contained the following code. Private Sub...