Search results for query: *

I asked previously on this forum for help with the following: 'Runtime Error 2046 - SendObject isn't available now' (context: this works fine on my laptop with Access 97 and Outlook Express but not on my colleague's identical laptop with same version of Access, Outlook Express and an identical...

Thanks for this suggestion. Do you have any examples of the code you use to send an email from Access using your SMTP mailer? Can it handle attachments - specifically Reports in rich text format and attached files e.g. Word Documents? - Richard

Seems to make no difference - mine works whether it is or not, hers doesn't regardless. Also, if I copy my front and back end over to her machine and use those, I get the same behaviour. I suspect a problem with Windows Messaging, but in the past this has generated its own error messages, rather...

The above error message is generated when my colleague clicks a button that runs a procedure that includes the SendObject command to send an email. An identical copy of the same database works fine on my computer - SendObject creates an email ready to send. (When I say identical copy, the front...

Several reports which have previously printed without problem are suddenly coming out very large, as if the scaling or font had suddenly been set to 400% of its previous value. The problem seems to occur when I print a report using the Toolbar 'Print' button, as opposed to File/Print on the...

If you have previously installed Office 2000 then installed Access 97 you get this error message. The solution is covered in the following article in the Microsoft Knowledge Base: http://support.microsoft.com/support/kb/articles/Q283/1/73.ASP?LN=EN-GB&SD=gn&FR=0 You just have to delete a...

If you have previously installed Office 2000 then installed Access 97 you get this error message. The solution is covered in the following article in the Microsoft Knowledge Base: http://support.microsoft.com/support/kb/articles/Q283/1/73.ASP?LN=EN-GB&SD=gn&FR=0 You just have to delete a...

Kathryn, Sorry to trouble you further. Just one last question (hopefully). I am trying to use this code for Outlook but it doesn't like the line: GL1XX_Driver = RC_ABEND (variable not defined I think) and presumable the later one that looks similar would cause problems too. What are RC_ABEND...

Oh well, it was worth a try. I suppose I could always use Outlook for the specific task that I want to use this code for. (But why do I need Outlook 98? I have 97.) - Thanks all the same for all your advice, much appreciated, - Richard

Many thanks for this. It made me realise how much I still have to learn about writing code! So here are some rather basic questions: Does this go in the code for a form, or in a separate module? Which bits am I going to have to change to get this working with Outlook Express? (I assume this code...

I just need the attachment code, I am already used to using the SendObject command, but can't find any reference to sending objects other than those which Access creates itself. My copy of Access does not seem to have a menu item called References on the Tools menu, though it is referred to in...

I have: Access 97 Outlook Express 5 How can I send a file (a Word Document) as an attachment to an email generated from within Access? (Sorry if this has been answered elsewhere - I'm sure I once came across something about this in this forum, but have searched all the key words I can think of...

Many thanks Rick - when I thought through what was happening on startup I realised that althought the Autoexc code did not refer to any tables or forms before reconnecting to the data, I had a sturtup form which did, and it seems Access opens the startup form before running any Autoexec code...

I may have not explained the situation well here. I run the database from one of two computers - my desktop and my laptop. I've networked them together (using an RJ45 crossover cable) I've tried copying the front and back ends from one to the other, but it really causes problems if I forget to...

I have tried reconnecting linked tables at runtime using the very helpful suggestions in thread181-38038 . It works fine on two different computers that store their data on different drives (one has drive C:, the other has drive Z:, with folder\datafile names the same in both cases). However, I...

Here I am answering my own question, as I managed to find the answer on the Microsoft Knowledge Base. It turns out that you can only map a network drive on the computer you are actually using if you connect to it by its IP address, NOT its \\computername\sharename. (I first went to Network...

I tried the 'mapping network drive' suggestion on the desktop. It worked a treat. The desktop copy of the 'front-end now accesses the data on the laptop. So far so good. I then went to modify the laptop copy of the front-end, with the ultimate aim of only having one copy of this, residing on the...

Many thanks for these suggestions. I will check out 'Replication' - can you point me towards a good introduction? In the meantime, going back to the previous suggestion, after mapping the network, how do I link the tables using the assigned letter - previously I simply used the File/Get external...

I have connected my laptop to my desktop using a simple network card and an RJ45 crossover cable (and a couple of hours tinkering with the configuration in Network Neighbourhood). I can now open, from my desktop, my database 'front-end' which resides on the laptop, but the database with tables...

I want to be able to check the addresses and sent-dates of emails against records in my database, in order to simplify my record-keeping. No need to access the content of the email itself. Is there any way of doing this? - Richard