Recent content by ChrisDo11

thanks.... its partially working now.. only once outlook opens i'm getting #mailto:doug@hotmail.com# behind the email address..... any ideas?

i'm sure this has been discussed before but i can't find anything when i search this forum. i have a listbox on my form which lists company name, contact, and email. the email feild in the table is a hyper link. i'd like to set up this list box so that when the user selects an item on the list...

It does work, only now i have to click on the name first, then the controltip text will work. i never had to do this before.....

is there a way that this feature can be shut off? my form had an "onmousemove" event that set the controltip text to display a company's information when the use paused the mouse on the company's name in the form. It was working fine, not it doesn't work.... i'm wondering if i could have changed...

thanks.... works great... as you can tell, i don't know much about access....

thanks for the reply..... i tried; Me.companyname.ControlTipText = "me![companystreet]" but it shows "me![companystreet]" instead of the actual street name.

controltip text?? i would like to use something similar to the controltip text feature. i have a form in which the user selects a company. the form enters this company into a table. the company name, street, city, province, are all different fields. only the company name is displayed on the...

thanks, i can get it working for the most part.... but i still get an access error message "the text you entered isn't an item on the list... select an item from the list or enter text that matches one of the listed items"... is there a way to turn these error messages off? or get rid of them?

not in list I have a drop down(unbound) on my form(transmittal) which looks up other records on the form(company names). the user selects a company from the drop down to send the transmittal to. All the transmittal info is saved in a table. I run into problems when i want to send a transmittal...

=[company name] & " " & [po box] & " " & [street] & " " & [city] & ", " & [province] & " " & [postal code] i'm using the above code to display table feilds in my report(transmittal report). some of the companies don't have PO Box numbers. When this happens i'm left with a space between company...

thank you, #2 worked fine, but i can't seem to get #1.... i have a field in my table for the area code only so i've been using the following in the "format" of the text box on the report. ([faxareacode],"(000)" am i still missing something?

i have a table with contacts. the table has an "area code" filed. I'd like to have the area code show up in brackets ie. (456)768-9088 on my report. is there a way of doing this? the only way i have found so far is to physically put brackets on the report around the "area code" field. i would...

muchly appreciated = appreciated very much! :D

works great guys! thank you both very much...... muchly appreciated.

SELECT [company information].[company name], [company information].[company id] FROM [company information]; i also have the following on the after-update; Me![PO Box] = DLookup("[PO Box]", "Company Information", "[Company Name]=forms![main form].[transmittal subform].[form].[company name]")...