I am trying to get the status of a Windows Media Player object without success,
so that I can determine when it is done playing the current audio file.
The intent would be to poll the status until it is complete,
but if someone knows how to have an event procedure activate when it happens,that would be better.
System: Windows 7 32 bit, MS Access 2007, VBA
In the FORM there is a control named WindowsMediaPla yer1...
TGlagowski
Last Activity: Feb 1 '13, 09:05 PM
Joined: Mar 2 '12
Location: Hanscom AFB, MA 01731
-
As a matter of showing the code for the revised example with the SQL "IN" clause, here it is for other interested parties:
...Code:Dim myDBFilename As String Dim myTableName As String Dim myQuery As String Rem Select Database Rem Database has one table: "Table1" myDBFilename = "C:\Example1.accdb" Rem Select -
To SmileyCoder
The SQL statement was probably what I was really looking for in the first place, but there is a lot I don't know about VBA programming for MS Office, particularly MS Access...
Perhaps I should read more about the finer points of SQL within VBA.
I can see that I probably don't want to have the overhead of setting up and tearing down the linked table per query but rather per session and I'll deal with that as the application...Leave a comment:
-
Answers to SmileyCoder...
You have it right...
I am very experienced in general, coding in FORTRAN 2 and 4 since 1964... IBM 1620, 1401, 7040, PDP-5 etc...
MEEE embedded, VLSI, kernel mode / PhD CS and knowledgeable about C++ and its many predecessors. Taught EECS SW/ENGR at WSU in the 90s.
And...INexperie nced in Access and some of the Office Suites and some of the newer programming environments.
The reason I...Leave a comment:
-
Answers for MiHail.
Why VBA?
This discussion was about a prototype example which models the larger routine in a real application. I needed to know how to go about setting the Form.recordsour ce property to the table of an external database, also the Control.control source properties of the relevant controls.
I was unfamiliar with the concept of "linked table".
Yes, I agree that SmileyCoder had the first and...Leave a comment:
-
Thanks everyone for your responses.
The key information that you provided was the concept of "Linked Table".
Using that keyword, I searched the Microsoft Office Help files.
The article entitled TableDef.Source TableName Property (DAO) had the answers.
My working code example follows.
An external database "Example1.accdb " has a table "Table1" with 3 fields: ID (autonumber), DBKey (text),...Leave a comment:
-
Using Win 7 64 Ultimate
Using Office 2010 MS Access
Is the best keyword for help "Linked Tables" ?
I'll take a look...
From what I read from you... the approach is...
Link Table1 from the external database to the CurrentDatabase ...
Is that correct?Leave a comment:
-
My understanding of the error message is that the system doesn't think that Table1 exists... and it doesn't within the *.accdb that contains the VBA code... What I need is a way to express something like... ExternalDBname. Table1 when I set the Form.RecordSour ce property. Do you know what the syntax would be for this?
TGlagowskiLeave a comment:
-
Set Form RecordSource Property to Table of External Database
I am trying to write an MS ACCESS VBA application that has the code in one *.accdb file and the data itself in a separate *.accdb file.
I am trying to set the RecordSource property of a SplitForm to all the elements of a table (Table1) in the external database, but don't know how to properly express the combination <DBname>.<Table Name> for that function.
The following Code does NOT work, but almost does...
No activity results to display
Leave a comment: