Search results

What i want to do here is have a button on a form which locks every field minus the date field for every new record, then the lock can be taken off by pressing another button. The idea of this is to make multiple record entries easier for the user so that the user will only has to alter the date...

Thanks kiwiman, when i done this i have both values in one query, however they are in one field and 2 records, instead i i want 2 fields and one record, how can this be done? EDIT: oops its ok i've used a macro to set a text box to the net value in a form

Hey, i have 4 tables in total three of which have a reltion with one another: 1.Client 2.Company 3.Function from these tables i have a query which has one field which conveys the total income in the remaining table called 'epenses' i have made a query which conveys the total outcome...

Hi people, in my database i have a table called tbl_function and a form called frm_function, what i am trying to do is check availability, so that when a button is clicked it will activite a macro to check if the input of the 'timein' 'timeout' 'location' and 'datein' fields on the form are...

sorry, frequency is not really the right word to use in this case its more of a 'running total', however i am trying an alternative method now - http://www.access-programmers.co.uk/forums/showthread.php?p=769287#post769287

ok thanks gizmo, now i have one last problem relating to my report: now as you can see the expression =sum(hours) totals all sets of hours for all facilites used, how do i go about making it seperate so instead of a total of 13 it would be divided up for each facility - 5 hours and 8...

Hey, How do i go about conveying a critera input in a text box, for example when openeing a report the report is linked to a query to it will ask for 2 dates you want to view data within, how could i put a header in like = 'dates between [criteria input1] and [criteria input2]' on the report...

Cumulative frequency and multiplying total by set criteria Hey Guys, i'm new here and i've come to ask a couple fo questions regarding a database i have recently been developing for a property letting company. ok firstly i have produced a report which will show each function date used in each...