-
WSAlexya1
AskWoody LoungerLet me see if I can offer some assistance…
1. I am not sure why the ReadOnly flag is set, but I do know that it has happened to me when I’ve copied to CD’s…
To remove the flag, open up Windows Explorer, browse to the folder where the file(s) were saved… select the file(s)… right click… select properties… and remove the check from the Read-Only box… click OK…Wish I could help with 2, but I know virtually nothing about mail merge links…
At least that’s a start…
-
WSAlexya1
AskWoody LoungerHave you tried holding down the shift key while opening it?…
It sounds to me like there may be something that runs on Startup and if there is an error it’s not opening the db window…Maybe I’m wrong, but it’s a thought… ??
-
WSAlexya1
AskWoody LoungerGeezzzz… Hans knows it ALL!
-
WSAlexya1
AskWoody LoungerMay 15, 2003 at 8:25 pm in reply to: Report–All Records Table 1; True/False Table 2 (Access 2000) #676962Thanks Hans! I figured it was something to do with the Table tag…
-
WSAlexya1
AskWoody LoungerMay 15, 2003 at 8:23 pm in reply to: Report–All Records Table 1; True/False Table 2 (Access 2000) #676961k… Here it is… You’ll see two tables… and one query… It shows the Left join and the calculated field…
In the results you’ll notice that Jim Jones has a False next to his CODE because he’s not been contacted (ie there is no record for him in table 2)HTH
-
WSAlexya1
AskWoody LoungerMay 15, 2003 at 8:11 pm in reply to: Report–All Records Table 1; True/False Table 2 (Access 2000) #676958I understood that…
Hang on… I’ll try make a quick sample database…
-
WSAlexya1
AskWoody LoungerPaul wants the results on a form Gary… A continuous form… I suggested the Main form (single)/ Subform (continuous) thing earlier today…. GMTA!
I ran out of ideas… -
WSAlexya1
AskWoody Lounger…Hopefully taking a WELL EARNED break!!
I know what you mean though… They’re great… I read these posts day and night now…
I think I’m hooked!!!!Have a great evening!
-
WSAlexya1
AskWoody LoungerThanks for clarifying that Gary! I knew it would be simple…
-
WSAlexya1
AskWoody LoungerHi Leighcoopster…
Maybe some of the Truly Wonderful gurus on here can help with that description, but I want to help if I can
…
Could you give me a bit more information?
What does the error message say?… Can you give us a few more specs on how the tables are joined and what sort of data is involved?What does “all the sudden I cant add results to any query I try to form with more than one table” mean? … By results, you mean??
-
WSAlexya1
AskWoody LoungerMay 15, 2003 at 7:39 pm in reply to: Report–All Records Table 1; True/False Table 2 (Access 2000) #676941Oops…. It didn’t show the Table2 name in the square brackets…
Okay… I’ll use “tbl2” for this purpose…The calculated field syntax was supposed to look like this…
fldExists: IIf(IsNull([tbl2].[ClientCode], “False”, “True)
-
WSAlexya1
AskWoody LoungerMay 15, 2003 at 7:33 pm in reply to: Report–All Records Table 1; True/False Table 2 (Access 2000) #676936You’ll need to make a query for this report…
- Table 1 needs to be Left Joined with Table 2 on Table1.ClientCode = Table2.ClientCode (this will select all Clients in Table 1)
- Then add both ClientCode fields to the query design… (Table 1’s ClientCode will always have a value in it… but Table 2’s ClientCode field will be Null if that client doesn’t exist in Table 2)
- Then create a calulated field such as… fldContacted: IIf(IsNull(.[ClientCode]),”False”, “True”)
[/list]This should give you a list of all clients with a True or False value for whether they’ve been contacted or not…
Obviously you’ll have to add any other fields you want to see… and use your own names for the tables and fields…HTH
-
WSAlexya1
AskWoody LoungerPaul,
Why not try using the * wildcard character?
Maybe something like: IIf(IsNull([Forms]![MasterMenu]![CatCombo01]), Like “*”, [Forms]![MasterMenu]![CatCombo01])
Just a thought… Let me know if it works…
-
WSAlexya1
AskWoody LoungerHmmm…. Now you’ve got me thinking…
Truth is
, I put that database together on the fly and didn’t think it through completely… I probably created the table in Datasheet view first, threw some data in as I saw it would look, and when I went to go to Design View it probably said I had to save it first and then prompted me for a primary key….
However, generally I find it useful to have Separate Primary keys in most of my tables…. (even with foreign keys and/or composite keys)
One thought that comes to mind is… what if (for whatever reason) you wanted to see the last 20 records that were added to the table?… Maybe it’d never happen in your case, but this field would come in handy if that were needed… Sometimes I just add an autonumber field for sorting purposes (My clients sometimes have definite layout requirements for government reporting or whatever…) … Sometimes I just use the field during design and testing activities to quickly check what results I’m getting from queries, in which case I’d remove that field/key when I’m done with it…
Hans and you were right to change the relationships around a bit… I knew my example wouldn’t be exactly what you needed… I just thought it would help you get started…
Let me know if I can be of any further assistance okay?
-
WSAlexya1
AskWoody LoungerLucas,
Are you sure that you entered a valid Course ID? … Did you type it in or select it from the combo box – lookup list I added? … I tried it in Hans’ db and the first db I made… It worked fine for me in both cases… I notice that the table names havechanged to “tblStudentCourses”, “tblStudents”… is it possible that the relationships got messed up with you were altering the db?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
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
-
MS Office 365 Home on MAC
by
MickIver
22 minutes ago -
search by picture an not all that’s cracked up to be (Awaiting moderation)
by
Dru Fuksa
5 hours, 19 minutes ago -
Google’s Veo3 video generator. Before you ask: yes, everything is AI here
by
Alex5723
12 hours, 25 minutes ago -
Flash Drive Eject Error for Still In Use
by
J9438
13 hours, 58 minutes ago -
Windows 11 Insider Preview build 27863 released to Canary
by
joep517
1 day, 7 hours ago -
Windows 11 Insider Preview build 26120.4161 (24H2) released to BETA
by
joep517
1 day, 7 hours ago -
AI model turns to blackmail when engineers try to take it offline
by
Cybertooth
10 hours, 57 minutes ago -
Migrate off MS365 to Apple Products
by
dmt_3904
11 hours, 46 minutes ago -
Login screen icon
by
CWBillow
2 hours, 8 minutes ago -
AI coming to everything
by
Susan Bradley
9 hours, 44 minutes ago -
Mozilla : Pocket shuts down July 8, 2025, Fakespot shuts down on July 1, 2025
by
Alex5723
1 day, 22 hours ago -
No Screen TurnOff???
by
CWBillow
1 day, 23 hours ago -
Identify a dynamic range to then be used in another formula
by
BigDaddy07
1 day, 23 hours ago -
InfoStealer Malware Data Breach Exposed 184 Million Logins and Passwords
by
Alex5723
2 days, 11 hours ago -
How well does your browser block trackers?
by
n0ads
1 day, 21 hours ago -
You can’t handle me
by
Susan Bradley
21 hours, 44 minutes ago -
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
1 day, 14 hours ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
2 days, 22 hours ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
2 days, 2 hours ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
2 days, 23 hours ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
2 days, 23 hours ago -
Lumma malware takedown
by
EyesOnWindows
2 days, 11 hours ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
3 days, 8 hours ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
3 days, 8 hours ago -
Meet Gemini in Chrome
by
Alex5723
3 days, 12 hours ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
3 days, 12 hours ago -
Trump signs Take It Down Act
by
Alex5723
3 days, 20 hours ago -
Do you have a maintenance window?
by
Susan Bradley
2 days ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
2 days, 22 hours ago -
Cox Communications and Charter Communications to merge
by
not so anon
3 days, 23 hours ago
Recent blog posts
Key Links
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.