Recent content by PattyS

hi Pat, did some forum searching and applied a Search Form from another post, it works well and returns what I am looking for... But ! is there a way to double click on the selected results and have it open up the form with the entire case frmCase is the form that I had entered all of the data

access 2010 I need to be able to search ALL of the NAME fields in the database.I have reviewed some of the search forms already posted but I do not understand how to apply what was done to my database. Also having a problem uploading the database here to be viewed. Got so far as to be listed...

relationships: cant figure out how to upload database the relationship is CaseNo from tblCase to PLCaseNo in tblPlaintiff and !! CaseNo from tblCase to DECaseNo in tblDefend one to many connecting by CaseNo in each table

I have created two subforms fron two tables; tblPlaintiff and tblDefend subforms are in the main form "FMCase" all are connected (relationship) by the CaseNo one-to-many problem: after entering the case number in the FMCase, the subforms, PlaintiffSub and DefendSub both show the just entered...

I foud this on an old post (2006)

jdraw, I cant upload right now but just a basic question does the field on the record that you point your code to , does that have to be the primary key of the record or can you point to another field that is also unique

ok, I did boyh the codes post 2 and post 3 (changing the names) both produced all of the records being printed or previewed

jdraw what i meant was print the form that presently is open (because its the form with the print button) with the current record in view or current record

I am trying to put a print current record code behind a button on my form this code prints ALL of the records I want just the record that is currently being viewed in Form View Code DoCmd.SelectObject acForm, "Legal Process" DoCmd.PrintOut acPages, 1,1 be advised! this form record source is a...

yes, that is what I meant an officer might be assigned to more that one case but only one caseno per officer and I understand that I will probably have to add fields to each group to make a primary key and again the confusion, should these be auto number fields? tblPerson PersonID which is a...

the caseno is unique and never repeated although an officer might be assigned to more than one case the plaintiffs and defendants would be unique to one case although... a plaintiff or defendant might have another case with a different caseno and the legal office wants at least 10 places where...

these are the tables ans fields I have set up so far this is a database for a PD Legal Dept CaseNo (this is number is issued to each case from the PD, it is unique)00-000000 format text CourtDocNO ( additional number identify with caseno) DateReceived (date) TimeReceived (time need separate...

ok, having a YELLOW line issue this is yours strWhere = "LastName='" & Me.LastName & "' AND DateField = #" & Me.DateField & "#" not sure about the colons and pernthises ' " or " ' ran and this error came up runtime erroe 3075 syntax error in string in query expression 'LastName='100-SMITH...

I will be keeping my fingers crossed that is all that simple I will apply it at work tomorrow thanks

can you have a code behind a command button to print a record with refference to two fields example: field> LastName = Smith field>Date= 05-01-11 now because mr smith has several orders and they are differentiated by the date that he made each order (on a subform) I have created a Report to...