Search results

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

ok Bob, I usually do just that when I am putting in a code behind a field On pervious versions of access, to put a command button on a form you would click on the command button and put it on the form and a wizard would come up and ask how you want this command button to work, simple on 2010...

thank you Bob, will give that a try I dont want a macro, I want a code but the macro builder thing comes up when I click on the command button to install

wanted to know if this is possible and if so what would the code be behind the Command Button ? can I have one button to save the subform data AND then print the REPORT generated from the subform data

Red, that worked just fine, thank you I hope that you can continue to help me, your description was easy to follow Without the programmer jarjon. I have put a command button on the subform to print a Report that is getting It's data from the subform it's on Wanted to know if I could move the...

Red, thank you, this looks like an easy fix but I know enough about Access to know that "this could be dangerous!" I appreciate the manner of your instructions (access for dummies) I needed that, thanks I am off work for two days, I will try this as soon as I return. Please stand by, I will post...