Search results

Hey all, I have to write a code for my database,i have folder with files "pending Review" and a table with column "tblExcelLocation". when i run my database all the files from pending review folder goes to "tblExcelLocation" on a click of button.But,if the files already exists it should not...

Hey all, I have code working for some workers here ,who used to save excel files in a folder and my databse upload those files into database and then do the rest.I am looking for a code in vba which,on upload button matches the file in table and if the file already exists ,it should not...

hey, I am trying to upsize the access database to sql server ,i have an odbc connection and when i try to move the tables,all the data is moving except one table "tblproductinfo" i have attached the table data and error.Need Help ///thanks in advance

Thanks Paul, You always reply my stupid programming questions !! Thanks Alot That worked ,it feels so good when a problem is solved :):)

Hey Guys, I am in trouble with the shell ocmmand,i have a text box "ExcelPath Location" in which there is a path of excel file i am using below code to open the excel file but it gives an error: Private Sub Command11_Click() Dim str As String str = ExcelPathLocation.Value strPath =...

Expr 1: Mid([ExcelPathLocation],InStrRev([ExcelPathLocation],"("))(access) sqlView (SELECT Mid([ExcelPathLocation],InStrRev([ExcelPathLocation],"(")) AS [Expr 1] FROM ExcelLocation; ) I have this expression,but its not giving the value i want! I want (new1234) without brackets...

i have lotnumber column in lot table ,and excelPath column in location table, lotnumber data is the substring of excel path column in location table,so i want a query in ms access which shows excelpath against lot number ..i dont know how to create that query..need help with that:banghead:

Thankyou so VERY much .That Worked :)

I have a folder with 3 excel files ,and i want to read the files with names,and get a substring from the name of excel file,My code is working fine but the issue is when it reads the substring,it does not read the very first file ,the code is here : strFile = Dir(strPath & "*.xlsm") While...

OHHHHH ,,,Thanksssssssssssssssssssssssssssssssssssssssssssss alot!...i mean i never noticed those quotes!!@@@ Thanks again for your help.Appreciated :D

Thanks for your reply. But,now i have changed all the code and doing it with ID not with the text values.and now on the querydef it says , error :item not listed in this collection the code i am using is strParam = Combo13.Value strParam1 = Combo15.Value Set db = CurrentDb()...

I a trying to search some product from a search button and two combo boxes text values ,and on serch the vba code is : Private Sub Command4_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim varRecords As Variant Dim...

I have a query and i am trying to set into recordset ,but its giving run time error 13 (Type mismatch).Need Help With it to continue my work Private Sub Command37_Click() Dim db As DAO.Database Dim rs As ADODB.Recordset Dim SQL As String Dim currentItemNumber As String Dim PdfFileNameToStore...

:) Thankyou so much for your valuable advice.As i am new in access ,so have no idea how to deal with errors :).THanks Again

Hi there, I have been searching for this this code lon time now.I have columns coming in my resord set ,how i can display them in my subform ,my subform contains 3 columns header ,id,area and description.As i am a beginner need immediate help with this! Private Sub...

HI, i have a combo box ,and when i should select "all",this button after update code should show me all the column of table test ,but looks like for no reason the record set shows nothing and its not working ,need help with it ! Private Sub cboTaskListName_AfterUpdate() 'On Error GoTo...

Hi, I have a combo box ,whose afterUpdate function is called with an event in vba ,which refreshes the subform and call an sql query on selecting "ALL". the code is not working because the refresh code is converted from macro to vba code. I need help with this. Private Sub...

Hi there, I m trying to write this query in vba code but it is constantly giving Private Sub cboTaskListName_AfterUpdate() Dim db As DAO.Database Dim SQL As String If Me.cboTaskListName = "**All**" Then Set db = CurrentDb() SQL = "SELECT tblDiscrepancy.DiscrepancyID...

here is my code Private Sub Command37_Click() Dim db As DAO.Database Dim rsItems As DAO.Recordset Dim SQL As String Dim currentItemNumber As Long Set db = CurrentDb() SQL = "SELECT test0.item FROM test0 " Set rsItems = CurrentDb.OpenRecordset(SQL) rsItems.MoveFirst Do While...

Thank you so much !! It worked :)