Search results

I have a form that includes a subform. The screen view and the print preview show the subform data ordered according to a field 'number' - this is correct. However when I actually print the form the subform is ordered according to the order I entered the data - I guess the primary key ID. Why...

I have a text box that has todays date displayed. How can I get it to display the first day of the month i.e. instead of the 16/12/2006 it shows 01/12/2006 thanks

fantastic, excellent got it to work now many thanks

sorry cannot get that Dbase to work. anyone any ideas regarding my problem?

Can't figure this one out. I am trying to get my query to show me which company's have not sent a supplier any money during a certain period. However if I have the following data abc company 1/10/02 £5 1/12/02 £10 an i search for any company who has not sent any money between 2/10/2 and...

got it now thanks

I have a form that has a start date field and an end date field and a client ID field. When I click a button to run a query I want the query to take the start date and end date and filter the query on those dates and also only supply data for the client ID at the moment when I run the query i...

if you click on the properties for the form - one of the Yes/No's is for Navigation buttons

I have a form which contains a subform. I want to be able to select a record on the subform and click a button to copy that record's data into the main form. At the moment the main form has the current record showing company, date and payment. The subform shows in datasheet view all the...

I have a form with a combobox to select a clients name and that pulls up that client in a subform and shows various records for the client. But it always opens up showing the first record and I want it to open up showing a blank record for keying in more data i.e. after the last record. Can you...

I have a query that when run asks for a client ID and then displays a total of funds for that client. I also have a form for each client's persobal details and I would like to have a command button on that form, that when clicked runs the query automatically using the client ID being used. I...

sorry don't understand that reply

I have a caption named original investment. I want it to be displayed as original investment at the column head not as original investment how do I do this? thanks

really? Basically I wanted to have a box on the form that would update as I typed in the data and I can do that using the formula you gave me. But I then thought that I could search on this data to find who has a disposable income more than such and such, although I suppose I could just use a...

weilerdo I have set up a query to work out the difference but that does not seem to help when I am inputting on the form. Michael J Ross if i change the control source of disposable income to income - expenditure it updates on the form but does not store the result in the field disposable...

Another simple question I have 2 fields income and expenditure i have a 3rd field disposable income how do I get disposable income to automatically change when I input income and expenditure in a form many thanks

one of my fields is called partner road in the class module when i enter me!partner_road I get a run time error 2465 cannot find field what do I enter for the field name? thanks

still have a problem one of my fields is called partner road when i enter me!partner_road I get a run time error 2465 cannot find field

sorted it now thanks

no got it to work now but only for the first command do i just type line after line of the commands then each after the other?