Viewing 15 posts - 196 through 210 (of 274 total)
That is an easier case then as you know you are getting new data, so you can hide the subform control (set the visible property to No), get the data,...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
September 1, 2012 at 2:50 pm
The challenge in doing that is to know that the subform controls are displaying "=deleted" - it's not something I've ever attempted. If you can do that then you...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
September 1, 2012 at 2:19 pm
valeryk2000 (8/31/2012)
And one more: what is the best way dealing with "=deleted' on subform?
Unfortunately, I don't know of anything that can be done when that happens. But that only...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 31, 2012 at 8:32 am
valeryk2000 (8/31/2012)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 31, 2012 at 8:27 am
valeryk2000 (8/31/2012)
....
My serious (but may be naive) concern about linked tables: in a "simple" Access app form controls are linked to tables (or through queries) by DYNASET, that would change...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 31, 2012 at 8:12 am
rf44 (8/31/2012)
...Note: ADP is not supported in the recent versions of MS Access (2007 and beyond).
Actually, ADP is supported in Access 2007 and 2010 (see for examplehttp://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/795d5b36-6d8e-43e2-9d17-1a168c197adb), but rumor...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 31, 2012 at 6:58 am
valeryk2000 (8/30/2012)
==> If you are seeing the tables as read-only, chances are your userID in SQL Server doesn't have permissions to edit or append data.
But there is no problem...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 30, 2012 at 9:43 am
Regarding your question about linked tables, and whether they can be written to, absolutely yes. We have a number of systems deployed that used linked tables that are updateable....
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 30, 2012 at 7:14 am
Well, I'm afraid I'm not much help at this stage. I've not worked with "proxy tables" at all either in Access or SQL Server - from web research they...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 29, 2012 at 5:01 pm
That's quite an unusual design approach to creating a front-end to SQL Server. In general the recommendation is to either use an ADP front-end, although support in future versions...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 29, 2012 at 3:28 pm
It turns out that we were able to salvage the situation by creating a new Master database with a reinstall of the SQL Server instance, and then attach the replicated...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
June 19, 2012 at 11:35 am
The .accdr file extension is used to make the database file read-only and prevent changes to it. As you have discovered, changing it to .accdb lets you edit the...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
June 18, 2012 at 6:00 am
I've tested several combinations of OS and Access, and with the ADP format I always get the 2.5 version. Unfortunately I don't have SQL Server 2000 to test against,...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 25, 2012 at 5:48 am
peter478 (5/24/2012)
I didnt change references, they were set default.
Could be a problem with code pages setting in windows7 ? ...I am just thinking
...my access app e.g.(pp.adp) were...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 25, 2012 at 5:09 am
So what exactly do you want to happen with the OnLoad event on the form? Apparently it is working just fine on Win-XP, but not on Win-7. The...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 24, 2012 at 5:31 am
Viewing 15 posts - 196 through 210 (of 274 total)