Search results

I am receiving a Runtime error 424 Object required and have no idea why. It was working fine now it gives this error. I am working on code written by someone else.. The code stops at lblSitePlan.Hyperlinkaddress = "" Private Sub cmdSite_Click() lblSitePlan.HyperlinkAddress = ""...

I am trying to open an excel file using the following code. lblLotPlan.HyperlinkAddress = "" lblLotPlan.HyperlinkAddress = ("Old Cemetary\" & "Lot " & tmplotno & ".xls") Application.FollowHyperlink lblLotPlan.HyperlinkAddress tmplotno is a string The file will open fine if I type the...

I cannot figure out why this is not working! Any help appreciated. Screen Shot of Code with error attached.

Hi - I am creating a Transcript report that will group courses taken by Semester. I am having trouble figuring out how to work with the dates. Semesters StartTerm EndTerm Spring 1/2/2013 4/19/2013 Summer 4/29/2013 8/16/2013 Fall 8/26/2013 12/17/2013 I was attempting...

I have FormA,(frmstudentVouchers) on a Tab and it calls a pop-up form, FormB (frmUnAssignedVouchers). I want to take the fields on formB and add them to the RecordSource of FormA which is a query.(qryStudentVocuhers) The Code is below - I have indicated where it goes wrong. I have tried...

I have tired so many itterations of querys I need help! I have one table 1)tblStudentRecords - A student may have many records. This table contains ID field and CourseID field and others. The second table is 2)tblVouchers - a Student may have many vouchers. This table contains ID field and...

How do I reference the combobox selection in a form?:banghead: My code is below (if needed) If IsNull(Me.StartDateInput) Or IsNull(Me.EndDateInput) Then MsgBox "Please enter both a start date and an end date", vbExclamation Exit Sub End If strWhere =...

I am opening a subform in edit mode. The form has a Yes/No field that when the form opens shows 0 (Which I know means False, I would like it to show No). Also, I cannot change that value. Even if I type in -1, it does not save to the record. Any help greatly appreciated.

I cannot figure out why this does not work. I get a type mismatch error (13). DoCmd.OpenForm "frmAddNewVouchertoStudent", acNormal, , ("id = " & lngParentId) And (BooAssign = True) When I do a watch the BooAssign variable is True. The Id variable works great alone but when I add the "and...

I have a parent form (Main) and a subform (student) based on a query. The subform (Student) shows a student ID and his courses taken. I have created another form (AddGrade)to open when a record is selected from the subform Student. I would like the form AddGrade to open to the correct record...

I have a main form based on a query. The main form opens with Student ID field. The subform opens to the correct student record but I would like the subform to open to a blank record of that recordset so that I may add a new course for that student. Currently the subform opens to the correct...