Search results

  1. A

    Hyperlink replacement vba

    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.
  2. A

    Daily Wages Report

    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...
  3. A

    Sum not Concatenate

    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.
  4. A

    Question Custom Request Numbers

    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...
  5. A

    Custom autonumber with month prefix

    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 :)
Top Bottom