-
WSjaf90
AskWoody LoungerUsing an append table worked great – thanks
-
WSjaf90
AskWoody LoungerUsing an append table worked great – thanks
-
WSjaf90
AskWoody LoungerI’m not familiar with DAO or ADO.
The option of using an append query sounds a possibility – I’ll investigate that one further.
Yes, the PODel table is linked to a table in another database.As I right in thinking that once I’m working with one dataset (I know as much about datasets as I do about DAO and ADO) the only way to add to another table is via this route of an append query or the DAO ADO option
John -
WSjaf90
AskWoody LoungerI’m not familiar with DAO or ADO.
The option of using an append query sounds a possibility – I’ll investigate that one further.
Yes, the PODel table is linked to a table in another database.As I right in thinking that once I’m working with one dataset (I know as much about datasets as I do about DAO and ADO) the only way to add to another table is via this route of an append query or the DAO ADO option
John -
WSjaf90
AskWoody LoungerOpen WSord…get blank Document`
Double click on desktop replaces Document1
I’ve checked for add-ins
I’ve checked for other macros being loaded
I’ve deleted the normal.dot to start afresh
None of the above seems to speed up the loading
Move on to next version of Office?? -
WSjaf90
AskWoody LoungerOpen WSord…get blank Document`
Double click on desktop replaces Document1
I’ve checked for add-ins
I’ve checked for other macros being loaded
I’ve deleted the normal.dot to start afresh
None of the above seems to speed up the loading
Move on to next version of Office?? -
WSjaf90
AskWoody LoungerJune 9, 2003 at 3:56 pm in reply to: Is there anyway of searching for records on a page (Access2000) #683891I’m sure there will be plenty of other methods which much more able people than me will post, but the easiest way i have found is to use an unbound box and query on its contents
-
WSjaf90
AskWoody LoungerMarch 12, 2003 at 2:42 pm in reply to: save turns into save as (version 5, word 2000 professional) #660621Check the location of your user templates and workgroup templates. Though you may not have write permissions to your workgroup templates, someone else may. This can cause a problem if someone else changes the template while you are using it – if they have changed the toolbars, then you will feel the effects.
The only way to protect this is to make the workgroup templates read-only for everyone. Any changes can then only be made when by copying across a new version of the workgroup template while no one else is using the original.
To test this, try changing the location of the workgroup templates to an empty folder – see if you get the problem – if not, then hit the IT department and give them the solution
John -
WSjaf90
AskWoody LoungerI just didn’t appreciate that the normal view sent direct to the printer – not sure what else i expected it to do, but i’ve only just moved into using VBA instead of macros – getting there slowly
-
WSjaf90
AskWoody LoungerThanks for getting back so quickly.
I understand the idea of building a criteria line, but not the “how to”.I don’t know how to reference the entries in the list box to see if they have been selected or not.
There is/are a variable number of lines per factory, so I can’t reference them as line01, line02, line03 etc
I was expecting to have to do something like the following:
start at the top of the line list box
if not the end of the list
if the line has been selected
run report using the factory, date and this entry for line
endif
move down the list
endifI know the syntax of the above isn’t right, but it’s the thought that counts
Anyone give better guidelines for what it should be?
John
-
WSjaf90
AskWoody LoungerFebruary 20, 2003 at 12:01 pm in reply to: Check if a form is already open using macro (2000) #655024thanks all for your help – i’ve pieced together enough to sort the problem from your replies
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Discover the Best AI Tools for Everything
by
Alex5723
9 hours, 9 minutes ago -
Edge Seems To Be Gaining Weight
by
bbearren
3 hours, 55 minutes ago -
Rufus is available from the MSFT Store
by
PL1
20 hours, 7 minutes ago -
Microsoft : Ending USB-C® Port Confusion
by
Alex5723
22 hours, 16 minutes ago -
KB5061768 update for Intel vPro processor
by
drmark
4 hours, 41 minutes ago -
Outlook 365 classic has exhausted all shared resources
by
drmark
52 minutes ago -
My Simple Word 2010 Macro Is Not Working
by
mbennett555
18 hours, 2 minutes ago -
Office gets current release
by
Susan Bradley
20 hours, 39 minutes ago -
FBI: Still Using One of These Old Routers? It’s Vulnerable to Hackers
by
Alex5723
2 days, 10 hours ago -
Windows AI Local Only no NPU required!
by
RetiredGeek
1 day, 19 hours ago -
Stop the OneDrive defaults
by
CWBillow
2 days, 11 hours ago -
Windows 11 Insider Preview build 27868 released to Canary
by
joep517
2 days, 21 hours ago -
X Suspends Encrypted DMs
by
Alex5723
2 days, 23 hours ago -
WSJ : My Robot and Me AI generated movie
by
Alex5723
2 days, 23 hours ago -
Botnet hacks 9,000+ ASUS routers to add persistent SSH backdoor
by
Alex5723
3 days ago -
OpenAI model sabotages shutdown code
by
Cybertooth
3 days, 1 hour ago -
Backup and access old e-mails after company e-mail address is terminated
by
M W Leijendekker
2 days, 13 hours ago -
Enabling Secureboot
by
ITguy
2 days, 20 hours ago -
Windows hosting exposes additional bugs
by
Susan Bradley
3 days, 9 hours ago -
No more rounded corners??
by
CWBillow
3 days, 4 hours ago -
Android 15 and IPV6
by
Win7and10
2 days, 18 hours ago -
KB5058405 might fail to install with recovery error 0xc0000098 in ACPI.sys
by
Susan Bradley
3 days, 21 hours ago -
T-Mobile’s T-Life App has a “Screen Recording Tool” Turned on
by
Alex5723
4 days ago -
Windows 11 Insider Preview Build 26100.4202 (24H2) released to Release Preview
by
joep517
3 days, 18 hours ago -
Windows Update orchestration platform to update all software
by
Alex5723
4 days, 7 hours ago -
May preview updates
by
Susan Bradley
3 days, 18 hours ago -
Microsoft releases KB5061977 Windows 11 24H2, Server 2025 emergency out of band
by
Alex5723
3 days, 10 hours ago -
Just got this pop-up page while browsing
by
Alex5723
3 days, 23 hours ago -
KB5058379 / KB 5061768 Failures
by
crown
3 days, 20 hours ago -
Windows 10 23H2 Good to Update to ?
by
jkitc
2 days, 22 hours ago
Recent blog posts
Key Links
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.