Search results

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]")...

thanks for the reply..... i've done that, so i can see which record i'm selecting, but it still defaults back to the first record with that name.... not making any sense....

i have a combo box on my form which looks up company names in my table. Each company name has its own ID(autonumber), but the "company name" field sometimes has the same company name. This is for companies that have offices in 2 different locations. both records show up in the drop down, but no...

My main form automatically assigns each record an ID(autonumber), if info is entered into any of the subforms the subforms take on this same ID as the main form(Dlookup). when i exit the form and re-enter to start a new record the main form starts a new record, but any subforms show the last...

This one should be easy... yet i can't figure it out. i have a form with a subform. Both have a button to add new records. when the "add new record" button on the main form is hit, i'd like the subform to add a new record as well, instead of having to click it's "add new record" button...

thanks! seems it was a pretty simple thing after all... . i am still having one problem which is that when a new record is started the listbox doesn't update(clear iteself). is there a command that will clear the data in the list?