Search results

By Child database I mean......in one folder (location wise), I will have one Regional database and multiple Office wise databases (i.e Child). When I will roll out these databases to differenct people around the world, they should have the ability to consolidate the data of multiple databases...

But the plan is to roll out the databases to different locations and I want to provide them a command button which will consolidate the child databases tables into one table in Master database. I will just circulate them a instruction to save both Parent and Child databases in one folder (or...

Hello I have one Master database and multiple child databases in a folder. Each of these databases (both Parent and Child) have identical table called "source". I need a VBA code which will consolidate tables of child database into the Parent database table. Thanks

It worked as a wonder !!!!!!!!!! Thank you so much and enjoy your drink. Wish you a very happy new year to you and to your family. Thanks

Thank you for the instant reply...... am encountering an error on line code "Call .Properties.Append(proTitle)" at the time to preparing the second file. "Run time error 3367.....Cannot append. An object with that name already exists in the collection." Please help

Am using below code to create accdr files with filename as cost center number. Now I need to have filename i.e. cost center number at the application title bar of each accdr file. Please help - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Dim appAccess As...

Thanks much for the instant help!!!!!! I will look into the threads and will share once I get anything useful.

Hello I have a database (accdb) out of which I want to generate accdr files of which user can only access / view the reports section ONLY. Can anybody help with a VB code which will generate employee wise (or any criteria) accdr files?????

I want to lock the view of certain tables and queries so that users could not perform any change at their own. Is there any way in VB to protect it with password....Please divulge the best possible way for my concern.....thanks

thank you....it worked as I required.......but have one more requirement in addition to this....need one more criteria to get the report and this time it is a number field (Combo 22). using below code but encountering an error. Please help DoCmd.OpenReport "MatrixBy_Member", acViewPreview, ...

Using one form with multiple combo boxes on the basis of which am trying to generate a report. Below is the code I've put in a command button (in Form) by which I want to generate a report....FYI - both combo boxes have text value....Please help. DoCmd.OpenReport "MatrixBy_Member"...

Thanks all for the speedy reponses but I was able to discover "Adobe Acrobat 10.0 Type Library" reference on my machine and code is for "Adobe Acrobat 7.0 Type Library"........is there any way I can move ahead with the Adobe Acrobat 10.0 Type Library????

Am using below code for generating set of pdf files in a desired folder........similarly I have another code, which generates another set of pdf file in another folder.....Count and Filename is identical in both the folders and I need to merge the file names with identical names...

Hello All Am a beginer in the world of access. As of now I do play around with Tables, Queries and Reports in a manner that am managing the databases subject to adhoc requirements. Need to know about VB..... Ajit