Recent content by John Baker

Pat, Thanks for your response. Unfortunately, I continue to have a problem with this query. Here is what I have defined for the Date field: Field:Expr1:DateValue([OPEN_TIME]) Total:Group By Criteria:Between #5/1/2006# And #5/31/2006# When the query runs, it returns the error, "Data type...

I am trying to create a crosstab query that counts the number of events that have been logged for each day of the month. The event date is stored in an ODBC compliant database in date/time format. Unfortunately, the crosstab query counts the number of events for each date/time occurrence. I...

Thanks, works perfectly!

I have a form that I use to collect selection criteria for reports. The controls on the form are combo boxes and date fields. After I run the report, I would like all of the fields on the form to be cleared of the selected values that were used to run the previous report. I have tried the...

Thanks, RG! This solved my problem.

Yes, I have set a reference to 'Windows Media Player' in my project.

Yes, I have a reference set to the Microsoft DAO 3.6 Object Library.

Having difficulty with executing the Recordsetclone property of my form. Recordsource for 'frm_event' is based on a table, tbl_events. On the Form's 'OnCurrent' event, I make a call to the function 'DisableEnable([Form])': Public Function DisableEnable(frm As Form) Dim rstClone As...

Still does not work for me, bone. I continue to get the following error when I try to incorporate the Windows Media Player control into my form. Run time error '438' Object does not support this procedure or method. The only way I am able to launch Windows Media Player and play wav files is...

Success - Finally!! After additional research in various forums, I have finally found a solution. The following link describes how to start an application using a Shell Execute function. I placed a command button on my form that makes a call to this function, passing the name of the wav file...

Thanks for the suggestion, bone. However, I get a different error when the following line of code tries to execute: Me.WindowsMediaPlayer0.URL = filename Run time error '438' Object does not support this procedure or method. I suspect I may have a registry problem but can't figure out how to...

Thanks, bone and g. I am able to play a file using the 'PlayWaveFile' function that you suggested - works just fine! Now, I am interested in using the Windows Media Player control. I added the control to my form and I used the code in the link you provided: md.FileName = "Name of File to be...

Greetings: This is a new area for me and I am struggling with how to approach the solution. Have searched the archives but still can't figure it out.... I have a database that stores call center coaching events. I would like to insert a wav file (recorded conversation) into each record and...

A Different Twist! Ok, I determined that I can capture the PRODUCT_TYPE value from the Reports collection (see code below) in my subroutine call so I no longer have to figure out how to 'pass the value' into the subroutine. This is working fine, I have been able to confirm that the subroutine...

I am trying to make a call to an action query (qry_prod_prob_build) in the Group Header of a report that builds/creates a table that is used to graph a chart in the Group Footer section of the report. The action query works fine if I hard code the product name into the parameters collection...