Search results

Hi, I would like to know how can you set the cursor to move from on text box to another? I.e. how can i control its movement? I want to set a specific path for the data to be filled in. Currently, on my form( which is in a Continuous Forms view), when the Tab button is pressed the cursor jumps...

hi, I have created a database which is a ,file management system, for a solicitors firm. It does the following: 1) Store client details 2) Do time recording 3) Prepare invoices Now they have asked me to integrate an appointment booking system into the database. Basically, it needs to be able...

Hi there, I have a sub-form called frmLegalAidLedger on a form called profile, the sub-form has a field called Category. I have a report which separates all the categories and then gives a total, however i need something which just gives you a total for each category which is already on the...

I don't think so as the total in my report is based on a few different fields which have different calculations, but i'll give an outline of what i did. To do the grand-total I: 1) Create a sum of total 2) Created another sum of a different total Then for the grand total, i used the Nz...

I tried that before, but it didnt work. However, by playing around with different formulas and methods I managed to create something that worked. Thank you for your help anyway :)

Hi, I have a report which has been grouped, i've managed to produce a formula which calculates the sub-total for each group. Now i need some way of producing a grand-total from the sub-totals, is there anyway of doing this? Thanks in advance

Hi missinglinq, Thats great, works perfectly! thanks :) btw, the field is called cboFeeEarner not fee earner so i should be fine :) Thanks for the help :)

Hi, I have a form(frmLegalAid), its default view is Continuous Form. I have a field called Fee Earner in a combox, i need some way of the value in the fee earner combox to automatically be transferred to the new combox when a new record is made. Is there anyway of doing this? If you need...

GP George thanks for your reply, At the moment i have 6 tables which are as follow: [Client Details]: name, address, telephone numbers, file number, the unique ID(autonumber) called Family ID [File info]: which has the file number and type of work then there are 4 different Rates tables...

Hi, I'm new to this forum and fairy new to Access. I have AS level (UK) understanding of MS Access and i need help! I need to create a database for a solicitors firm and it needs to do the following: 1) Open a new file (using their current file numbering system) 2) Store client details 3)...