Search results

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

Hi Guys, Thanks for all your Replies.. I got the solution db.Execute " select * into New_Tbl from Tbl_Nme where invid in (" & Text63 & ")" I changed the property of the textbox enter Key Behavior from default to new line entry. Manually i had ended each line with comma .. Thanks for the...

Hi, Import the excel file using the docmd.acimport, and u could write a appending query to insert the data to your main table.. Or rename the excel headers to your standard after importing the file. Regards Kumar

Hi, May be this file from the link could help me.. just a suggestion. https://docs.google.com/uc?export=download&id=0B8qpusIRMN_ecEQwa3V6bjZQYUU Kumar

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

I got the Solution...... Copy and paste the same code used for searching the primary textbox. on change Event to the same country name text 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...

I want to use it against a column.. not a "Hard Coded" value "Public Function Split(ByVal InputText As String, _ Optional ByVal Delimiter As String) As Variant ' This function splits the sentence in InputText into ' words and returns a string array of the words. Each ' element...

Nope its not working i checked with the Function...can u suggest any other Method

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

This Query Can be used to distinguish the items ... suppose if u are working on huge database which contains only engineering items in that there might be some medical items so if we get some keywords for it ... then easy to flag it off and remove it

I got the Solution .... select * from t1, t2 where t1.STRING like '%' + t2.KEYS + '%' update t1 set validate='found' from t1 inner join t2 on t1.STRING like '%' + t2.KEYS + '%'

I got the Solution .... select * from t1, t2 where t1.STRING like '%' + t2.KEYS + '%' update t1 set validate='found' from t1 inner join t2 on t1.STRING like '%' + t2.KEYS + '%'

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

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

The problem is that i am automating it in a click of a button in the Form.so i need this query ..is there any other way to write it. because there are 1000's of records to be updated to the valid uom so only.

Now it might be easy to read "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 LIKE '*Centiliter*','EA', UOM LIKE '*Day*','DAY', UOM LIKE '*Dispenser*','EA'...

Now u don't need a guide dog to read "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 LIKE '*Centiliter*','EA', UOM LIKE '*Day*','DAY', UOM LIKE...

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

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