Search results

Thanks Gasman,:) I tried with my code first and not able to sort it out as per my requirement. Then I read your code...it is lengthy and I assume that it is systematically presenting data from table to msg body in a special format. Some of the block of code I understand and some block of code...

Wow...its plenty of code lines....Need to go thru all to understand step by step as I need few parts of it. Anyway thanks Gasman.... I will revert back with answer.. Ashfaque

Thanks, Is this txt file format?

I want my query result to appear in my email in a form of formatted html table using this code. The email is being generated but query data is with attachment and not in the massage area. Dim strEmailSubject, strEmailText, olNewEmail As String Dim strMailList, StrCC As String StrCC =...

Thats the correct point you catch CJ.....Thanks, So what is the solution to this...any alternate?

Thanks CJ, gemma-the-husky, Gasman.. Problem still persist 1. My both FE and BE and in same drive "D:\Ashfaque" & BE is Access db 2. Thinking that PWD BE may not be suitable so I removed password of my BE 3. Only single user is using at the moment. No second copy has been made or in use. 4...

If connected all tables manually, there is no prob at all. It is refreshing thru this code. What I was thinking in case if the BE place is NOT changes and from FE we deletes all linked tbls then while opening FE it should automatically Re-Link all tables from BE into FE. Anyways, thanks a lot...

Doesn't show any error...it is passing from each line to downwords and finally msg appearing "Linked All Table From BE" but in fact nothing relinking..

Strange... Even I remove all the code simply using following code to link the table it provides Run-time error "3265"..Item not found in this collection... CurrentDb.TableDefs("T_BankAccDetails").Connect = _ "MS Access;PWD=06031995;DATABASE=D:\Ashfaque\GREC_BE.accdb"

Yes I tried removing password of BE and executed the code keeping PWD="" in code....nothing happened..

Immediate window shows: [MS Access];PWD=06031995;DATABASE=D:\Ashfaque\GREC_BE.accdb [MS Access];PWD=06031995;DATABASE=D:\Ashfaque\GREC_BE.accdb [MS Access];PWD=06031995;DATABASE=D:\Ashfaque\GREC_BE.accdb [MS Access];PWD=06031995;DATABASE=D:\Ashfaque\GREC_BE.accdb [MS...

Also below code connecting NO tables. No error reporting too. Option Compare Database Option Explicit Const LnkDataBase = "D:\Ashfaque\GREC_BE.accdb" Const DBPassword = "06031995" Sub RefreshLinks() ' 'Sub relinktables() 'Routine to relink the tables automatically. Change the constant...

Thanks, I have NO tbl in FE and trying to link all tbls from BE to FE.. I tried even your code in given link but not linking.

Hi, I am relinking Access tbls from BE to FE both are Ms Access db but while executing below code , I am receiving "Run-time error - 3219" on line "tdf.Connect = strConnect" in below tbl Relinking code. Dim strDbFile As String Dim strPassword As String Dim strConnect As String strDbFile...

Anyone else can help ?

Do you think I did not do it?

Gasman, Thanks for suggestions. but I am not perfect like you people even though I raised 800 posts. Person is always learning. Anyways thanks.

These are the values in pics Yes I created a folder named 'backup'

Yes it shows the sourcefile and backup file (with new name) too

Hello, I have 2 dbs..one is backend where 5-6 tables are existing and those are linked in main db. Since the use want to have backup of his backend db I started searching code to have daily back up. Later on I got following vba ready code somewhere on net to take backup of Ms Access db...