Search results

The field in the table is an Attachment data type. And, it's Access 2007.

I am unable to put Encrypt with password because of its size; the computer freezes. I tried creating another database with only tblDocument, but it still want import--it freezes. The table imports just fine if there is no password on the database. I tried creating a new data and putting...

I've never used the On Paint function. Do you have example of this that you can post that I can see visually?

Unfortunately, my memory is not that great like yours :)! I know I did something but I can't remember what db or form or report. It'll come back to me as I move a long.

No, I don't. I tried pulling up a couple of dbs but they were not the one. I know I did it, but just don't remember. Let me search some more.

Yes, that is correct.

I have an Image21.Visible = No on the main report that I want displayed if there is no phone number for a record. On rsubTelephone report I went to On No Data and entered: Reports!rptCompanyProfile.Image21.Visible = True but it does nothing. Should I set this up another way?

That did it, thanks a bunch!

Thank you, thank you!

I need to create requery that will list all addresses from tbladdress with the company name. If there is no company name (due to blind ads), it should list the CompanyID. In Query1 I added this calculated field: Company: IIf(IsNull[qryCompanyNameDefault]![CompanyNameTitle]),"Company ID " &...

Okay, I was thinking that you can have too many subforms and subforms are just hard to format to look like the other fields. Anyway this form will have six subforms.

Why is using a ControlSource slower than when you use a query? Meaning, I used the Concatenate function using the ControlSource of a text box and I created it using the query (which I put the subform on the form), the ControlSource lags behind the subform. Using ControlSource is easier and I...

Thanks vbaInet for all you help! You have given me some good answers and links; it is very appreciative to get accurate information.

I think I fix the problem; I went to CompanyID field and enter this as the default: =[Forms]![frmCompany]![CompanyID]

When I navigate to a record without any cross-references I get the following error: Error 3075: Syntax error (mission operator) in query expression 'CompanyID ='.

No, not really. I am just testing--not sure it is correct.

No, that's okay--seems like a lot of work. But, thanks for replying!

Okay, I built my query with: tblCompanyName CompanyNameTitle tblCompanyCompanyNameJunction CompanyNameID Type DefaultForCompany Is that okay? Because I noticed you used all three tables.

Okay, I did: =ConcatRelated("CompanyNameTitle","qryCrossRef","CompanyID = " & [CompanyID]) Is there a way to put 1, 2, 3... in front--meaning: 1) ABC123; 2) ABCxyz; and so on?

here it is