Recent content by sja13

Not as easy as it sounds, 'cos sometimes the Form is opened from various bits of functionality, but I'll give it a go tomorrow (off to hospital now)....

Minty.... Not sure what you mean about checking if the Object (Report?) is still open when it reactivates. I've inserted simple MsgBoxes into the Report's VBA which give the sequence reported earlier. i.e. On Opening, we get OPEN LOAD ACTIVATE GOTFOCUS then on manually (i.e. not via VBA)...

Colin.... Not sure what you meant about modifying the code. The actual code follows Private Sub Report_Close() If Trim(gstrRepInvoker) <> "" Then Forms(gstrRepInvoker).Visible = True gstrRepInvoker = "" End If End Sub The variable "gstrRepInvoker" is a global string variable which...

Hi Bob - The problem is that I may know what state the Report was opened in, but I don't know which state it's going TO when the Close is issued. Is it a final Close, or just a step on the way to a another state (i.e. still open, just a different view)?

Hi again guys.... I use VBA to execute a standard Report, and am controlling various pop-up forms which the User uses to initiate the reports. The Reports are always initially opened in "Print Preview" mode. When the User closes the Print Preview, I make the Form which initiated the report...

OK – firstly thanks to all who took the time to reply. Special thanks to arnelgp, whose conceptual solution worked just fine. For the sake of completeness, and in case anyone else wants the full tale, what the actually solution was in my circumstances was as follows:- I have a number of Reports...

No it isn't. That's the part of the problem (see attached).

Hi guys (again!) I have a pop-up Form which has a command button to print a Report. When the Report is activated (in Preview mode) I need to hide the Form so the User can see the preview. My problem is getting the Form visible again when the User “dismisses” the Report, either by printing it...

Thanks Colin!

ridders.... Whilst "sanitising" the Db to upload it, I noticed the same fault you'd found. Thanks anyway for all the replies! I now officially qualify for the world famous "Numb as a Brush Gold Plated Time Wasters" award. (Trouble is, I'm sure I'm a five times recipient!) :banghead:

Can't find a trailing space. Tried replacing space in criteria with %20% - still no hit. Am I being dim? What did you mean by ?

ridders - I agree it should work. Attached are three screenshots, showing the Table, the Query Design, and the Query Result. I'm still baffled!

There's probably a frustratingly simple answer to this one, but I'm trying (and failing) to use a Query to locate one or more records in a Table where a field in that Table has the value "X:\GKD\Photos\Awaiting Image.jpg". Because I know that the text has a blank in it, in the Query Builder's...

In case anyone is also struggling, here's some code to achieve the objective of reading a Word document in Access. It's a different approach to my original. It also works (at least for me!) Option Compare Database Option Explicit Sub ReadWordDoc() '##################################### '#...

I have the following code which I hoped would read an entire (short) document, but it doesn't- the problem is commented in the code. Can ayone help? Sub ReadWordDoc() Dim wdApp As Word.Application Dim wdDoc As Word.Document Dim strWordFile...