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

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...

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...

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...

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

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

I have been struggling with this for weeks now and it must be fairly simple. I have a form linked to a table with the fields number road town and partnernumber partnerroad partnertown I input the first 3 fields and I would like to be able to click a command button and copy those 3 fields...