Viewing 15 posts - 16 through 30 (of 113 total)
Steve;Thanks for your response. I'm not sure I completely understand what you're trying to say...
only if the dependency is in a straight line, and that something early in the...
March 20, 2019 at 8:35 am
Thank you both for your responses. Perhaps a little bit of back story will help explain what I'm trying to do.
I have an MS Access database (2010) connected...
March 19, 2019 at 8:48 pm
The other thing to note is a that with the code in the Form_Load() event it doesn't actually get triggered if the form is open! I'm on the horns of...
December 27, 2018 at 9:51 am
Wendell;Thanks for the this information. At present, users run the Access front end from their local workstation. Our method of distributing updates is clunky but it works for us.
December 20, 2018 at 10:45 am
We are a government agency regulating energy resource development. We are "open" (we need to be able to be contacted) 24 hours a day. The time component of a transaction...
March 9, 2018 at 10:46 am
Thanks again for your reply. It will take me a little bit of time to investigate the suggestions that you and Celko (I'm presuming Joe Celko) have made. ...
August 3, 2016 at 10:43 am
Hello, and thank you to all of the respondents. I actually didn't think I was going to get anything, it had been a few days. I'm actually on...
August 2, 2016 at 11:11 am
You've hit upon the "twist" part. I could be approaching this wrong. I'm assuming a recursion approach because to me this looks like a classic instance of the...
July 26, 2016 at 2:53 pm
I noticed that my table definition for the [Business_Unit_Flattened] table was not quite right (some columns that should have been nullable were not) so I cleaned it up. Apologies...
July 26, 2016 at 11:37 am
I handle this scenario in databases I create by setting a default value of GETDATE() for DateAdded
I use an update trigger to set the value of DateModified.
April 16, 2015 at 2:10 pm
Thanks for following Wendell.
I will certainly review the references you have provided.
Much has transpired since my post.
I was never successful with a pass-through query since they are not updateable.
March 30, 2015 at 3:37 pm
Well, that didn't take long. No joy. The query is still not editable.
March 22, 2015 at 8:05 pm
The primary key of the main table was included. I have learned that in order for a query to be editable the primary keys of all related tables as...
March 22, 2015 at 8:04 pm
They are not passthrough queries at the moment. They are based on the linked tables. I did try to create them as passthrough queries but that made the form...
March 22, 2015 at 2:50 pm
Thanks so much for the link above. It's a good description/discussion of the issue. It certainly confirms my experience and discoveries. Unfortunately the link to the video,...
March 6, 2015 at 7:51 am