Recent content by sohailcdc

Thanks CJ As I said, I am just trying to learn, since you pointed out, weekend I will trying to incorporate as well Usually, the place where I am working, plant mostly 24/7 other than stats holidays, summer and winter plant maintenance shutdown Based on your inputs, I guess, option 2 is what...

Hi there During my free time I try to learn Access and/or other applications and with the help of ONLINE forums I really learn a lot Anyways, Now I am trying to learn/create Company's Fiscal Calendar I am using following approach, but unable to figure-it-out how to handle this Therefore, need...

My boss just want to get rid of this from me so that he can assign me new and/or transfer his work to me lol Nutshell, I made this application for my personal use, then I made the 5 copies of same databased and used for individually for each unit Now, my boss want to give this access to other...

thank Gina As I said I am not a professional developer nor I make this application for others use (originally, I made this for my own use and I am keeping this on my desktop, but since I am using this, therefore, my supervisor know about this and he is insisting me to do so) as I said above...

Hi there, please be patience English is not my first language, therefore, nor I am technical persons in terms of explain my situation related to Access First and foremost I am not professional developer nor I have any advance level skills and or any formal education, however, based on...

Hi there During my free time I try to learn, so bear with my wish list Here, what I am trying to learn, that background of the form change its colour automatically after sometime let say 1 min or after 2 min I find the link on the web where more than 500 colour code are available, but not...

Hi there I am just trying to learn during my free time Anyways, I am trying to learn display counter I try to google but unable to find anything what I am looking for Below is my code, which works, but only problem is result shows once counting is done - whereas I am interested in upon changing...

thanks to all, it's my fault wrongly missing ' in the last "'" wrongly typed ""

Hello New to this world, just trying to learning during my free time specially during the weekend I have table [table1] which have 4 fields EMPID - primary key EMPFirstname EMPLastname EMPDOB Input box as txtempid as string I am trying to learn how I to display other field based on one...

Great and have nice day

Thanks, to all but I am still not able to get what I am looking for, I am just trying to learn how to use public function and/or variable not sure I am right or wrong What I am trying to learn, store the value from form1 and can use anywhere in other forms Here's is my situation I have two...

Thanks to all, but I basically design non-professional logic below is what I did Private Sub butcal_Click() On Error GoTo meform Dim begdate As Variant Dim enddate As Variant Dim totaldays As Integer Dim datecounter As Integer Dim countsun As Integer Dim countmon As Integer Dim counttue As...

Hi there I am totally new in VBA, just trying to learning during my free time with help you forum, I have a very basic question I am trying to use Public Function and getting Runtime Error upon execution Here's is my simple code Public Function CCname() Dim cname As String cname =...

Thanks, but I am looking for range, whereas per Weekday syntax only provide info for specific date

I am looking for Access VBA code to count number of Day Name in given range e.g. March 01, 2014 to March 31, 2014 Mon = 5 Tue = 4 Wed = 4 Thu = 4 Fri = 4 Sat = 5 Sun = 5 Thanks in advance