Search results for query: *

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...

...rstSSN recordset) Do While Not rstSSN.EOF 'Rebuild qryPassThru with actual SSN and dep code strSQL2 = "Select * From " & rstTbl("orig_table") & " where " _ & "clpartic = '" & rstSSN("PARTIC") &...

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?

I create a number of Excel spreadsheets then go in and manually format them to make them 'pretty' for the users. The spreadsheet size varies. I want to create a macro that will do the equivalent: - select all the cells on the active sheet (as if I was in A1 and did ctrl-shift-end) - create a...

I've heard the claims on what Speed Ferret can do. Has anyone used it? I'm looking whatever information you can supply. Does it meet its claims? How easy is it to use? Any problems running it? etc. Thanks in advance

I'm intheriting an Access 97 database that I need to change. I'm adding 4 fields to a table, tblPolicy. I want to find any queries, forms, reports, macros and modules that use this table so I know what will be impacted by making the change. Once I've identified what uses the table, I need to...

Thanks guys! Worked like a charm.

Thanks for the prompt help....I'll give it a try tomorrow. *s*