Search results

It is excel vba on apple MAC os. Sorry to mention that

Hello I would like to have vba for Mac access which would have one button on click of that button the file open dialogue button would display wherein I can select multiple folders and can zip it. I don't have Mac os if someone can help me on this. Thanks

Let me check on this, will it be problem if I execute multiple insert statment once because they are in loop ?

it gives error on execute line, also I was wondering will this kind of one execution would work if there are numerous files in the folder?

I have below code, wherein I am getting error "String Data, right truncation" at line adoCmd.Execute. I have also table datatype as attached. Actually I am trying to move attachment from local drive to sql in binary format. Can anyone please guide what is wrong here. the destination file is...

adoCmd.Parameters.Append .CreateParameter("UniqueKey", adVarChar, adParamInput, 20, keyaudit) above worked as I had defined size of data type to 20 in sql and that was cause of it. Thanks

Here is the attached error.

it is string

Hello I have below code With adoCmd adoStream.Type = adTypeBinary adoStream.Open adoStream.LoadFromFile strDir + file 'It fails if file is open .CommandText = "INSERT INTO VendorFiles VALUES (?,?,?)" ' Query .CommandType = adCmdText...

I did not get you, shall I remove first one? if i do so it says it is in use can not remove

it is already there, please see attached file.

thanks but now it gives same error on .CommandType = adCmdText Dim adoStream As Object Dim adoCmd As Object Dim strFilePath As String Dim adoCon As Object Const strDB As String =...

I am getting below error 3001 "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" on line number adoCon.CursorLocation = adUseClient I am using excel vba. Sub SaveAsBinary() Dim adoStream As Object Dim adoCmd As Object Dim strFilePath As String...

I am getting below error 3001 "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" on line number adoCon.CursorLocation = adUseClient I am using excel vba. Sub SaveAsBinary() Dim adoStream As Object Dim adoCmd...

Let me try this.

Hi I have few files on my local folders, now i would like to move these files to sql server 2014 tables ( data type of destination table could be blob, nvarchar(max), varibinary(max), I am not sure what shall i opt in this case ). is there anyway that VBA from Access or SQL could do this ? If...

No Colin, it does not look like it is working, I removed all the relationship with which was refering to the question table, compacted and close all the objects. I am getting error message as attached in picture. Please advise. [please note that this is 2003 database (.mdb) and I am working it...

Hello I have one table field which was having foreign key relationship with other tables and I wanted to field size I removed relationship which it had with other tables in the database. Still it does not allow me to change the field size. even after deleting relationship with other table...

Hello Please see attached diagram, and I am getting some ambiguity while migrating this tables to sql server, even though there are primary key is there still it is giving error explained in attached picture. Please advise.

Hello I am getting below error while I am using access 2010 upsizing functionality for migrating ms access 2010 tables to sql server database. 1st error: Relationship or Constraint Failed to Upsize: Server Error 8136: [ODBC Driver 11 for SQL Server][SQL Server]Duplicate columns specified in...