Search results

Set all 3 sub forms to be invisible: On_Current if me.FeePercent.value = 50% then subfrm50%.visible=True Elseif me.FeePercent.value = 40% then subfrm40%.visible=True Else me.subfrm0%.visible=True End if

You need to use a report with a page break. use parameters in the query[InvRange] to [InvRange] and then you will have no problem.

y dont ypu create one form based on th table and then put a tabbed form control on the form and then add fields where u want them

The code is useful but if you determine beforehand which fields you need in CAPS then just set the table properties to >

after update me.combo.requery

One way to do this would be to have a 2 date fields in the table that holds the condition started and condition closed. Assuming that the item can only be in one condition at anyone time. What you can do is return a query that only shows items with no condition start and condition closed OR...

even before table sructure, clearly define the inputs, outputs required. The business rules and data types. System performance. Licencing. and then think about learning some VBA. Basically you need some good User Req Spec.

catcoota, Have u tried compiling the mde into washing machine code? If u can then I am sure you can crack the password clean without any annoying stains!

Rich, That is a classic, you are the main man from now on!!!!

there is one method that overides all access security but it takes a little time. if you press the following key combination the security will be overidden: Ctrl+P,Ctrl+S,Ctrl+N,Alt+F4

without looking at the db and table structure I think that you need to change the integrity of the tables. Either only one project can only have any one document (no duplicates allowed) Or change the rules to allow duplicates.

u 1st grouping should be Company. 2nd grouping should be SalesmanNumber Detail Section should be PassengerLastName on the 1st group u can create a footer, put no data in and then force new page after section. Thiswill keep the Company data together.

1st put a db on with all the queries and tables u refer too????

here u go!

Create the same query and in the ID (Primary Key) - Autonumber field criteria RightClick and then build a link to the form ID (Primary Key) - Autonumber and then build the report on that query and then it will only return that record. post the db and i'll do it 4 u?

On the query that creates the report for the particular individual report in the criteria reference the form unique record id, which should be something like computerno? post the db if no joy and it will get looked at!

where is the db?

Point1: Create a query with the Contacts table, Classes Taken table etc(all the tables that you want data from. Next create a query using the query wizard and select the query and all the fields you want. The wizard will ask you for groupings and this is where you select contact(pk) and then...

OMG - what planet is this person on!!! Try this link instead: www.useahammertocrackaccesssecurity.com

why don't you try the following: www.ripoffdontlearn.com