Search results

Yes you are correct, when we change background and fonts color in Access VBA, it affects in Excel too...

Thanks Arnel, This I know. But I was looking for module. Anyway, Thanks.

Hi, I wish if there is VBA module that could change VBA editors theme to set back color and font color. Is there?

Thanks Minty, I will try implementing your idea although I m not expert. Thanks again...

Thanks Arnel, My code is working but it is comparatively slower than your code. You code works fast. I appreciate your help. Thanks,

Now, I have transferred data from Excel sheet to local table and to transfer data local tbl to server tbl, I have written following code. Dim db As DAO.Database Dim rst As DAO.Recordset Dim rst2 As DAO.Recordset Dim fld As DAO.Field Set rst = CurrentDb.OpenRecordset("Select * from...

Arnel, I did it already. I created Identity column. I think I need to modify the codes. As a sample, I will take only 2-3 fields to transfer from excel to the server tble.

I added one additional field as ID with NotNull, Datatype Int and default value as 0 on server. Now when I linked the tbl in Access, it show updateable which previously it was not. Now how when the data will transfer from other tble or direct from Excel sheet, how an I set ID value from 1 to...

OK I will try this way....

This is I did already. Created tbl in server and re-linked in Access with all same columns that I am importing from excel sheet. The Excel sheet has 107 columns and my tbl also have 107 columns with similar names in it. But there is no PK set in server tbl. Probably PK is require to add records...

Sir, This is first time I used BE as server so I am not much expert in t-sql and even I dont have idea for what it stands for and how to use it. I know little about Pass thru in Access but never used that even.

If IsNull(Len(Dir("D:\Ashfaque\ORS.xlsx"))) = False Then DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "T_PreInterDetails", _ "D:\Ashfaque\ORS.xlsx", True MsgBox "All Job Applications Imported..." Else...

You mean instead of using imported tbl structure using DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "T_PreInterDetails" method, I will have to create new tble? In Excel sheet 107 fields are there so I kept I kept same 107 field in Access. And then how about new field ID...

Hi, I tried importing data from Excel sheet to local tbl first which was success. There are 107 fields in Excel Sheet and I have created same fields in local tbl and was importing the data successfully. Now I moved my local tbl to SQL server and trying to follow the same process of importing...

But the same db is working other pc but not at only a particular pc that has office 365. I think second option to import all object in a new blank db would be a better suggestion. Will try and let you know......

Hi, I am facing db format recognition problem. My Access db is created in 2010 and I have to install it it a laptop which has Office 365. It is producing subjected error when copied and tried to run. Any solution to this?

Thanks Runman256, This may helpful to me for post 50% of work but I need the code to connect Excel sheet on Google Drive and read I need vba code or some ideas to read google drive excel file and store in local Access tbl. Any other Idea?

Hi, I am looking for vba code lines to import data from a Google Drive Online Recruitment (Protected Excel sheet - I have userid and pwd) to local Excel in pc or direct to Access tbl and then clean the Online Recruitment Excel Sheet (at web) so that next time when I connect web Excel again...

Thanks a lot. It is working as expected. The only thing is it is fluctuating screen when changes rowsource. That need to make it smooth. But that I can manage. Thank you very much again.

User will add anther dept only at new record Sir. My only requirement is while user enter new entry at main form (by clicking New Entry btn) he will select new department and based on selected dept in combo CboAddOT, the rowsource should be changed of subform combo and display relevant emp list...