Search results

well guys reducing the memory helps Reducing the memory to 550 Mb ram has solved the problem. not what I expected though. Thanks to everyone for all their help. Can anyone explain why this is? Because this leaves me with a trade off - I need a lot of memory to help with other software on the...

Wow didn't know you could have too much memory Can it be true? Can you have too much memory ... How does this work.. I'll step the memory down and see what happens.. cheerss Paul :confused:

I'm using windows XP. Other machines have a similar set up and appear to work fine Cheers

Hello Guys, Got one of those don't believe it problems. I'm using access 97. but for some reason access 97 now gives me the error message "out of memory" and will not startup. The program is being used on a machine with a 40GB hard disk (85% free) with 1000MB!!! ram. I'm pretty sure that...

Thanks for that Thanks, but I need it to be pure automation, user intervention does defeat the object a little. If you have any other ideas please give 'em a shot! Paul ;)

Outlook AUtomated email with the "Program sending email on your behlaf " warning Hi Guys, I have recently installed a later version of Outlook and yes I have the intervention message everytime my database automates and email - and it does a lot of this , much of the time in the background. I...

Big Thanks Cheers Mate That's just the ticket! I'll try an help You where I can. Paul ;)

Who's the DADDY on automating Outlook? Hi Guys (The daddy test for those who use outlook automation a bit, or othermise.) I'm quite happy to get my database to get me to email me when an urgent update is required. but i now want it to create an email only this time Loop ing through a record...

DAO worked Cheers Dim dbs As DAO.Database Dim rst As DAO.Recordset worked a treat, also stepped the dao reference down to DAO 3.51 If you have the time could you explain why this worked? Cheers Paul

Hi Guys I have this record set code that i took from my access 97 database and am trying to use in access XP but I get a type mismatch error highlighting the 'Set rst' line of code. Dim Action As String Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb Set rst =...

Sorry guys... this is the subject i was refering to. FROM MATTY : Hi, I know there are ways to send email messages with attachments thru code (via outlook automation), but all the posts that i've found only show you how to add files as attachments. Is there any way to send actual outlook...

Did this work Matty I'm after the same idea Paul

Appointments Hi This code works for me I've shown you have I set a variable to be the mailboxes. (I use an exchange sever.) Hope this helps paul _________________________________________________ .... If Me.seen = "JB" Then who = "Mailbox - Jeremy Burditt" ElseIf Me.seen = "MR" Then who =...

Hi Guys.... All having a good day ? Staight to it... This is so simple i think i'm loosing my head I have a table with a list of appointments for many people. Many people have more than one apopintment. All I need to do (Using access xp - first big step since 97 (which i love)) is first the...

I need a query to return a 0 and not just cave in? Hi guys I have a query A which collates the counted results of other queries B1 B2 B3. I.e three separate queries count the number of records in 3 different recordsets. query A is a simple query collating these results in one record set...

Hello guys... Long time since I've been here but different projects - different ideas. Anyway I'm back and stuck with a simple one ... I not using my fav Access 97 but have stepped up to XP which I'm hoping is a good move ... Anyway here goes... (i've done this in 97 which is very embarassing...

Hello Guys... I have a little problem with setting a report of 300 pages to print from - to pages. Often i need to print pages 23- 45 say and not the full 300. I want to use the print to... command from the tool bar. When i customise my toolbars from the command menu all that is available...

THicky Oh my god yes! Mental block just embarassed me..... (spelling often does to ...) Thanks for that Paul :D

Hi guys long time no speak ... been on a different project for a while.... hope all is well in Access world .. (No wars anyway) MY PROBLEM... I have data source 1 with 1000 records I have data source 2 with 400 records i need to produce a query which identifies the 600 remaining records...

Yep "VBno" is the way!