Replies

Let 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…

Have 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… ??

Geezzzz… Hans knows it ALL!

Thanks Hans! I figured it was something to do with the Table tag…

k… 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

I understood that…

Hang on… I’ll try make a quick sample database…

Paul 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…

…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!

Thanks for clarifying that Gary! I knew it would be simple…

Hi 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??

Oops…. 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)

You’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

Paul,

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…

Hmmm…. 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?

Lucas,

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?