Search results

Am using below code to send Lotus Notes emails from Access 2010 and its working fine except few desktops. In couple of machines am encountering Run Time Errror 13 : Type Mismatch in this line "If Not !emailTo Then". Please help Function sendEmail() 'Public Sub SendLotusNotesMail(strMailTitle...

Hi Am using MS Access 2010 to send huge bunch of emails from Lotus Notes. Below is the code am using but emails are not getting saved in the Sent folder of Lotus Notes.......email appears in Sent folder for a short period of time and then gets moved to Inbox. Pleas help Dim objAttachment As...

I have created one mdb database in MS Access 2010 but now I want to save it as accdb. Please guide me thru this. Thanks Ajit

Hi I have a form in which user will enter few values but I need users to enter the comment in relevant text box too only if they have any non zero value. I have attached an example for reference....where red encircled portion is for values and blue is for relevant comments. If value is non...

Hello I need running (cumulative) total in a query and the query is the outcome of multiple queries / tables. Field am using is unit: uds_unit_description (domain : qry_tbl_subdivision_and _code) x: month_date (domain : tbl_calendar) y: y1 (domain : ba1) I need running total of y by unit...

Hi I have multiple sub forms and want to add specific text boxes of different sub forms into one another sub form. Then all sub forms are incorporated in one main unbound form. Please guide me on this issue. Thanks

Hello I have database for each location. Every location will update some information in the databases and send it back to me. In those location based databases, information will be stored in one table called "consolidate_input". I will store these databases in one specific directory and then I...

Need a formula which can capture filename for me. For example, I have a db saved at "C:\D\location\office\China.accdb". Is there a way to capture "China" in a query?

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

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

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

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

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