Search results

Totals Query Yes I just tried that. I can get the query to show the correct total, but the expression I put in the controlsource box does not display that value. I have a query named qrySumRushYards Here is what I put into the controlsource box. =[qrySumRushYards][SumOfRushing Yards Gained]...

I am using access for gathering football statistics during a live game. I have a form that will show simple cumulative statistics as the game progresses. I want a text box to show the sum of rushing yards for eah play. In the controlsource box of the text box properties I used the following...

I got it! Instead of .filename, it is .url. That has done it. Another question though. The only version of Windows Media Player that seems to be availiable in Access is 7.0. How do you get 9.0 (latest version) to be an Active X option?

I have tried that Thanks for your reply. I did see your earlier post and tried that exact procedure. Here is the code: Private Sub Command5_Click() Me.Media_Player.Filename = Me.Text36 End Sub Windows Media Player is named "Media Player" and the text box (Text36) has the entire path...

Thanks to some great posts, I have coded a form that finds displays the location of a file on my hard drive. The text box displays the path and the filename (For example: c:\My Documents\My Videos\video.mpg is displayed in the text box) Now, I have added Windows Medial Player onto the same...

Grrr Found it... Simply set the frame to the value of the option button you want and the button is selected!

I want to be able to update an option group based on previous events. For example, when certain conditions are met on one form, then the an option (radio button) in an option group on another form is automatically chosen (and we can see the button is chosen as well). I know I could solve...

Thanks!! I get your thinking! It is amazing how one sits and agonizes over something that has such a simple solution. I was stuck thinking that I needed multiple tables or even other databases (one for each game, just like spreadsheets). Thanks for helping this coach out.

Great question!! I guess I envision it working like Excel where you can have 1 file (or application), but multiple worksheets with tabs at the bottom. Right now I analyze the information from each game with Excel, but I was just wondering if it could all be done in Access.

Can a database be set up so that a few forms can be used to create multiple databases? For example, I have made a database that holds football (American) statistics. I have created the forms I need to input all of the information, queries and reports to view the information and VB code to...

I thought this would be simple, but it has turned out to be quite frustrating. I am currently making a football (US) statistics database. I have a form where I input all of the offensive information. This form automatically updates the down, distance, yardline, series and playnumber based on...