Search results

Hi, I am looking to write the .xlsm binary file contents to a varbinary SQL Server column and are thinking to use Access VBA to read the .xlsm binary files and transfer the content to SQL Server for storage... :) Thanks

i have a database which is connected to sql server,this database reads the excel files paths from a folder and save them into the database... But i am wondering is there any way from vba that would read all the files (.xlsm) from a folder and save them into sql server (not just the path)! and...

any body ?:banghead:

I have moved my database to sql server, but a memo field which should be unique ,when goes into sql server does not have unique records..I tried using this code CREATE UNIQUE INDEX UIX_YourIndexNamheHere ON dbo.tblExcelLocation(ExcelPathLocation) WITH (IGNORE_DUP_KEY = ON); but its of no use...

code worked,forgot to write down the database name in connection string! ....

I have code for calling stored procedure with parameters,which is as follows Dim qdf As DAO.QueryDef, rst As DAO.Recordset Dim IdValueToProcess As Long IdValueToProcess = 221177 ' test data Debug.Print (IdValueToProcess) Set qdf = CurrentDb.CreateQueryDef("") qdf.ReturnsRecords = True...

oh yes that worked ..just created a new check box and set the control source to the field of the table...but i am just wondering that i tried that before ,but it wasn't working! lol.Thankxx alot

I am trying to call a stored procedure from access ,but it is giving me this runtime error : 2147217900 Syntax error or access voilation I am doing this first time so i dont know about how to pass parameters (IN and OUT).. My code is Public Sub createDataToAnalyze() Dim objConnection As...

columns datatype

Hey, Thanks for replying my post! I have a sub form which contains the checkbox,everytime the form loads the user should be able to check/uncheck the checkbox! checkbox is a field coming form table and is updated after the user check or uncheck,the same check box from the same table on another...

?????????????????????????

i just moved my access databaseto sql server ,but the check boxes are not working any more in access and the values of sql server linked table field is showing up as -1 and 0.How can i enable my check box field on form? Any Idea?

i am trying to open an excel file from a location,but it gives me an error "cannot open specified file", but when i open the file from the original folder it works fine. The code is also working fine with other files.but its just this file which is giving error! Any ideas?

new statment and its working :) SQL = "update tblExcelLocation set LotVerifiedDate = Now, LotVerifiedBy = '" & Replace(str3, " '", "''") & "', Comments ='" & Replace(str4, "'", "''") & "' WHERE LotVerified = true And ID = '" & Replace(str5, " '", "''") & "'"

OH actually,the problem was in my syntax SQL = "update tblExcelLocation set LotVerifiedDate = Now, LotVerifiedBy = '" & Replace(str3, " '", "''") & "',' " & Comments = Replace(str4, "'", "''") & "' WHERE LotVerified = true And ID = '" & Replace(str5, " '", "''") & "'" i had to add '" &...

thanks alot for ur guys help. i mean this is so cool when ever my mind is not working i just post a thread and go for a tea break :) ,problem get solved before i come back !! Thanks alot and i always forget to write the debug.print line .....that worked :)

can anybody see the problem with this code!??@ Run time error '3078' The microsoft access database engine cannot find the input table or query 'false'.Make sure it exists and that its name is spelled correctly. Set db = CurrentDb() Set ctl = Forms!frmVerifiedBy.Form!LotVerified...

WHAT?i just need to do this ! i was getting mad by writing alot of codes lol,it was so easy to do ....I am so :confused: Thanks alot for your help :) Appreciated!

Well,that dosent matter if files get deleted from targetfolder,it should still be there in db ,and i managed to add all files in db and i just dont want to create duplicates! Actually i am stucked in a problem,my supervisor wants it this way : Every time a user click the button all file paths...

Yes exactly,m glad you got my question :D