Recent content by nurjml

Thanks EdFred, worked like a charm!

I am still working on the button issue but I did figure out part of the problem... I had done something wrong with the queries that run the forms/reports. I think I got that working so the button issue should be resolved soon. Oh, and I found the workbook (2 are still missing) from a query...

Okay, I added the stLinkCriteria to the command line... but it is pulling the data from the child file even if it is not pulling from the parent file. Do I need to create some sort of error event for when there is no lead author by the user-input name? I am thinking I need an if-then statement...

This is the code for the button that is not working (It just acts like the button that returns ALL records instead of the one I specify in Combo5) Private Sub LeadAuthorReport_Click() On Error GoTo Err_LeadAuthorReport_Click Dim stDocName As String Dim stLinkCriteria As String...

I created a button that pulls up a specific record in a form: Private Sub OpenExistingAuthor_Click() On Error GoTo Err_OpenExistingAuthor_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "ManscriptTitleForm" stLinkCriteria = "[LeadAuthor]=" & "'" &...

Thank you both. I will go back and tweak the end of the code... Will make things much better when I eventually want to print out the manuscript information in very specific reference list formats. I knew it was something easy, I was just having a major brain block. ;)

I have a lookup table that includes the names of faculty members. They are currently listed as 'lastname, firstname middleinitial' in a field called FullName. I use a combo field in the queries (and subsequent forms and reports) to allow the user to pull the name of faculty member they need...

Hello everyone, I first learned about database development using Access (on Win 95) and Claris Works. I have come a long way but still only "know enough to be dangerous". I have developed relational databases for tracking phone calls to a crisis hotline and for tracking grants. I am...