Search results

No, I've tried it with the db minimised and it works fine.

That's it. Many thanks. I'd have never worked that out - didn't realise the database window was classed as a form! Just to recap (in case anybody has a similar need): DoCmd.SelectObject, acForm, , True (unhides the database window) and DoCmd.RunCommand acCmdWindowHide (hides the database...

Any ideas as to how you would you select the database window object?

I've tried it before and after, but neither worked. It's one of those problems - do you fix the problem or invent a work-a-round solution. I believe the problem is an ACC97 quirk - so I'm trying to find a work-a-round.

I'm using the following lines to output a series of reports to rtf format files. While Not rs1.EOF DoCmd.OutputTo acOutputReport, rs1!rname, acFormatRTF, strPath & rs1!rname & ".doc" rs1.MoveNext Wend This works fine. :) However, when I distribute the db with the database window...

Yes, Screen.PreviousControl.Name would produce the same results. (But nobody suggested that 18 months ago when I had the problem to solve :eek: )

This worked for me. Everytime a value was changed I needed to change other values on the form based on the value just entered. Thus I needed to be able to identify which control had just changed. I used the LostFocus event on every control on a form to call a sub-procedure. This...

Clive, After much tickering, I've found a way to send from another mailbox (if you have access to it, of course). I've not managed to solve how to save the mail in the 'Sent' folder - it just saves it in the 'All Documents' folder! Public Sub SendNotesMail(Subject As String, Recipient As...

Many Thanks, Taken your suggestion of creating the new files based on a pre-existing file with the code already attached. Works perfectly. :) Aside of that - couldn't get the code to work. Kept getting error saying "object not open to automation"

Not sure where to start with this, but I'm sure it's possible. I've got a db that creates output into a new Excel workbook (that works fine). But now I want to add some code automatically into the ThisWorkbook module of the Excel workbook. How do I get Access to add VB code to an Excel...

You can set various custom Database Properties (under the File menu), but is it possible to interrogate these using VBA? For instance, if I were to set a custom property called "IssueNo", how could I find the value that had been set for this property via code?

Are there any VBA gurus that could answer this? http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=38400

I thought I had the security issue sorted! This is what I've got. Backend - located in hidden directory, database password protected, shift disabled, shortcut keys disabled. Frontend - distributed as MDE, shift disabled, shortcut keys disabled, database window hidden etc. To prevent...

Thanks for that link. The code works, but only on a directory currently set as 'Full Control'. i.e. I can change from 'Full Control' to 'Read', but once set as 'Read' I can't change it back. (Manually via NT Explorer works though) Any ideas what the problem might be? Unfortunately, I have to...

True, our network guys could do this (eventually!). However, this doesn't give the required solution. Any number of users have the ability to generate these reports from a shared database and it is these users I want to prevent from amending / creating reports once exported. Therefore, it's...

Here's the scenario: I have a routine in Access that outputs a series of reports as .rtf files into a directory on a network. It then changes all of the file attributes of these files to read-only. This is successful in preventing users from changing the reports, but this doesn't prevent them...

Thanks, that does the trick.:)

Is it possible to detect if a table is locked (i.e. a query, report or form using a table is open). I'm trying to automatically delete selected tables on a periodic basis, but the code falls over if the table is currently in use. How can I trap for this so the delete line can be skipped?

I've had a similar problem in the past. I now open a database as 'exclusive' if I wish to import files. This seems to force Access to realise you are the only user using the database at that time and everything works without a hitch. (I use Acc97)

Thanks for the reply. Still not going to be of use though. Let me explain more fully. I have a make-table query that is set to run every 15 mins. In order for this to work no reports can be open in preview mode (design mode is okay) else the make-table query cause an error. A few users use...