Viewing 15 posts - 1 through 15 (of 113 total)
With regard to creating views; I have not yet tried that but I suspect it would work. I had just hoped to avoid going to that additional overhead.
May 28, 2020 at 5:22 pm
I tried what you suggest - using the syntax to create the columns as hidden. While this does "hide" the columns in a select * from [tablename], by default, (it...
May 28, 2020 at 5:20 pm
I'm including this for the sake of completing the discussion since I think I've discovered the source of my problem. Using this version of the DDL I was not able...
May 28, 2020 at 5:15 pm
Thanks for the direction. I didn't include the code in-line initially because it is quite large (almost 1200 lines), and as I think about it now, would probably not run...
May 28, 2020 at 3:40 pm
Mmm... it appears I am unable to upload either a .sql file or a .accdb file. How unfortunate.
I tried to recreate the problem with simplified version of the table and...
May 28, 2020 at 2:23 pm
I too have experienced lost posts on the SSC site over the last while - since they changed the site.
Thanks for the reply.
I'm familiar with indexed views, however, the structure...
May 1, 2019 at 1:10 pm
Hello Wendell. Thank you for your response.
Sorry in advance for the lengthy reply. I don't even know that there's a clue in here...
You are correct that the field in question...
April 19, 2019 at 8:12 pm
I updated the title using the edit button and now the title is shown correctly but I can not see my original post and I can not see the post...
April 12, 2019 at 2:07 pm
Thanks for the response.
When I used that previously and saved my edit, my entire post simply disappeared - was no longer displayed on the forum listing. however, from the list...
April 12, 2019 at 2:03 pm
More apologies. I see that the title of this post is... vague. I intended for it to say "MS Access Me.Refresh doesn't work". Because of the problems I've experienced editing...
April 12, 2019 at 1:38 pm
This was removed by the editor as SPAM
April 12, 2019 at 1:19 pm
April 12, 2019 at 1:15 pm
April 12, 2019 at 1:13 pm
Wendell;Thanks again for your response. You've helped me in the past and I appreciate it.
I'm shocked/dismayed/disappointed that there isn't a better/simpler way to leverage the error reporting...
March 28, 2019 at 6:50 am
Wendell; thanks for your response. To answer your question; users are using a form. The errors mostly occur when a user navigates (accidentally tabbing from the last field onto the...
March 22, 2019 at 3:35 pm