Search results

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

I am stumped on this one and am hoping someone can provide guidance.... I have a report that is based on a crosstab query that summarizes the status of problem management tickets (e.g. open, linked, closed). The report is grouped by PRODUCT_TYPE and for each PRODUCT_TYPE, there are one or more...

Solution for Subreports With No Data Here is the solution I developed to address subreports with no data... not sure if it pertains to your situation; however, it worked well for me. John Ok... after several weeks of searching various forums on the internet, I was finally able to solve my...

Solution Found My total calculation was not working because some of the values were null. I used the 'Nz' function in my expression and the TOTAL field calculates perfectly now. =Nz([open],0)+Nz([updated],0)+Nz([closed],0)

There is probably a simple solution to my problem but I just can't seem to figure it out! I have a report that is based on a Crosstab query. The query counts problem management tickets for each business unit location by status (open, updated, closed). In my report, I would like to provide a...

Reporting Problem Solved Thanks so much, Pat. This provided the perfect solution. Since there can only be 3 possible statuses, the columns property solved the problem. Thanks again! John