One of my tables in a ‘one to many relationship’ has stopped allowing me to add new records. I've just figured out I can add records by selecting sub-data sheet on the menu bar when I've got the main table open (the one on the ‘one’ side of the relationship) and ‘expand all’. I am then able to...
BUT NUTS...
It works!!!
Just got home and whatever happened (went wrong basically) when I tried it this morning - didn't happen tonight!!
How come it looks so flippin fantastically logical when it's right?
It's maddening!
Thanks again Gina.
No kiddin (that's US?)/ OMG (polite version) or Ooops..
Named and shamed!
BUT......
(sorry - there is still a problem but have just had to leave for work - UK time. Will post further tonight)
Thanks again.
OMG!!
Didn't think you used that expression in the US - thought it was a typical british thing (Essex thing) !!
Anyway - felt really stupid when I read your post - how could I miss this?? However, tried to replicate the Print Preview view but couldn't!!
Changed the default view to Print...
Gina,
Thanks.
Checking the database again today I noticed two essential lines of code missing ........
Option Compare Database
Option Explicit
I got home - and I added these - but it still didn't work!
In answer to the questions you asked -
1. I created a group footer in the report for...
Thanks but still nothing@!?
Looking at your code it did dawn on me perhaps I should have placed my sub report in the group footer which I have now moved but I still can’t get any code to trigger on any event. I looked at “Tools/ References” in the VBA window to make sure I had ticked all the...
Why is it so difficult to hide a sub report in a report when it has no data? I have seen a number of replies to simillar questions in this forum and they are all different and in my eyes don't have enough information to allow them to work. The nearest to a completion answer I have seen so far is...
Sean,
Brilliant - have never had a more constructive response in all the time I've posted on a forum. All the code, examples, tutorials - fantastic. All I need now is an hour or so to carry it over or translate it into the database I am using. Can't thank you enough.
Thanks Sean.
Jim
I think this is probably a waste of time anyway because as I understand it all the data for each of the controls on a subform is loaded even before the data for the main form but here goes anyway.
I have four tables - 1 is a list of users, 2 a list of manufacturers and 3 a list of products the...