Search results

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

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

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

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

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

hello, just to let everyone know, I am NOT a database designer, I dabble! I am creating a database for a PD that I work for (writing tickets) so writing CODE is not my thing. Heres what I want; objective > supply office needs a database to keep track of uniforms issued with a print out of the...

Hello, Table name AccTable1 Form name AccTable1 Field name NAMES 1 Multiple people enter data into this database via the FORM 2 In the NAMES field, one, two and possibly more names are entered into one field. Names are sometimes last name only, some enter entire name 3 They seperate...

I have 2 tables and 2 corrisponding forms. I did the access magic and dropped form2 into form 1 to create from 1 with a subform (relationship one to many) table 1 is EMPLOY INFO w/ BADGENO key table 2 is SUMMONS w/BADGENO key The subform (SUMMONS) might have several records associated with one...

Hello, I have been here before so i'll try to make this as understandable as I can I have a MAIN FORM I have a DUI FORM I have a PED FORM I have TRAFFIC DATA PG2 FORM On the MAIN FORM I have check boxes to open other forms when needed Check Box name "PAGE2" when checked opens "TRAFFIC DATA...

I have a code that opens a MsgBox if the CASE NO already been entered, now I need the code for the "Yes I want to see this already entered record" I am working in Access 97 (no Wizzards are working) CASE NO is primary key in the CRASH DATA TABLE CASE NO if first field on CRASH...