Search results

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...

Hi Minty - hope you enjoyed your break! The code to close the form is in the macro in the command button's click event on the form, and Debug.Print Me.Name does in fact give the name of the Form. I've got a strong feeling that this is one of those "bump in the night" episodes. I'm not sure...

OK guys - I fixed (???) the problem, but I'm not sure why it's fixed! On various Forms there is a "List" Command Button. Clicking this invokes a "standard" Sub "ListRequested", which issues the DoCmd.OpenForm command to show the Form frmListRequested. The Form frmListRequested has a Command...

I'm sanitising the Db - when I'm done, do I post it as an attachment? Is there any way to delete it from the post subsequently, when those people kind enough to help have examined it?

Tried removing acDialog, and got back to the original issue - the form is opened, but the VBA which opened it just keeps running (i.e. doesn't pause for the User to fill in the Form) Code is definitely in the single click event. I'll see if I can do some work at home later on, and also see if I...

Removed code as suggested - still does exactly the same thing. Oddly, if I click the Run button a second time (after the first click which seems to do nothing), it works as it should!