Recent content by suzeg

Hello I am struggling with this code. Novice here. I am trying to run a query from input from a form and then send emails from that query. I am totally lost. I viewed a lot of code but just cannot get it right. Any help would be greatly appreciated. Dim MyDb As DAO.Database ''Dim rsEmail...

Thank you - you were correct!

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

Thanks - I had tried so many iterations but just realized the error was in the extension. Which now begs another question. The files are .xls my test file was .xlsx. How can I write the hyperlink address so that it will open a file whether it is .xlsx or .xls?

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

Thank you all for the fix and the lively discussion. It worked - I think the Chr(34) will be very beneficial as I was getting lost in the quotes. Again - much appreciated and I will copy and paste next time.

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

Unfortunately I am still having problems with the query. I have to include the student records in the query and I end up with a cartesean query. I think I need to link the Semester Table with a key field but I am not sure how this would work. Any suggestions?

My mistake - I think it is working fine. Thank you so very much!!!;)

This worked great for the Semester Year 2013 however the query eliminates the previous year 2012. I added the 2012 semesters to the semester table but not sure how to edit the query to catch the year of datestart. I created a field in the query called semyear:Year(datestart) to get the year but...

Great! - I will give that a shot later today and let you know how it turns out. I did put the semester dates in table but I did not know where to go from there. I did not know if I needed some kind of relationship btw the 2 tables to make it work. I will keep you posted - :o

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

That is my problem. The data was originally entered without assigning a voucher to a CourseID just a studentID that is why ID is in the Voucher table. This wasn't my design, I am revamping an old database and was hoping to fix that. I think at this point, all I care about is if student 1402...

Sure. I apologize. TblStudents ID,Fname,Lname 1402,John,Smith tblStudentRecords ID,CourseID,datestart,datefinish 1402,85050,1/1/12,2/10//12 1402,85657,3/15/12,3/20/12 tblVouchers VoucherNo,ID,CourseID,dateissued 123-abc-pqy,1402,(this is what I need),2/28/12 555-878-oku,1402,(this is what...