Search results

Hi, I made this once and it's with Danish captions but it's quite simple, so have a look. It does what your asking for: http://www.parodux.com/wp-content/uploads/2011/02/Billeder.mdb

..about the parameter box then the form/report that opens has a recordsource and the criterias reference has the same problem!~)

your references are broke.... before would be something like: forms!frmcontract!andSomething after would be something like: forms!yourNewNavForm!NavigationSubform!andSomething just go in the macro for the buttons and change your references!~)

cancel out of the wizard... right click on the button, build event, code builder and welcome to vba!~)

in your query designer press the button marked with sigma, that will give you more options including max!~)

your code loops through your form and when the tag is "required" it will run the if and if employee and titel are filled it will run the sql. So what you need is a way of telling the procedure that you have already run the sql. If it's 2007 or 2010 you could use tempvars otherwise you could have...

send a mail and I will have a look!~)

Go into the query design grid and add your tables. Choose the fields you need from table1. Create a join between SellersRegNo in the 2 tables (PNGBill is right about the naming convention it's going to give you lots of trouble later). Right click the join and choose all records from table1...

great!~) ...it's a good trick.. you can also send commands into access this way...

yes!~) ...Tip: If you have a corrupted database and you can't get in... then use /compile it will often do the trick..

if you create a shortcut to your file then change the path in properties to path plus a space plus /compact then open with your shortcut when the db is not in use. You can also use a command like /repair and you can combine them!~)

if there's only one record you can use Report_Load and OnPrint (or isn't it Report_Page) but if there's more then you have to use conditional formatting and just make the letters white!~)

the controlsource on the different comboboxes have to picked from the fields available from the recordsource on the form!~)

Have you named your dropdownboxes to the names in my db or changed the code to your names?~) ...if you don't get it to work, let me know and I will have a look at your db!~)

No, not in tables.... And you can see the code by going to designview on the form. Right click on the choice dropdown, go to properties, click in the AfterUpdate field and then click the little button that appears!~) So the code executes after you update the dropdown and as you can see I...

An example!~)

I will give you a quick review!~) send to spg.eksperten@gmail.com

...after that then you can set all table Subdatasheets to [None] and then remember that with a network you get best performance if you have a copy of the frontend locally!~)

Somewhere in the access options for the current database depending on your version of Access there will be something like track name autocorrect... Uncheck it.. that might help!~)

Good point from Alan!~)