Recent content by captain1974

Ok, fixed it. I rebuilt the last subform using the wizard (actually one of the first things that I wanted to try but I was initially using a work computer with a 'compact' version of office which doesn't have all the Access wizards), and it all works fine without requery event procedures. Can't...

Due to other work commitments I have not been able to work on this problem for the last few days, but having another look now. I have tried writing a requery procedure in the afterupdate event with no success. My main form is called frmEnterBudDissection this contains a subform called...

Thanks, that partially fixes the problem. Now when I select from the first combo (Vineyard) it requeries the subforms as long as there is no data that is relevant to that 1st combo/vineyard. However, I don't want any data to appear unless it is specific to the 2nd combo box (block). So this...

I am having difficultly refreshing records in subforms. I have a main form with 3 subforms, all junior to each other. I have tried the advice in this thread http://www.access-programmers.co.uk/forums/showthread.php?t=124648 with no success. I'm not sure if it is because I have 4 forms in...

I was wanting to do something similar and found this post: http://www.access-programmers.co.uk/forums/showthread.php?t=121021 Not sure if this is the final word on this?

Thank you very much RuralGuy, deleting that record has solved the problem. Is there a way to automatically delete blank records such as these without going into the table to find them? I think this particular case came from a record being entered in the wrong place and then hitting backspace...

From the switchboard menu, select Reports > Maturity Results. Otherwise fdlgMaturityFilter from the database window.

I've tried commenting out the error handling with no success. You can download the db here (as is too big to post to this site): http://www.ahaviticulture.com.au/rdp If you are able to have a look.

As far as I can see there are error handlers in the code, but not to handle the errors in question. The code was based on http://www.fontstuff.com/access/acctut19code5.htm and I am still very much a learner with VBA. If posting the db will help then I can do so (what is the easiest way to...

I have selected 'Break on All Errors' but it is not going into Debug.

It doesn't go into Debug, so I don't know. Actually after the error message it sometimes either performs the filter or closes the report.

Thanks, I unfortunately can't follow that work-through as the original machine has been sent away for repair. I don't think I selected any unusual references though. (ADO 2.7 I know was selected on both machines)

Thanks Bob, Not sure why I had an Integer as a String, I wrote that function a while ago. Correcting it hasn't made any difference to the error though.

I have set up a report filter based on the example by Martin Green: http://www.fontstuff.com/access/acctut19.htm This was all working very nicely indeed, without any errors. However, I have transferred the database from one pc to another (using an external drive) and I am now receiving the error...

This chart isn't my main reason for the existence of the database that I am creating. I believe I have built (or part built) a database for all the right reasons of database functionality and features. However, it would be extremely useful if that feature of charting could be "manipulated" to...