Recent content by abusaif

I think I didn't cleared my point. The sheet I have hyperlinked contains 30+ hyperlinks to a folder with name "300" and the same contains subfolders "invoices, lpos, grns, etc". 300 is an account ref. So now if I create a folder 301 with all the subfolder, I will duplicate the current sheet for...

Hi, I have an Excel sheet with hyperlink to a folder now each folder has it's subfolders also and they are also hyperlinked from same worksheet. I.E. "c:\desktop\myfolder\300\subfolder1" I want a vba code to change only "300" to "301", rest will remain same. Any idea.

Thank you very very much dear, really it worked. :):):):) boss can you help me further on inventory issues?. Once again, i am gratefull god bless you

Thanks a lot Alan form consideration but I am afraid to say that its even not working because as we append next days records its not showing the desired result. Just try on Attendance status as "A" instead of "P" in any record and you will come to know that its not taking any effect. Waiting to...

Hi everyone! I have two tables in my database tblEmployee and tblWages. As it is understood that first table contains initial data of Employees and the second their daily wages. I want to design a report as it is attached excel wb. A part from their complete wages details and a part is based on...

Sorry! I am using access 2010. Thanks

Hello all, I am trying to add values of two fields in a query but Total:sum([value1]+[Value2]) is only concatenating these two fields, where as I want to add them.

Dear Beetle! Thanks alot, and Yes I do have a date and time fields in my table. Also your question is attractive. (Would it be possible to create an order number with all three ie. Year Month and Number, if your answer is yes then my format would be Jan-0001-2012 )

Hi all, I was wondering if could tell me about creating the custom Request number as follows: Jan-001, Feb-001, and so on. Explaination: My number contains first three Characters of the the current month and after hyphen requisition starts. To be noticed that we do create more than thousand...

Hi there, In a database I want to create an autonumber with prefix of first three letters of month i.e. Jan, Feb etc. Can anybody help. Best regards to all :)