Recent content by ppoindexter

eureka!! that did the trick...thanks so much pngbill!!! :D

thanks for all your help ..the query is working fine now....i just need to somehow match its results with each recordset showing on the subfrm..i have the subfrm set to continuous and would like the query results to show for each recordset (see below)...i am probably confusing you with this...

i am getting "error" in the textbox on the subfrm with this code in the control source =DLookUp("[NoTimesUsed]","qyrcountstrand_frmscope") below is the sql statement for the query ...any ideas on the error message?? SELECT Count(*) AS ["NoTimesUsed"]...

no, the filters have two purposes..filter tbl1 and show results in the subfrm (got this working fine) and i am also trying to use cbo's to filter tbl2 and count records based on records that meet criteria in the filters...i tried dcount and have also tried a query which does count the records...

how do i count records in a table based on 3 user selected filters (combo box) on form and then display the record counts on form and have it update when filters are changed on form? any help is greatly apprecitated!

Students have one locker each and they dont share thanks for your help

i need to upload a list of students and insert them into an existing table...goal is to assign students to a locker....tblLockers is my attempt at this task... tblLockers has locker info in it and i uploaded an excel sheet that contained some students and then appended them to the...

i hope y'all dont mind if i jump in here i have a similiar situation a main form with several subforms each on a tab and a combo box that selects a record each subform has a different table as its record source (the combo box selects a record that will be the foreign key for each of the subforms...

thanks for your reply user will select data from a form then open report that shows selected data fldStudent will be one of the parameters selected can u tell me how to use the replace function?

i need to insert student names fldStudent in a paragraph of static text so that there is not extra space on short names nor long names that are cut off.. paragraph example: fldStudent, would be an asset to the student council for several reasons. First and foremost, fldStudent is always on...

mboe txtStart and txtEnd are populated from a form, see below: =Forms!frmReportByProvince!txtStartDate (populates txtStart) =Forms!frmReportByProvince!txtEndDate (populates txtEnd) i tried the following =Sum(IIf([ReportDate]>=[Forms!frmReportByProvince!txtStartDate] And...

Pat and mboe Thank you so much for your replies. :) Pat, you were right, I was missing records that were on the first and last of a month. So I changed the code as you suggested. This code is working great now. If Me.ReportDate.Value >= Me!txtStart.Value And Me.ReportDate.Value <=...

i have the following code in the on format event of a report: 'changes date to white so it wont show unless it meets criteria If Me.ReportDate.Value > Me!txtStart.Value And Me.ReportDate.Value < Me!txtEnd.Value Then Me.ReportDate.ForeColor = 0 Else: Me.ReportDate.ForeColor = 16777215 End...

I guess I didnt state the question very clearly but the code I was using wasnt working, I will try your suggestion. thanks for your help!

I need to format the font in a text box on a report based on dates entered in text boxes on a form: frmA txtStartDate txtEnd Date rpt1 (in details section) txtReportDate on format event (something like this) If [txtReportDate] => [txtStart] AND =<[txtEnd] THEN...