Search results for query: *

Create a record in access 97 and saving it via SQL server the server is adding a chr(0)to the end of a text field. for Example Milk = charcters and read it back fomr SQL SERVER the lenght is 5 character which one is hidden. Does anyone knows how to remove it.

I have a list of 500 customers with 150 fields for each of the records. I want to send an e-mail with all the 150 fields with their data to each customer for them to update, Perhaps in Excel format. Then I will received an e-mail back wit the updated Excel file, and I will update my db...

Are you using Excel?? Access???

try dlookup

Thanks, I searched and found the answer : thread68-804640 Sam

Thank you. I have used your suggestion and It works

I have a data file that has the ?(Alt Enter)when I am in the cell it displays a box. I want to remove this character. My import does choke when it finds this chacter

THANK YOU, YOU HAVE SAVE me A LOT OF STEPS. What I did before I would take the entire row and save it in a .csv and paste it into Word and replace all the commas with Carriage Return. ( These are several steps ) Thank you Thank you Sam

You can do this with Microsoft Outlook....

Click Details and clik on Filename

I have the following excel layout JOHN TED JOHN TED TED JOHN TED JOHN TED 8.5 4 8 11 12 48 84 8 4 I want to sorted in alpha and results are below: John 8 JOhn 8.5 john 48 John 8 Ted 4 Ted 12 Ted 84 Thanks again, Sam

I have a task that I need to figure out. I am trying to save many trese and have the ability to print emails directly to a PDF automatically. Can do this in the backgrounnd from the e-mail propgram and from a web application. Thanks, Sam

That's why I can't find the option. Thanks, Sam

Can anyone help on recalling an e-mail in 2000. I have search the web can't find the opt of reall this message. Thanks, SAm

Thank you guys, I turned my computer last night and tried different things and I got the solution. Column A5 will have the value of 109 Column B5 will have the formula =Time(0,A5,0) then I format the cell as hh.mm so I would get 1.49 Sam

Would someone tell me how I can type the value of 109 that will represent 1:49

I have create a Excel Pivot table component. I can only run this in my local computer and I will like to know How to run this remotely. Thanks, SAm

I have created an online pivot table and I need to put it remotely. It will only run on my local computer.. Help help! Thanks, Sam

Can I Combined the values into a single string as: "&AgencyId=40404&AgencyName=My Company&AgentName=Jeff Kirk" Thanks a again, Sam

I am a newbie. Do I stick the code inside the for statemnt????? Thanks, Sam