My account: Login | Sign Up
Loading... 

Form has data locked - All settings set to "not locked" in microsoft.public.access.forms | Thread profile

Thread profile page for "Form has data locked - All settings set to "not locked" in microsoft.public.access.forms" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Form has data locked - All settings set to "not locked" in microsoft.public.access.forms", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity, which are reported in a table below. Additional thread profile information is also shown in the following ways:

1) Top Contributing Authors
2) Related Threads on "eBay Auctions"
3) Related Threads on Other Sites

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a thread's popularity and/or exact posting volumes at any given reporting period.
Title: Form has data locked - All settings set to "not locked" in microsoft.public.access.forms
Site: Discussions in microsoft.public.access.forms  Discussions in microsoft.public.access.forms - site profile
Forum: microsoft.public.access.forms  microsoft.public.access.forms - forum profile
Total authors: 4 authors
Total thread posts: 8 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Thread posts in Form has data locked - All settings set to "not locked" in microsoft.public.access.forms:

1. 
Started 1 month, 4 weeks ago (2008-10-06 07:41:00)  by BlueWolverine
Hello, MS ACCESS 2003 on XP PRo. I have a form fed by a query fed by a query fed by a query... basically it's a bunch of nested queries. I thought that form based on this query chain would back fill data backwards to the tables eventually. So my question is: Is there a way so that edits to the form data will...
Size: 1,080 bytes
Customize:  Customize "Form has data locked - All settings set to "not locked" in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
2. 
Started 1 month, 4 weeks ago (2008-10-06 07:55:00)  by Golfinray
I think it will get back to your tables. Somethings I have seen information become slightly modified when it has to go back through several queries, especially yes/no fields. "BlueWolverine" wrote: > Hello, > MS ACCESS 2003 on XP PRo. > > I have a form fed by a query fed by a query fed by a query... basically ...
Size: 1,451 bytes
Customize:  Customize "<b>Reply 1</b>: Form has data locked - All settings set to &quot;not locked&quot; in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
3. 
Started 1 month, 4 weeks ago (2008-10-06 08:08:00)  by Clif McIrvin
"BlueWolverine" <BlueWolverine@discussions.microsoft.com> wrote in message news:7123610F-6797-4825-B4D7-315AD29562D2@microsof t.com... > Hello, > MS ACCESS 2003 on XP PRo. > > I have a form fed by a query fed by a query fed by a query... > basically it's > a bunch of nested queries. I thought that form based on this query...
Size: 2,361 bytes
Customize:  Customize "<b>Reply 2</b>: Form has data locked - All settings set to &quot;not locked&quot; in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
4. 
Started 1 month, 4 weeks ago (2008-10-06 09:15:00)  by BlueWolverine
My UNION Query is non-updateable. Is there any way to change this? My boss is 99% sure that Union queries are just not-updateable. Here's the SQL in case it matters. SELECT q_FuelCardInfo_Assigned.FuelCardSource, q_FuelCardInfo_Assigned.FuelCardProvider, q_FuelCardInfo_Assigned.FuelCardNo, q_FuelCardInfo_Assigned.AccountNo...
Size: 4,468 bytes
Customize:  Customize "<b>Reply 3</b>: Form has data locked - All settings set to &quot;not locked&quot; in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
5. 
Started 1 month, 4 weeks ago (2008-10-06 09:56:00)  by Clif McIrvin
"BlueWolverine" <BlueWolverine@discussions.microsoft.com> wrote in message news:5B2004D0-540A-4E7F-8811-D50CB50354F1@microsof t.com... > My UNION Query is non-updateable. Is there any way to change this? > My boss > is 99% sure that Union queries are just not-updateable. I believe your boss is correct. Can you rework...
Size: 4,649 bytes
Customize:  Customize "<b>Reply 4</b>: Form has data locked - All settings set to &quot;not locked&quot; in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
6. 
Started 1 month, 4 weeks ago (2008-10-06 10:17:00)  by BlueWolverine
Getting fancy with the OR statements worked pretty well. I like that, thank you. -- BlueWolverine MSE - Mech. Eng. Go BLUE! "Clif McIrvin" wrote: > "BlueWolverine" <BlueWolverine@discussions.microsoft.com> wrote in > message news:5B2004D0-540A-4E7F-8811-D50CB50354F1@microsof t.com... > > My ...
Size: 5,456 bytes
Customize:  Customize "<b>Reply 5</b>: Form has data locked - All settings set to &quot;not locked&quot; in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
7. 
Started 1 month, 4 weeks ago (2008-10-06 10:28:00)  by Linq Adams via AccessMonster.com
For once the boss is right! ;0)> Here's the link to Allen Browne's list of thnigs that make a query Read-Only: http://allenbrowne.com/ser-61.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com...
Size: 883 bytes
Customize:  Customize "<b>Reply 6</b>: Form has data locked - All settings set to &quot;not locked&quot; in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
8. 
Started 1 month, 4 weeks ago (2008-10-06 11:15:00)  by Clif McIrvin
"BlueWolverine" <BlueWolverine@discussions.microsoft.com> wrote in message news:EEFB092B-21D2-49E3-8804-C8CDE375A6EF@microsof t.com... > Getting fancy with the OR statements worked pretty well. I like that, > thank > you. Great! -- Clif > -- > BlueWolverine > MSE - Mech. Eng. > Go BLUE! >...
Size: 6,548 bytes
Customize:  Customize "<b>Reply 7</b>: Form has data locked - All settings set to &quot;not locked&quot; in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
 

Top contributing authors for Form has data locked - All settings set to &quot;not locked&quot; in microsoft.public.access.forms

Name
Posts
BlueWolverine
3
user's latest post:

Published ()
Clif McIrvin
3
user's latest post:

Published ()
Golfinray
1
user's latest post:

Published ()
Linq Adams via AccessMonster.com
1
user's latest post:

Published ()

Why is microsoft Access not not taking the regional...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Why is microsoft Access not not taking the regional settings? in microsoft.public.access
Why is microsoft Access not not taking the regional settings? in microsoft.public.access
Pivot data field settings seemed to be locked? in...  Discussions in microsoft.public.excel.misc - site profile microsoft.public.excel.misc - forum profile Pivot data field settings seemed to be locked? in microsoft.public.excel.misc
Pivot data field settings seemed to be locked? in microsoft.public.excel.misc
Security settings for access 2000 in microsoft.public.access  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Security settings for access 2000 in microsoft.public.access
Security settings for access 2000 in microsoft.public.access
Unable to access database - locked in...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Unable to access database - locked in microsoft.public.access
Unable to access database - locked in microsoft.public.access
Records still locked in microsoft.public.access.multiuser  Discussions in microsoft.public.access.multiuser - site profile microsoft.public.access.multiuser - forum profile Records still locked in microsoft.public.access.multiuser
Records still locked in microsoft.public.access.multiuser
Couldn't update; currently locked in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Couldn't update; currently locked in microsoft.public.access.modulesdaovba
Couldn't update; currently locked in microsoft.public.access.modulesdaovba
Row in Database locked in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Row in Database locked in microsoft.public.access.modulesdaovba
Row in Database locked in microsoft.public.access.modulesdaovba
VBA Project Locked in microsoft.public.access.modulesdaovba  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile VBA Project Locked in microsoft.public.access.modulesdaovba
VBA Project Locked in microsoft.public.access.modulesdaovba
Loading settings fails (Access is denied) for domain...  Discussions in microsoft.public.windowsxp.security_admin - site profile microsoft.public.windowsxp.security_admin - forum profile Loading settings fails (Access is denied) for domain accounts in microsoft.public.windowsxp.security_admin
Loading settings fails (Access is denied) for domain accounts in microsoft.public.windowsxp.security_admin
Loading settings fails (Access is denied) for domain...  Discussions in microsoft.public.windowsxp.setup_deployment - site profile microsoft.public.windowsxp.setup_deployment - forum profile Loading settings fails (Access is denied) for domain accounts in microsoft.public.windowsxp.setup_deployment
Loading settings fails (Access is denied) for domain accounts in microsoft.public.windowsxp.setup_deployment