Search results

  1. R

    Relative path to mdb file located outside root folder

    I am trying to place an Access database file (mdb) outside my root folder. Right now, this file is in the App_Data folder inside my root and the connection string which I have in web.config points to it using the |DataDirectory| keyword. Is there any way I can point to the outside of the root...
  2. R

    Sql Intersect

    Hi, I am trying to use the sql Intersect keyword in ms access 2000 but it doesnt seem to work. Anybody know of any other way to do this ?
  3. R

    Sql Intersect

    Hi, I am trying to use the sql Intersect keyword in ms access 2000 but it doesnt seem to work. Anybody know of any other way to do this ?
  4. R

    Programatically creating a new field in a linked table

    I get it to work fine, except for the fact that it won't recognize the newly created field immediately (in the scope of the same function). If I go afterwards and run a query on the new fields it works ok. What could be causing this 'delay' ?
  5. R

    Programatically creating a new field in a linked table

    I wrote some code that programatically creates a new field in a table that is linked to a backend db. I accomplished this by creating a copy of the backend db, running an Alter Table query, and then overwriting the original backend db. After this I run a refreshlink command for the modified...
  6. R

    Sending Emails

    Thank you for your post, But i was reffering to something else... I dont have a problem sending emails using vba through lotus notes, my problem is that i wish to attach a personalised rtf document for each customer, but i do not want it to come up as an attachment, instead i want it in rtf...
  7. R

    Sending Emails

    This is pretty urgent, any help would be very appreciated. Basically , I'm sending emails to Lotus Notes using vba from ms access. Each of the emails will be personalized according to a ms word rtf file. What I wish to do is NOT to attach this rtf file, but to put it in the body of the email...
  8. R

    Sending Emails

    Bump, can anyone pls help ?
  9. R

    Sending Emails

    Hello Im using some vba code to send an email through Lotus Notes. My problem is that if i attach an rtf document then it comes up as an attachment, which i do not wish. I would like to send the "bodytext" as an rtf instead of a simple string, is there any way to do that ?
  10. R

    Sending Email

    Hello I'm trying to send a simple test email to my default email client, which is currently Lotus Notes 6.5.4. I used the following code : Call DoCmd.SendObject(acSendNoObject, , , "rmitache@hotmail.com", , , "Test", " Tralalala", , False) and it gives error 2287 : Database can't open the...
  11. R

    Salary

    Hello, For the last few months I've been developing a database in access for the company where i work. The database stores all kinds of waranty cards, and marketing campaign information about customers. It is currently still in beta phase(it is being improved all the time) but it is fully...
  12. R

    Problems with VBA code on different computers

    Will look into it, thx
  13. R

    Problems with VBA code on different computers

    Hello, I've created a front end which has linked tables to the back end data which is on a network drive. Basically until now, the front end has been lying on 2 computers, and it has been working as expected. When I installed the front end on a few other computers, I started getting errors...
Back
Top Bottom