Search results

  1. A

    Runtime Error 13

    I replaced if not !emailto then with if not !emailto="" then it shifted the error to next line (i.e. !emailTo = sendTo) and the error is Run-time error 3027 Cannot update. Database or object is ready-only.
  2. A

    Runtime Error 13

    Thanks for the reply but its not working.
  3. A

    Runtime Error 13

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

    Access used to sent emails from Lotus Notes emails not saved in Sent folder.

    No replies as of now. Can somebody help me with this? please......
  5. A

    Access used to sent emails from Lotus Notes emails not saved in Sent folder.

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

    Question saveas mdb created in version 2010 as accdb

    No......its not that way.
  7. A

    Question saveas mdb created in version 2010 as accdb

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

    Stop user from moving to next text box in access form

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

    DSum running total (cumulative)

    Thank You......I made it work my way.
  10. A

    DSum running total (cumulative)

    date......25-Jan-2013, 25-Feb2013.....etc
  11. A

    DSum running total (cumulative)

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

    Add multiple text boxes of different sub forms in another sub form

    am attaching a database for your quick review and solution. "data_input" is the main form and other are subforms used in it.
  13. A

    Add multiple text boxes of different sub forms in another sub form

    the main form is to view only......it has only subforms and nothing else.
  14. A

    Add multiple text boxes of different sub forms in another sub form

    sub forms are used to input the data as well.
  15. A

    Add multiple text boxes of different sub forms in another sub form

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

    Merge identical tables from different databases into one master database

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

    Formula to capture filename in a query.

    Awesome ..................thank you so much !!!!!!!!!!!!!!
  18. A

    Consolidate tables from multiple databases into one database.

    tables are of same structure and there's no concept of Primary Key in any of the table as records will repeat but I have something inside the table which will establish which record is of which database....just want to append tables into one (of the master db).
  19. A

    Consolidate tables from multiple databases into one database.

    I have one code to do the required job but this has certain limitations. In this I need to mention the filenames of all the databases present in the folder. Can somebody help with the code which can just surf inside the specific folder and combines the relevant tables into one master database...
  20. A

    Formula to capture filename in a query.

    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?
Top Bottom