Search results

Hi, I think we could be on the right lines here but I'm a bit lost as how do I get the snapshot report into the body? I can create it as a seperate document that I can send as an attachment What would the line of code for an attachment look like? Many thanks for the help received so far...

I have a report that contains check boxes that I want to email to colleagues within the same company. In order for the report to maintain its format and display the checkmarks I am using a snapshot. My problem is that I just can't get Lotus Notes to open. I know Access wants to use Outlook but...

:) :) Magic - It works brilliantly. I like this idea of free standing forms - definately one to remember. Thanks

I have a form with a subform. The subform is quite a small area - and cannot be made any bigger The subform has a date control on it. I want to use the Active X Calendar control to select a date that will then be entered into this control. I have the code side of thing sorted OK except when...

I have two tables: Client and Appointments. They are joined by the field ClientID. This is the primary key in Client and the Foriegn key in Appointments. Sometimes it is nescessary to transfer all the appointments assigned to client "X" to Client "Y" and then delete Client "X" To do this I want...

That's fixed it.... Great. Many thanks

While looking at the forum the other day I found an entry that showed how to return the path of the current database. This is the code......... Dim db As DAO.Database Dim strPath As String Dim intCharacter As Integer Set db = CurrentDb strPath = db.Name intCharacter = InStrRev(strPath, "\")...

Gosh do I feel silly - Yes StrConv() works too. Easy when you know how!!! Thanks all - I'll close this thread now

David - Thanks a million that works beatifully. How do you learn this stuff?!!!

Proper Case Please I'm a lousy typist so I usually format my fields to display in all one case - Usually Upper case. This is because I can't get Access to display Proper Case (Title case). I know there is a Proper worksheet function for Excel - I use it a lot - but I can't get fields in Access...