Recent content by wyld

Okay...how about? IIf(isnull([Forms]![FindIt Form]![Title]) or [Forms]![FindIt Form]![Title] = "" ,"","Like [Forms]![FindIt Form]![Title]& "*" ")

Can't you just edit the macro and add the following line to sub LetterHead? Selection.Font.Size = 22 You'll have to set it back to a different size when you're done.

I agree with onedtent...use borders. It's the only solution I've ever found.

I didn't notice you were using Access 2000. Try IIf([Forms]![FindIt Form]![Title] = nothing,"","Like [Forms]![FindIt Form]![Title]& "*" ")

Try this... IIf(isnull([Forms]![FindIt Form]![Title]),"","Like [Forms]![FindIt Form]![Title]& "*" ")

I have an Access 97 database that will contain multiple applications. Each application will have a separate group permission set up. Now the hard part, how can I check the user is part of the group? Thanks in advance

The headings for group 1 show: account location claim number patient name The heading for group 2 shows the patient name. The heading for group 3 shows the source. The heading for group 4 shows the invoice. Each account has multiple locations. Each location can have multiple patients. Each...

I have a report that has 4 groups and detail section. Group 1 - Claim Group 2 - Patient Group 3 - Source Group 4 - Invoice I want a page break when the Claim changes. Sounds simple enough but if the person has more invoices that what fit on one page, I get one page with the Claim (blank on...

In my Access 97 database, I have a table 'Claim_Files' that contains information about specific people in multiple groups. I want to take this table and get all their claim information. Their claim information is stored based on what group they belong to. Each group is a separate table stored...

I have a form that uses 4 reason codes. Based on the reason code, different fields are visible/invisible. Two of the reason codes (A and B) using the same combo box but display different values. Based on the reason code, I want to use a different query to get the information for Error Reason...

Thanks for your help...I knew there had to be a way to do this. *s*

I have multiple Access 2000 databases. Is it possible to copy the import specifications from one database to another? Thanks!

Thanks! It worked like a charm. *s*

Sounds easy but how do you do it (other than doing a print screen)?

I tried that, but I keep running into the problem of different sheet sizes. Ctrl-A doesn't work. Is there a way to specify the last occupied cell?