Search results

I did a compact and repair and it reappeared. Strange...

Just created another rule. I can go back in and edit the new one but still don't see the other one?

I created a rule on one of my fields and it's working just fine. But I don't see the rule to edit it? I know the rule must be there because it's working. What am I missing... Thanks.

I do use DLookup

I get this error once in a while. Have to stop and restart the front end where I'm working. Run-time error 3048, Cannot open any more databases. Any ideas?

Could you give me an example? Are you using the wizard? Got it. Thanks!

I got it. Thanks!!

Yes. I see the problem. It works in the detail section but I need it at the end of the report.

I'm getting an #error?

I have a report that uses =Count that counts the records. Works fine but how can I make it count this? I have 7 records but need to count the other three too. Those happen to be on the same record. So, I want it to count those. So, below should be 10. Thanks.

I have a form with a check box that I use when I run a query. I'm able to pick off records that are true. I use it to run a report. How can I create a query that would un-check or make that field be false for all records that are true? I don't want to delete the record, just un-check the box...

Got it.

Thanks

I see... Would it look like without the returns and breaks?

Got it. Is there a way to combine it on one line? With And?

How do I combine these into one statement? I'm getting a type mismatch error. If [Mtest].Enabled = True Then [Mexam4] = [Msample1] & ".PDF" And [Mexam5] = [Msample2] & ".PDF"

Seems like the null or empty or "" is not working or proper.

No, it seems to go by the first part and give me the Else. Even though Mssampleid1 is null or empty.

What is the best way to state this? If [Msampleid1] = "" Then [Mlink2] = "#" & "\customers\" & LCase([Msampleid]) & ".pdf" Else [Mlink2] = "#" & "\customers\" & LCase([Msampleid]) & "-" & LCase([Msampleid1]) & ".pdf" Thanks.

Perfect!