I´ve a PowerPoint presentation witch must be filled with data taken from an MS Access Database. I´ve build a Macro to obtain the data, but I must filter the Query by a Client number. This client number was selected in a Visual Basic App. (this is the app that generates de Presentation...
Try calling the form as Modal mode.
Example:
frmError.Show 1
or
frmError.Show vbModal
The modal mode does not let the application continue executing until the Form (frmError) is closed.
I hope this would solve your problem !!
First of all you have to declare the function parameter as ByRef. Example :
private sub whatever(byref t as textbox)
msgbox t.name
end sub
Then you call the function as usual:
Whatever ActiveControl
or
Call Whatever(ActiveControl)
Remember: if the parameter is declared Byval, you pass the...
If you want the SELECT statement to return only the first record of "ALL" the SQL Query, you can use "SELECT TOP 1". This statement returns de number of records correponding to the number you write after the TOP word.
SELECT TOP "n" returns you "n"...
Is it posible to view a report in a slide of a PowerPoint presentation? I have a presentation with 20 slides. Three of those must have data from an MS Access Database. I'm using VBA to generate the slides.
I tried inserting a flash movie from the <Insert/OleObject> Menu. I've set the property SetOleLocation in the Section Format Event, but the movie does not work !!
Thanks,
Miguel.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.