Search results

If you remove "TBL_CLASSES_PAYMENTS_PUPIL_LISTBOX" fom the row source on FRM_CLASS_PAYMENT2 - this should fix the problem.

You should be able to use DLookup... Add something like this to the BeforeUpdate event in the zipcode field... City = DLookup("[City]", "zipcodetblname", "[Zip]= '" & Me!Zip & "'") State = DLookup("[State]", "zipcodetblname", "[Zip]= '" & Me!Zip & "'") * Adjust the fields to match your needs...

I still don't totally understand how your report and query works...However this attached database uses one report and one query...it changes the name of the to be saved .pdf file to the name of what is checked... I have CutePDF set as my default printer...If I have Allergy checked when the save...

Take a look at this sample database...By not knowning exactly how your database is setup I am not sure if this is what you are looking for. Hopefully it'll lead you in the right direction. The database is in an Access 2000 format however, is will work in Access 2007 as well.

The earlier option I spoke about was to be placed in the On Load event of the Report - I think the error came from it being in the On Open...but I am not sure it would work for this... When the form is loaded are the check boxes already checked or is this an option once the form is opened? I...

Are the check boxes a part of an Option group or just checkboxes? And what is the odds of having more then one box checked?

Not sure if I am understanding your question right... I think you are wanting the file to be named the same as the query... If so, just leave the Caption field blank in the Property Sheet of the report it should default to the name of the qry.

Could you not just use this on the button's ON CLICK event... DoCmd.OpenForm "Bookings", acNormal, "", "", acAdd, acNormal Forms![formtobeopened]![school] = Me.[School Name] Hope this helps

I would add a select button to frm1...doing so allows for changing ones mind...if you add it to the ON CLICK of the listbox the user will have to close frm2 and come back if they made the wrong selection... On the ON CLICK event of the button - you should be able to do something like this...

I have attached a sample database. This uses the InputBox method...However, it does hide the password. The sample database is in a Access 2000 format. It will work in Access 2007 as well. Hope this helps...

Glad I could help and good to hear you got it figured out...

There are several ways to do this... This being one of them... With this method when the password is typed it can be seen...Others make the password like **** Just wanted to give you some type of answer... On the "On Click" Event of your button to open the form just add this code...and...

If the row source of the listbox is something like this... SELECT Table1.ID, Table1.[1], Table1.[2] FROM Table1 WHERE (((Table1.[1]) Like [Forms]![Form1]![Comboboxname].[Text])); Add this to the After Update of the Combo... Me.ListName = Null Me.ListName.Requery Setting up a combo to listbox...

If you are speaking about having the second listbox show updated info after a selection is made in the first... In the After Update Event of the first list box - add this... Me.secondlistboxname = Null Me.secondlistboxname.Requery

How do you do what with a list box?

If I understand your question… In the After Update Event of the first Combo put the following...… Me.Combo2Name.SetFocus Me.Combo2Name.Dropdown Hope this helps

thx...I'll give it a try

Thanks for both replies... Unfortunately I did not design the database...It was here before me...I spoke to the powers at be about rewriting the database...They said whatever I decided would be fine with them...I wonder how long that will last :) Therefore I have already rewritten most of the...

Here is what I need to do… I have a table with 8 columns… Date | Order Number | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | How can I look at the Item 1 thru Item 6 columns and see how many times Part Number 45666 and 54667 were purchased together? The Part Numbers...

Well I have at long last gotten back to work on my database… LNewton…thanks for your reply. Using the Right function could solve part of my problem. It will work on my form however, let’s say the social security number is 111-11-1111… Here is how they want it to been seen on the report...