Get Window Text (1 Viewer)

G

giddyhead

Registered User.

Local time

Today, 13:57

Joined

Jul 3, 2014

Messages

88

• Jun 19, 2015

• #1

Hi everyone,

Please help! I want to find a way to grab the text from the window that shows the location of the file using vba in Access. A picture was uploaded for reference. Thanks in advance.

Thanks

 

Attachments

• 
  picture.PNG

  34.4 KB · Views: 99

pr2-eugin

Super Moderator

Local time

Today, 18:57

Joined

Nov 30, 2011

Messages

8,494

• Jun 19, 2015

• #2

So what have you done so far? Used a FileDialog object?

 

G

giddyhead

Registered User.

Local time

Today, 13:57

Joined

Jul 3, 2014

Messages

88

• Jun 19, 2015

• #3

Pr2-eugin,

This is what I used

DoCmd.OutputTo acOutputReport, "RESPAY PERSONEL FILE TRACKER", "", "", False, "", 0, acExportQualityPrint

Click to expand...

and the attachment shows the box that comes up. I want to be able to allow the user to pick a location and want to ask them if they want to open up the file after export. THanks

 

V

vbaInet

AWF VIP

Local time

Today, 18:57

Joined

Jan 22, 2010

Messages

26,374

• Jul 19, 2015

• #4

The answer is here...

pr2-eugin said:

Used a FileDialog object?

Click to expand...