Search results

Thank you very much indeed arnelgp - that has helped me enormously and just what I need. Pleased to se the VBA and learn a bit more about it. Very much appreciate the time you have put into this on my behalf.

Hi Pat - at the moment they are single types of projects - a user might choose to one or two additional tasks but the base list stands for all projects. The current issue is many projects at different stages and keeping track. I will change the names to conform so as not to give myself further...

Yes - thank you for the example. Thats further towards my goal than I was able to do! I have attached my db for your information. in Tasks - the first 29 tasks have a ProjectID of 1 and I have worked out how to select those with a query. What I then need to do is, after the creation of a new...

I have a list of schools for which we manage property projects. Each project has the same default set of related tasks. I want to be able to start a new project for a school (chosen from a combo box) and have set of tasks attached to it. tblSchool Primary Key= EID tblProject Primary Key =...

Absolutely perfect. Thank you very much.

Sorry I didn't explain myself clearly. There are many records over several years. I need to return all records with a date from the current day back to the previous June 1st, which may be in the current year if we are in October, or the previous year if we are in March. I don't want to specify a...

I need to return dates that occurred between today and the previous 1 June (the start of the financial year). Can anyone help as I seem to be spending lots of time and getting nowhere.

Paul I didn't notice but I should have - the little things make the difference. I used the expression builder to enter the values... thank you to you both

I can't seem to get the right syntax - I've created a text box in the orders form to retrieve the email address via the dlookup =DLookUp([tblfarmdetails]![emailadmin],[tblfarmdetails]) but it returns #Name error. What am I doing wrong?

Thankyou, I will try it.

Can you use a dlookup when there is no relationship, and you are just retrieving the only record in the unrelated table?

I have a table that holds company information for the user - eg farm name, company name, manager, phone number and email address etc. Its simply used to provide headers for reports, so that the same generic database can be used on several farms. There is only one record in this table...

Thank you again. I understand the process now (at least for that challenge) and can apply it to several other forms.

That worked perfectly! Thank you very much indeed. Can you explain why I can set the default value in the mastitisid field to equal that of the current record on the main form but cannot do so for the date? To help me understand the workings of it all a bit further...

I have all the calculations that determine when a cow can go back in the milking herd based on withholding periods of drugs - that is given in other reports and forms, as are details of current treatments. Its just trying to streamline daily data entry for repeated treatments to increase the...

So heres a cut down version of the db with the appropriate tables. Please not that I have removed buttons and links not related to the issue. Forms: Treatments Current Edit is the current system and working well. However in order to streamline I want to go to something more like Treatment Check...

I'll pare it down to the relevant tables and put it up. It seems that it may be the placing of values into the form that is causing the issue. Is there perhaps another way to get those two values in as a new record I wonder?

I have enter the following in default values, for the text boxes in the form (not in the table itself: in mastitis id =Forms!Treatment Check off!mastitisid and in thetrtmntdate Date() I can add records both manually and using the current form/ 2 subforms system (the one I wish to replace) where...

Following the train of thought - I created a new form based on the table with the wizard. The new record navigation button disappeared when I added the default values for the fields....

The record source is the table trmntrecords...