Search results

Yes. Also, I tried to create a page through Access Page wizard but it gives the option to delete the record and doesn't give the option to search a record. Any help would be great. Many thanks D

Hi I'm in the early stage of learning Ms Access. I have created a tables in access but I need to design a page where if a person wan'ts add/search the data they can do it with the buttons. Basically, I don't want to give them the Table view. Can anyone advice how do I do that? Many Thanks D

Hi Bob Thanks for the reply!!! Can I ask you where should I enter the code? Public Function fGetWorkdays2(pstart As Date, pend As Date) As Integer '************************************************ 'Purpose: Compute number of workdays (Mon - Fri) ' between pStart and pEnd 're...

Thanks for the quick reply!! Can we exclude the weekends from it?? Many Thanks D

I have 2 dates columns. Column A & Column B I need run the query and need show the number of days whose difference (A-B) is greater than 5. Currently, I'm using DateDiff('d',[Date1],[Date2],Date()). By using this, I'm getting the difference of all the dates and their records. But I only...