Search results

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!

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

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

Can anyone add 3 more case select statements to this code so users can select "Fiscal Year" as an option? Specifically take Case 610, Case 620 and Case 630 modify it so its the fiscal year dates and not calander dates. Case 6 'Year to Date txtStartDate = DateSerial(Year(Date), 1...

Can anyone tell me why this sql is not returning all fldProjectID's for selected fldProvinceID regardless of whether a date exist for that fldProjectID in fldReportRec_D?? SELECT tblProject.fldProjectNo, tblProject.fldTitle, tblProvince.fldProvince, tblReport.fldReportRec_D AS [Monthly Status...

i have a text box "textMemo" (data type = memo) on a form that is populated by "textMemo1" (data type = memo) =Forms!frmMenuReports!subfrmReportMemo!textMemo1 textMemo populates a text box (Tmemo) on a report =Forms!frmMenuReports!textMemo.column(2) when i open the report i get #Name in...

the following code DoCmd.TransferSpreadsheet acExport, "qryMonthlyStatusReport_Active", "C:\AccessExport.Active.xls" produces the error Runtime error 13 Type Mismatch i am 2003 versions of access and excel please help thanks

What is the best way to have all controls in a subform empty when form opens? The form and subform are bound. The following: Private Sub Form_Open(Cancel As Integer) Me.textDate = Null End Sub Produced error - "cant assign a value to object" thanks in advance

I have the following code in the second combo box on a form Me.cboReportType.RowSource = "select fldReportTypeID,fldReportType, fldFrom, fldTo, fldDue from tblReportType Where fldReportTypeID Not in (select fldReportTypeID from tblReport) order by fldReportType" right now this code is...

Hello all I need to get the difference between 2 date fields on a report All records have a startdate but not all have an end date, I need to place a IIF then (i think) in the control source of the text box on the report so that the difference in the two dates will be either: 1) between...

good eveinng everyone need some help updating a populated table tblOne fldA, fldB, fldC frmBlue record source tblOne (all fields) i need to open the form and search for a record in tblOne and change the data in say fldB from apples to oranges (tblFruit is a listing of all choices for fldB) i...

i have a db that works fine on computer it was created on all computers have office xp/windows xp 1. split db using the database utility - database splitter to create a front/back end 2. copied the front end to user computers and linked tables (back end is on db admin computer - not a...

i have a db that i took from work and brought home to work on when i try to preview a report i get a window saying that the network printer isnt available... the code on the command button to open and PREVEIW the report is below DoCmd.OpenReport stDocName, acPreview, , strWhere why is access...

what do i add this statement so if a selection isnt made from a particular combo, the comob is ignored and the query uses only the values selected [forms]![frmOne]![cmbOne] something like this [forms]![frmOne]![cmbOne] or is null ? thanks

I get this error when i try to select a record from a combo box....error 3021 - Either BOF or EOF or record has been deleted.... Can anyone tell me what BOF and/or EOF is? i know the record has not been deleted. thanks pat

hi i have a db that sequences lesson plans users have to add a lesson for each day (5 per week) and 9 weeks per quarter i have a form that they use to sequence the lessons what i would like to do is add (to this form) a visual of sorts or a chart ...something that shows them how much of the...

I have place the code below (example A) in the control source for a text box on a form and it works fine but i need to add a second criteria to it...i cant seem to get the code (example B) to work (i get no results)....any ideas? thanks EXAMPLE A =DCount("fldOneID","tblRED","fldOneID=2")...

i am trying to make my report open up on top of the popup form that opens it i used some code from a previous post as you can view below... and i get the following error "expected variable or procedure, not module" i havent used modules very much anyone know what i am doing wrong? thanks...

i am using a form with 2 list boxes to pass selected values to a query/report this code works if i select only 1 item from each list box, when i select different combinations of values (for example 2 items from LBox_Grades and 1 from LBox_Standards or varous other combinations) the report opens...