Recent content by MrChips

When I am in design mode, and ask for the properties screen, it takes up to 30 - 35 seconds to resolve. A sort of 'curtain' slowly crosses the dialog box from left to right, taking about 10 seconds, and then repeats until the screen finally resolves. I am using Access 2010. This happens for all...

Crumbs .... what a mouthfull. It is so complicated that I would be worried to even try it. Thank you, however, for posting your solution. It is appreciated.

Thnaks again. Having been 'caught' before with inadequate back-up, I now do a full back-up each evening to c:/ a USB drive and a remote back-up site. The pain still lingers heavily in my mind....

Thank you ... especially for your advice on 'bloat'. I will do as you suggest ... thank you

I and agree and accept that VBA is a valid alternative to using Macros, but in some cases, in the past, I have been known to 'reinvent the wheel' in VBA without letting native Access processes take the strain. I still wonder why the deleteObject has been removed from the Macros ... I can't see...

Mile-O I can't answer for previous posts, but in my instance i wish to import an updated table into my database containing up-to-date base information I need. If I don't delete the existing table, access doesn't overWrite the old 'PGR' table it numbers it 'PGR-2' which will not be recognised...

I have done this in the past ... and it does work. I am also using the [Database Tools] [Object Dependencies] and recording each in a spreadsheet .... but it is such a lengthy process. Eventually I will know what is needed and i will delete the rest ... but, no doubt, will be very thankful...

Thanks Spike, I will have a quick look.

I guess you are right Paul. I had just hoped that there might be something out there that could produce a hierarchical report to make things a bit easier.

I made a cardinal error ... When the specs changed half way through a job that I had spent a couple of months on, I should have restarted from scratch and pulled in tables/queries/forms and code that I needed, building on a clean base. However, I carried on with the database and ignored stuff...

Solved: Discovered that I had actually built the file so that it ended with .pdf.pdf ..... (But only one showed when viewing it). Silly mistake of mine.

Hi there. I have access 2010 on Windows7 64bit, (in case that is important) .... and ..... I am attempting to use the following code to attach a .pdf file to an email:- ####################################### Dim strTo As String Dim strSubject As String Dim strBody As String Dim...

I am treasurer of a club, and as usual, some 100 members have not paid their subscriptions. I have their email addresses. Is there any way that I can generate emails into Outlook Express based on a query please?