Search results

post got lost somewhere when I chose to post reply so i wrote another, see below !

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

gezzzzzz, go get some sleep, check back tomorrow thank you very much Patty

oops, please read the one above you last entry sorry, just re read your instructions "Me.txtname should be changed to your control name." but isen't the control name the name of the persons name being entered? and there must be millions of different names that might be entered. names are...

ok, I put this in on the Update Query to put spaces before and after the "/" but does NOT delete all of the spaces Replace([Names],"/"," / ",1) amazingly it also put a space before and after all of the "&" now to work on the code to put in the form field "Names" to fix the sapaces Before UpDate...

Oh my, after checking the data in the Names Field, I noticed that when a first and last name were entered now there is no space between the names MARY SMITH to MARYSMITH this is not good, can we do the code without removing ALL of the SPACES everywhere? Plus.....if we can do this with the "/"...

highand wild, it worked, this is great! actually would like to make sure it stays this way with the "yet to be entered" data, so YES, I would need a code to place in the Names Field in the Form so that whenever a / is entered, a space will automattly appear before and after the / when the...

unfortunatly, I cannot impliment those changes to the database. I did not create this database, an officer did 11 years ago and has been used this way ever since. I just thought that there might be some code to change ALL of the name entries and possibly a code to put on the form field NAMES to...

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

OR....... I put the PRINT RECORD BUTTON at the bottom of the EMPLOY INFO page (below the subform position) and on the last field of the SUMMONS page (Location2) I add a code OnEnter? that when the operator presses ENTER after filling in the field the cursor will move back to the EMPLOY INFO...

well you were right, this does work perfectly thank you now to tidy up....if I do not want to preview the report before printing it do I just change acViewPreview to acViewNormal? and can I add to the print record code DoCmd.Close .........but I don't want to close the form...

DoCmd.OpenReport "myreport", , , "[SummonsID]=" & Forms![main form name]![subform control name].Form![control name] tried it....no go I think this might be important...... the only field that make officer jones SUMMONS records unique is the DATE field. So Officer jones has 3 SUMMONS records...

I think I uploaded a copy of my database

finally created a workable report called PEDESTRIAN ENFORCEMENT the report draws from the query I created to put the two tables together query also called PEDESTRIAN ENFORCEMENT Now to print JUST the record s I am viewing / record s meaning the OFFICER INFO and the SUMMONS record presently...

what if I put the print cmd button on the subform page instead of the EMPLOY INFO page created a report that has everything on 1 page , name of report is PEDESTRIAN ENFORCEMENT

DoCmd.OpenReport "myreport", , , "[BadgeNo]=" & Me.BadgeNo oK, BUT what if officer jones, badgeno 123, has 5 SUMMONS records? Will all 5 print because they all have badgeno 123 on them. can't use something like CURRENT RECORD to print JUST the ONE BEING VIEWED?

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

Hi Broken Biker, (I hope the name dosent imply a debilitating motorcycle accident?) I ride 03 Heratage Softail. Anyway....first off, I am not a programmer. I took a few extra Access 97 courses 6 years ago and never applied the knowledge till now (what I could remember, yea right!) So Boss asked...