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...
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
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
I have below my code that has the array and I want to be able to maka a variable to combine all string below.
STRING
&AgencyID=101000057&AgencyName=Test%20Ccra&AgentID=10014&AgentName=jeff%20kirk&AgentEmail=jkirk@me.com
CODE
#print "\n";
#print "<hr>\n";
foreach $namevalue...
I have a single table in Access that contains customer information.
Some of the contact contain multiple numbers, for example:
Joe Smith 555-555-55555
Joe Smith 555-555-55555
Joe Smith 555-555-55555
Joe Smith 555-555-55555
Lin Smith 444-444-44444
Joe Smith 555-555-55555
Joe Smith...
I have a bingo card card 5 x 5 = 25 cells. The formula below works great. Can you please let me know how can I get 25 unique numbers. If I do it now I will get 2 or 3 repeat numbers.
=INDEX($A$2:$B$37,INT(RAND()*26),2)
3 5 2 23 4
3 17 22 0 18
16 1 8 24 0
24 14 19 5 24
23 10 4 8 6
Duplicate...
I am new to Perl. I have an Access DB that has a text field called AgencyID and when I use the insert command it trims the 00 and I need to have the leading zero to the left. Like 00343478 not 343478
$db2->Sql("Insert Into TempAgencyOpenClosedPortal (TransRecordID, CCRANumber, AgencyName...
I have an Access application that has a very lengthy hyperlink is there a way with SendObject to display Click Here for the hyperlink
http://www.abcdeff.com/documents/ht???=233/zzzz.htm
I want to display "Click Here"
Thanks
Can anyone knows how to create a click here button in outlook from Access.
Currently, I have the e-mail to and subject but in the body of the e-mail I want the following
http://www.xxxxxxxxx.com/program/id=32?/23.htm
and I want just to show only "Click Here" button.
Thanks,
sAm
I have a Master Excel File that has many columns see below for layout that I received. I want to create indpendent excel files for each of the companies. For Example Hilton HOtels may have 10 lines and I want to create an Excel file with the 10 lines w/all the fields from he master file, and...
I have an Excel File that has many columns see below for layout. I want to create an excel files for each of the companies. For Example Hilton HOtels may have 10 lines and I want to create an Excel file containing all the fields from he master file.
Hotel Name Code Address...
I have a report in Excel I need to sort by Company Name each of the components is 5 lines. Is there an easy way to sort them. Thanks,
Column A Column B Column C
1 Company Name
2 blank line
3 total orders 34 1
4 Total rev $500.00 2
5...
i am new to reports...
I have a database report that I will like to show the following:
1 - 14 A RECORDS
15 - 27 B RECORDS
28 - 40 C RECORDS
41 - 50 D RECORDS
Thanks,
SM
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.