Search results for query: *

I have a table with teamID, SchdID, Win, Loss, Tie as its fields. I'm trying to write a query that can give me each team's current winning or losing streak. Eaxmple TeamID SchID Win Loss Tie 1 20 1 0 0 1 30 1 0 0 1 40 1 0 0 2 21 1...

I asked a similar question earlier but now I'd like to explore some more functionality. I have 2 combo boxes on my form where the user selects the Starting_Period and the Ending_Period. I'd like for the Ending_Period to default to the last entry in my tblPeriod (I maunally add to my...

I have a form where the user choose the Starting MMM-YYYY and Ending MMM-YYYY. I'd like to set the default value for the Starting Period and the Ending Period to Jan-Present Year and Dec-Present Year. I've tried to use the following code on the OnOpen event procedure of the form but I think...

I have embedded a chart on a form. I am having difficulty with its Title. I want the Chart title to say: "Trailing 12 months Average Unit Price for Part # XXXX". The user selects the Part # on another tab on my form. How do I get the actual part number to show up in the title? I have...

I have a table with Vendor#, VendorName and Status. The Status field has either OBS (Obsolete), NA (not available) or is blank. I am trying to write a query that displays all Vendor# when Status field does not equal OBS or NA but, I can't get it to work right. My problem is the WHERE...

I have a Parts Master table with PartNo, Vendor01, Vendor02 and Vendor03 as its fields. I am trying to write a query that will list all PartNo that have the same vendor number in either the Vendor01, Vendor02 or Vendor03 fields. For example, the table has the following data: PartNo Vendor01...

I have a Report with 2 labels and a MS Graph on it. I have a button that sends the report to MS Word, but, the Graph does not show up (only the labels). Does anyone have a fix/workaround for this? This is the Event Procedure I am using. DoCmd.OutputTo acOutputReport...

I have read through all of the threads on this subject but I could not find an answer to my question. I have a report with an embedded MS Chart and some other labels. I'd like to export it to Word but, when I do, the Chart object does not export, only the report labels. The only solution I...

I have a list box on a form who's rowsource is one of three queries (based on the user selection). My problem is the field formats in the listbox do not match the formats of the undelying queries. My part #s are showing up with 2 decimal places. Is there a way to set the format of each column...

I posted this question a couple of days ago but then I lost my account access for some strange reason. Anyway, I'd like to play a list of mp3 files when my form opens and also have a button so that the user can disable the music. I can't remember who posted the code to help me but I'd...