Search results

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

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

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

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

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

Hello I have ms access db which has complex relationship between tables, and there are above 100 tables in the database, the relation between tables are very much complex ( I mean in terms of referential integrity ). I would like to migrate ms access tables to sql server with referential...

Hello I have upsize backend access db to sql server, now and then again linked back the tables as connection string to the front end access db everything works ok and tables are now being linked very well. Now question is that when I had access db as backend and had them linked in access db...

Hello I am upsizing ms access db ( access 2003 ) with sql server "version Microsoft SQL Server 2014 (SP2-GDR) (KB4019093) - 12.0.5207.0 (Intel X86) Jul 3 2017 02:37:05 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition on Windows NT 6.3 <X64> (Build 17134: ) (WOW64) "...

Hello I have a database which has been linked odbc table in the database and database takes lots of time to open and view report etc. What would be best approach in this, does linking odbc table from sql server makes it uneasy and hampers performance ? what alter solution would be done in this...

Hello I am running some function from autoexec macro using run code command and specify function name of vba, now this runs on scheduled activity I would like to close the database when program finishes with the activity. I tried in vba, application.quit but it does not work and gives me error...

Hello I have one database which is runs every week from windows scheduler to perform some import functionality from CSV files. However I would like to run one another activity which should be done in every six month ( twice in year ), this is also import functionality. I was wondering how...

Hi I have below code where Sub compareCSV(filename As String, tablename As String, deletetablename As String) Dim rs As DAO.Recordset Dim file_number As Integer Dim raw_line As String Dim csv_line As Variant Set DB = CurrentDb() file_number = FreeFile Open filename...

hello I am using below code to do csv import DoCmd.TransferText acImportDelim, tableName:="tbl_Basic", _ FileName:="C:\Download" & "CS" & getMonth & "" & CStr(getYear) & "\PILOT_BASIC.csv", HasFieldNames:=True itdoes works well but also adds one extra column in table tbl_Basic at the end...

If RecordFound = False Then DB.Execute "INSERT INTO tbl_DeletedBasic ([UNIQUE ID],[FIRST NAME],[LAST NAME],[STREET 1],[STREET 2],CITY,STATE,[ZIP CODE],COUNTRY,REGION,[MED CLASS],[MED CLASS],[MED EXP DATE])SELECT * FROM tbl_NewBasic where [UNIQUE ID] =" + field_value End If I am...

I would like to import CSV file into MS access using VBA, this import would import new records from CSV ( with unique ID ) and delete the records in the destination access table which is not there in incoming CSV. ( by Unique ID ) For example if table in access has records unique ID = A232122...

Hello I would like to encode incoming url to base 64 if it contains query string ( i.e after ? mark parameter ) as enrollmentnumber" okay so incoming url would look like this index.php?enrollmentnumber=1234 if incoming url contains enrollmentnumber then convert anything after question mark (...

Hello I have been given some parameters like minx and miny axis for mininum and maximum and have been told to find out longitue or latitude out of that. Could anybody please tell me how to find out longitude or latitude for given four parameters, is there any formula or is there any api i...