Search results

  1. K

    Convert excel to Pdf

    Hi All, i need a access vba code on click of the button i need to perform the below task I have a folder in which there are many excel files. I want to covert the all the excel file to pdf particularly only the sheet2 and sheet3. The filename of the pdf should be as same as the workbook...
  2. K

    Parsing Multiple Values from a Textbox

    Hi All, I have a form in which the user has the privilege to download some data from the table. the user will paste some of the numbers to the textbox from the excel in order to download the specific data. i need to write a query to parse the textbox using the in condition I am attaching...
  3. K

    Filtering the List box

    Hi All, I am using a form in which i am filtering the results in the list box based on the textbox value. I am dynamically switching 3 row sources for the list box. My Need is that the results produced in the listbox should get filtered again when typing in the second text box i.e based o the...
  4. K

    Splitting

    Please Find the Attachment .. The Column Values Should get Splitted..
  5. K

    Searching word

    Seraching keyword in a string ..Please find the enclosed attachment
  6. K

    Search Word

    Searching a Keyword in the string..Please Find the Enclosed Attachment Regards Kumar
  7. K

    Case Statement

    Hi all i am not able to run this query in the Form i am getting run time error complex query like that my query is "Update UOM SET VALID = SWITCH(UOM LIKE '*Bag*','BG',UOM LIKE '*Basket*','EA',UOM LIKE '*Bottle*','BT',UOM LIKE '*Box*','BX',UOM LIKE '*Carton*','CN',UOM LIKE '*Case*','CA',UOM...
  8. K

    Case Staement

    Hi all i am not able to run this query in the Form i am getting run time error complex query like that my query is "Update UOM SET VALID = SWITCH(UOM LIKE '*Bag*','BG',UOM LIKE '*Basket*','EA',UOM LIKE '*Bottle*','BT',UOM LIKE '*Box*','BX',UOM LIKE '*Carton*','CN',UOM LIKE '*Case*','CA',UOM...
  9. K

    Duplicating

    Hi All, I have 2 Columns MFGID and VENDID. where ever MFGID is Null the Corresponding cell Vendid should get updated and VICEVERSA. on the Clik of the button in the Form it should get updated . i have enclosed the attachment of it.
  10. K

    Duplicating cells

    Hi All, I have 2 Columns MFGID and VENDID. where ever MFGID is Null the Corresponding cell Vendid should get updated and VICEVERSA. i have enclosed the attachment of it.
Back
Top Bottom