Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




How To Clear The Textbox?


Without addnew when I enter the text in the textbox it is updated and listed in the listbox.
My problem here is to enter the next name I want to clear the textbox by using command button.if I use addnew or simply text1.text=" " it is updating but it is not listed in the listbox. what mistake I did here.

I tried like this.
Private Sub cmdaddnew_Click()
Set WS = DBEngine.Workspaces(0)
Set DB = WS.OpenDatabase("C:WINDOWSPATS.MDB")
Set RS = DB.OpenRecordset("EMP", dbOpenDynaset)
RS.AddNew
Text1.text=" "
Text2.text=" '

Private Sub cmd_update_Click()
Set WS = DBEngine.Workspaces(0)
Set DB = WS.OpenDatabase("C:WINDOWSPATS.MDB")
Set RS = DB.OpenRecordset("EMP", dbOpenDynaset)
RS.AddNew
RS.Fields("ENAME").Value = Trim(Text1.Text)
RS.Fields("EMPID").Value = Val(Text2.Text)
RS.Update
MsgBox ("UPDATED")
End Sub

Private Sub cmd_view_Click()
Dim E As String
Dim I As Integer
Set WS = DBEngine.Workspaces(0)
Set DB = WS.OpenDatabase("C:WINDOWSPATS.MDB")
Set RS = DB.OpenRecordset("EMP", dbOpenDynaset)
E = "select empid FROM EMP WHERE ENAME='" & Text1.Text & "'"
Set rsl = DB.OpenRecordset(E, dbOpenDynaset)
I = rsl.RecordCount
If I > 0 Then
rsl.MoveFirst
Do While Not rsl.EOF
List1.AddItem rsl.Fields("EMPID").Value
rsl.MoveNext
Loop
End If
End Sub




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Clear TextBox (several Of Them)
Hello,

Lets get right to it.. Ok,

I just wrote an Interest Calculator (an assignment) I am wanting to clear all the textbox's on the form.

There are 4 TextBox on the form... Can I clear with something different than
Code:
text1.text = ""
text2.text = ""
text3.text = ""
Text4.Text = ""

Clear A Textbox
I have some question regarding my textbox

How i want to clear a textbox in a milisecond when the textbox got focus..
means when some event have send setfocus to this textbox..it will took a milisecond to clear the textbox before accept another string..because my project is using a barcode scanner to read the string..i want to make sure there are no text was send to the text box before accept another string..

Thank you..

I Want To Clear More Than One Textbox ???
peace be with you

i am using this code to clear about 13 textbox :

VB Code:
Dim tc As IntegerFor tc = 1 To 13Text(tc).Text = ""Next tc


but there is an error " sub ot function not define "

what the problem ??

thanks

Clear Textbox
On my interface I have a textbox txtStreet1, txtStreet2, command button cmdSubmit, and a comboBox cboCandidates. I doing a simple search by typing some stuff in the textbox, press the command key and I get a list to choose from. When I select from that list I get a certain map.
My problem is I want the text I enter in the text box to clear after the I press cmdSubmit.

I used txtName.Text = " ", the problem I'm stuck with only one option on my comboBox. Here is part of the code

Private Sub cmdSubmit_Click()
If Geo.CandidateCount > 0 Then
Set foundMatch = Geo.LocateCandidate(0)
Map1.CenterAt Geo.LocateCandidate(cboCandidate.ListIndex).location.X, Geo.LocateCandidate(cboCandidate.ListIndex).location.Y
txtStreet1.Text = "" 'is causing problems with selecting from
txtStreet2.Text = "" 'the drop down list in the candidate list
Map1.FlashShape foundMatch.location, 5
End If
End Sub


Private Sub cboCandidate_Click()
If txtStreet1.DataChanged Or txtStreet2.DataChanged Then
cmdSubmit_Click
choice = -1
End If
End Sub

Any help is greatly appreciated

How Do You Clear A Textbox
Is there a way to clear contents of textbox in VB6 after entering a text value? You may also email me at sheep672001@yahoo.com

Thanks.

How To Clear All The Textbox But Two
Hi!

I want to clear all the txtBox but two.

Here what i'm doing :


for Each ctl In me.Controls
If TypeOf ctl is TextBox And ctl.Name <> txtNumemp And ctl.Name <> txtNom then ctl.Text = ""
If TypeOf ctl is ComboBox then ctl.Text = ""
next




but it still clear all the txtBox. What i am doing wrong?

Thanks a lot

How To Clear All The TextBox But Tow
Hi!

I use that kind of loop to clear all my texbox when a press a new button



for Each ctl In me.Controls
If TypeOf ctl is TextBox then ctl.Text = ""
next




The problem is that i have to textBox that i want to keep the data in it. Is there a possibility to do that. I don't want to clear all the textBox one by one.

thanks a lot

Clear Textbox And List Box.
I'm doing a project on sms. can i know how to clear textbox and listbox automatically?

Clear Text In Textbox....
My VB6 has a Form with a Textbox.
Actually my work behind reading Barcode thru Barcode Reader into the
TextBox, The Maxlength of the TextBox is 12.
If I Input some characters manually into the TextBox Say "abc" (without quotes)
now the cursor is in 4th place from there it won't allow Barcode Reader to read.
It should start from 1st place only by erasing already existing 3 characters.
This is my situation.

if the above question is not clear

don't use
Text1.SelStart =0
Text1.SelLength = Len(Text1.Text)
in Got_Focus Event.

After typing "ABC" (without quotes) the cursor is in 4th place ok. My barcode length is 12 characters.
When I read barcode thru reader it starts from 4th place
& the last three characters of barcode cut off due to max.
length of the Textbox is 12.
What i want is before reading barcode the already existing
Characters "ABC" (without quotes) in the Textbox should be cleared.

Clear The Values Of A Textbox
Hello all,
can someone tell me how to clear the values of textboxes in a form.

thanks
anonymous

Clear Cursor From TextBox
Sorry, this is newbie here again (so I may need a little more explanation).

I have a small popup window program where you enter information into text boxes and these get transferred to the file properties. Three boxes are for dates (ex: when a part is designed). First, you place a cursor into one of these boxes and click a CommandButton and the current date goes into that box.

The problem is that if you are typing in the Part # box, for example, and click the CommandButton, the current date will override the last used date TextBox. Is there a way to 'clear' the cursor?

Otherwise, how can I adjust the code so the current date doesn't override whatever is in the box? (It needs blank space.)

Thanks!

Clear Rich Textbox??
I thought there would be an easy way to do this like richtextbox1.clear but things aren't that easy. Does anyone know how to clear the Rich Textbox

TextBox Clear And Repopulate Help
Hi all

whan i need
A textbox that when you click on it the content is cleard
When you click of (click on something else or use Tab) and the textbox is still clear (you have not wrote anthink in it) the text fiels of the textbox is populated with a mesage (curelenty "Provide Address")

the first part i can do (Clear the textbox when clicked on)
it is the second part i am having torble with

Function: Clear TextBox
Hi.

Can someone write a code, that clears a TextBox ( Name of TB: tbURL ) ?

Don't Clear Data In A Textbox
Hi everyone there, i have a question here. I have a sub below and the output of the data in the txtStatus will be refreshed whenever the command button was pressed. How do i keep the previous generated data in the textbox?
I'm not sure if the data were automatically cleared when the cmd btn was clicked were due to the codings below.
Anyone knows how do i solve this?



VB Code:
Private Sub MAP_DRIVE(Driveletter As String, servername As String, customer As String, validtest As String, program1 As String)    'Function to map the server connetions    Dim fso As New FileSystemObject    Dim strPassword As String    Dim strLocalDriveLetter As String 'New    Dim strNetworkPathName As String 'New        txtStatus = "Mapping in Process..."    Screen.MousePointer = vbHourglass    'strPassword = "flex123"    strLocalDriveLetter = Driveletter 'assing the drive letter    strNetworkPathName = "\" & servername & "" & customer & program1 & "UFLEX"  '& validtest    'MsgBox strNetworkPathName 'show server path    'MsgBox strLocalDriveLetter        If WNetAddConnection(strNetworkPathName, strPassword, strLocalDriveLetter) > 0 Then        'MsgBox "An Error occurred mapping the drive", 16, "Error Message"        'End        txtStatus = "An Error occurred mapping the drive." & vbCrLf & "Mapping Failed."        Screen.MousePointer = vbDefault    Else        'MsgBox txtStatus.Text & ": Drive successfully mapped!", 64, "Information"        txtStatus = "Drive successfully mapped!"        Call unmap_drives(False) 'do display all the mapped servers        Screen.MousePointer = vbDefault    End IfEnd Sub


Thanks alot.

Clear Text In The Textbox.....
My VB6 has a Form with a Textbox.
Actually my work behind reading Barcode thru Barcode Reader into the
TextBox, The Maxlength of the TextBox is 12.
If I Input some characters manually into the TextBox Say "abc" (without quotes)
now the cursor is in 4th place from there it won't allow Barcode Reader to read.
It should start from 1st place only by erasing already existing 3 characters.
This is my situation.

if the above question is not clear

don't use
Text1.SelStart =0
Text1.SelLength = Len(Text1.Text)
in Got_Focus Event.

After typing "ABC" (without quotes) the cursor is in 4th place ok. My barcode length is 12 characters.
When I read barcode thru reader it starts from 4th place
& the last three characters of barcode cut off due to max.
length of the Textbox is 12.
What i want is before reading barcode the already existing
Characters "ABC" (without quotes) in the Textbox should be cleared.

Clear A Textbox That Is Used For Passwords?
Quick question...VBA
I am using a textbox as a password entry box so that I can hide the password(*). It is holding the last typed password. Is there a way to set the password to blank so that the user is forced to enter the correct password?

Hidden button to show the password box:

Code:Private Sub LastPerson_Click()
txtpass.Visible = True
PassOK.Visible = True
txtpass.Activate

Verify password:

Code:Private Sub PassOK_Click()
password = txtpass
If password = "" Then
txtpass.Visible = False
PassOK.Visible = False
Exit Sub

ElseIf password = "last" Then
txtpass.Visible = False
PassOK.Visible = False
MsgBox Range("a1000")
Else
txtpass.Visible = False
PassOK.Visible = False
Exit Sub
End If
End Sub

Clear TextBox, On MSComm Receive
Hi

Im using the VB MSComm function to display incoming data strings to a TextBox. I have successfully set it up and it is working perfectly, but what i want to do is everytime a new string of data arrives i only want to display that, so i need to somehow clear the history of the textbox, for each Comm Receive.

This is the method i tried to use, but unfortunately it only displays the new incoming data for a brief sec.

Code:
Private Sub MSComm1_OnComm()
Dim InBuff As String

Select Case MSComm1.CommEvent

'When data is recieved do this
Case comEvReceive
Text1.Text = ""
InBuff = MSComm1.Input
Call HandleInput(InBuff)
I know this is simple, sorry but does anyone have any other ideas how to clear textboxes, when a new string of data arrives.

Clear All Fields In A TextBox Array
7 textBoxes many more coming but use the 7 for now..

Want to


Code:
Private Sub cmdClear_Click()
' Clear all textBox fields txtBox array is called txtStats

End Sub

vbMarkO

Clear Textbox On Only One SSTab *Resolved*
I would like to clear the textboxes on ONE SSTab,

However when I use a For Each control, it clears all of the textboxes on all of the tabs.

I have the textboxes within a frame, BUT I would rather not make them into an array.

Anyone have any ideas?

How Do I Clear The Contents Of A Textbox And Update It ?
Hello again all,

Every aspect of my program works great except one thing.

I call a form (rbt_ack_frm) with two textboxes on it, these boxes
are populated based on reading from two files (they are
essentially verification boxes).

The first time you go through the data is perfect but, if
you "cancel" the operation and go back to form1 and choose
additional options and then go back to this form the old values
are still in the box. The files that these boxes get their data from
are correct but these two textboxes never update.

Here's the code for the entire form


VB Code:
Private Sub cxl_rbt_combtn_Click()    rbt_ack_frm.Hide        Open "C:
bt_imd.txt" For Input As 1    'clear file if "cancel"    Print 1, ""        Close 1        Open "c:
bt_wat.txt" For Input As 2    'clear file if "cancel"    Print 2, ""    Close 2        Form1.Show    End Sub Private Sub Form_Load() 'Heres my problem, I need this to clear before going onto the'next sub, or at a minimum when going to "popsrvlst" it should'write the new values      Call popsrvlst    End SubSub popsrvlst()    Open "c:
bt_imd.txt" For Input As 1    'open rebt_imd file and'populate srvlist1_txt with contentssrvlst1_txt = Input(LOF(1), 1)Close 1     Open "c:
bt_wat.txt" For Input As 2    'open rebt_wat file and'populate srvlist2_txt with contentssrvlst2_txt = Input(LOF(2), 2)Close 2End SubPrivate Sub rbt_ack_combtn_Click()    Open "c:Rebootmgr.log" For Append As 3 'Append to log file'with time of reboot and servers rebooted    Print #3, Now    Print #3, srvlst1_txt    Print #3, srvlst2_txt    Close 3                Shell "C:dly_rbt.bat"                  'Call reboot script and hide 'acknowledge form    rbt_ack_frm.Hide    Form1.ShowEnd Sub  Private Sub Text1_Change() End Sub


Any idea's ? I'd prefer not to create a control array with these
two boxes but if neccesary I will.

Thanks,

Darrin

Clear TextBox, On MSComm Receive
Hi

Im using the VB MSComm function to display incoming data strings to a TextBox. I have successfully set it up and it is working perfectly, but what i want to do is everytime a new string of data arrives i only want to display that, so i need to somehow clear the history of the textbox, for each Comm Receive.

This is the method i tried to use, but unfortunately it only displays the new incoming data for a brief sec.

Code:

Private Sub MSComm1_OnComm()
Dim InBuff As String

Select Case MSComm1.CommEvent

'When data is recieved do this
Case comEvReceive
Text1.Text = ""
InBuff = MSComm1.Input
Call HandleInput(InBuff)

I know this is simple, sorry but does anyone have any other ideas how to clear textboxes, when a new string of data arrives.

How To Completely Clear The Text From A Textbox In Excel?
Hello, I have an excel worksheet that contains many textboxes (e.g. "textbox 7", "textbox 8", etc).

The various textboxes are always fixed in terms of position and size but the text content varies in length.

I want to create a macro that will automatically clear out all the text from all the textboxes at once.

When I use the macro recorder (excel97) to mimic my keyboard/mouse movements where I do this manually, it never works properly.

Can someone kindly give me some proper code to achieve this?

Clear Single Line From Multiline Textbox
I have a Multiline textbox in which I input data from listboxes. I want to know how to remove a single line of the textbox via a clear item button.

Any help would be wonderful.
Q

I'm A New At VB Need Help How To Assign A Button To Clear Textbox Contents?
Hello,

I need help with VB6 on how to assign code to a button (Clear Button) to clear out any numbers that are in my textboxes to allow the user to hit the button and clear out any information within the textboxes. This is a calculator program to convert liters into gallon and pints conversion. I have 3 textboxes (one textbox to allow user to enter the number of liters, the next 2 textboxes the user will not enter anything because these textboxes with display the results of the conversion user will not be able to enter anything within these textboxes), then 3 buttons(the first button allows the users to hit the button to calculate or process the entry, the other is to quit the program and the one I need help with it the button to clear all three textboxes I call it the reset button)

Dim FirstNum, SecondNum, ThirdNum, Button3Compute_Click(), Button3Reset_Click(), ready, display

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        End
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        'Assign text box values to variables
        FirstNum = TextBox1.Text
        SecondNum = TextBox2.Text
        ThirdNum = TextBox3.Text

        'Determine checked button and calculate
        TextBox2.Text = FirstNum * (0.2642)
        TextBox3.Text = FirstNum * (2.1134)
    End Sub

    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        If ready > 0 Then
            display.Caption = display.Caption + "0"
        Else
            display.Caption = "0"
            ready = ready + 1
        End If
    End Sub
End Class



Please let me know ASAP.
thanks,

Johndel

 

How To Delete Or Clear Textbox Last Character When User Enter The Wrong Format..??
How to Delete or Clear Textbox last character when user enter the wrong format..??

I have try a code the function is when detect there is wrong format it will count the textbox length and set the length minus 1... but the setfocus run to the first character place... any idea if this to avoid the setfocus run to infront and remain at the last character?

Script That Will Clear Cookies/click A Button/clear Cookies...
Hi everyone, my Visual Basic knowledge is minimal. I used VB when its latest version was v6 long long ago... (2002-2003) And I was only able to create basic applications.

Now I need a script (or whatever that will do the job) to do this:

- Clear cookies in my browser
- Click a checkbox
- Click a button

I want something that can do this over and over again. I'd be really really glad if you could explain it in detail or give me some document links about it. Thanks in advance.

Clear All
I'm trying to Clear everything from my labels and ComboBoxes at the press of a button.

I'm fairly new to VB so have just been plodding along using 'Trial and Error'

This is the ciode that i have 'developed'

Private Sub cmdClear_Click()
lblOhms.Caption = ""
Combo1.ListIndex = ""
Combo2.ListIndex = ""
Combo3.ItemData(Combo3.ListIndex) = ""
lblFirst.BackColor = ""
lblSecond.BackColor = ""
lblMultiplier.BackColor = ""


End Sub
but i doesn't seem to work. Could someone please point me in the right direction

Many Thanks

Help Me Clear This Row Up. What Is Better VB Or C++
Hi i am having a row with this programmer who thinks C++ is the best language around. An VB is a pile of rubbish made out of C++

From what I know and have read alot of experts slate C++ as prehistoric and long winded.

Can someone give me their opinion please./

Thanks

Still Not Quite Clear
What is the difference between Private Sub, and Private Function, also what is the difference between form module and code module. Regarding VB 6.0, and the concept of Recursion.

Clear
Is there anyway to clear all textboxes from user inputed text on a form without writing code for every textbox?

Clear UDT
Is there an easy way to clear a UDT? For example:


Code:
Public Type This
A As String
B As Integer
C() As String
End Type
Public That As This
Public Sub Stuff()
That.A = "Hello"
That.B = 9
ReDim That.C(1)
That.C(1) = "GoodBye"
End Sub

How do you clear "That"? Do you have to manually reset each element? Thanks in advance!!

Clear...help!
Hello, im fairly new at vb and am working on a gameshow format program where if you answer one question correctly it moves to the next. I know how to do the if thens with the option boxes, but i was wondering, how would i clear the screen if they got it right and have it bring up the next question?

thanks!

Clear Db
Which command sould I give to clear all the records from all fields of a given database?

Thks

Clear This To Me ?
I read this on the vbLibrary but i dont get it
please explain this to me more clearly and can you give me an example how to use it

UBound ?
LBound ?
CInt ?
lngResult As Long ?
outstr$ ?
CLng ?
Replace ?
vbNullString ?
tmp ? ? ?
tmpNum ? ? ?
tmpStr ? ? ?
Split ?
difference between Left and Left$ ?
difference between Right and Right$ ?
what is the difference between Mid and Mid$ ?

Please Explain it !

Clear CBO
Hello to all,

I populate a combo box and its style is set to (1 -simple). How can I clear the textbox but still retains the data in the combo box.

I tried combobox1.listindex=-1 but it does not work

thanks

I Am Probably NOT Being Clear!
why is this query not returning me the number of times the SecID is found in the DB? Look at the link below and see the result set. See how if there are 2 or more SecID that the count next to it doesn't actually count it?

http://www.goodnewsfl.org/images/filter2.jpg


Code:
SELECT TOP 100 PERCENT dbo.Response.QuestionID, dbo.Sections.SectionName, dbo.Questions.QuestionText, dbo.Response.ResponseText,
dbo.Questions.Published, dbo.Users.FirstName, dbo.Users.LastName, dbo.OtherResponse.ResponseText AS OtherResponse,
dbo.Questions.SectionID, COUNT(dbo.Questions.SectionID) AS SecIDCount
FROM dbo.CJQDetail INNER JOIN
dbo.Response ON dbo.CJQDetail.ResponseID = dbo.Response.ResponseID AND dbo.CJQDetail.ResponseID = dbo.Response.ResponseID INNER JOIN
dbo.Questions ON dbo.Response.QuestionID = dbo.Questions.QuestionID INNER JOIN
dbo.Sections ON dbo.Questions.SectionID = dbo.Sections.SectionID LEFT OUTER JOIN
dbo.OtherResponse ON dbo.Response.ResponseID = dbo.OtherResponse.ResponseID CROSS JOIN
dbo.Users
GROUP BY dbo.Response.QuestionID, dbo.CJQDetail.CJQID, dbo.Questions.SectionID, dbo.Sections.SectionName, dbo.Questions.MinResponse,
dbo.Sections.FormID, dbo.Sections.AspPageNum, dbo.Questions.QuestionText, dbo.Response.ResponseText, dbo.Users.UserID,
dbo.Questions.Published, dbo.Users.FirstName, dbo.Users.LastName, dbo.OtherResponse.ResponseText, dbo.Sections.SectionID,
dbo.Questions.SectionID
HAVING (dbo.CJQDetail.CJQID = 5) AND (dbo.Sections.FormID = 1) AND (dbo.Users.UserID = 4)
ORDER BY dbo.Sections.SectionID, dbo.Response.QuestionID

Clear
Hello,
I have 5 textbox from text1 to text5 i have a button of
clear wht i want is to clear text box if my foucs is on text3 i
want to clear that text not other is it possiobe to do like

Regards

How Do You Clear A Db?
Every time I need to use my db, new info needs to be written to it. So all the old info has to be erased. How do you erase a whole access db though?

On A Clear Day....
Does anyone know if you can make a form (not a control) transparent so only what is on it (like a picture) shows up over any other forms which may be on the screen?

Clear A From
i have various forms in my database that as I select a project, will fill all the field on the form.

Rather than writing

FieldA= ""
FieldB= ""
FieldC= ""
FieldD= ""

etc etc

everytime I have to clear the form, I thought I would write a function, where I passed in the form name, and then clear the fields, sort of like this

Public Sub ClearForm(strFormName As String)
    Select Case "strFormName"

        Case "frm_Main":
            frm_Main.fieldA= ""
            frm_Main.fieldB= ""
            frm_Main.FfieldC= ""

        Case "AnotherForm":
            AnotherForm.fieldA= ""
            AnotherForm.fieldA= ""
            AnotherForm.fieldA= ""
    End Select

End Sub

and then from the calling form

Call ClearForm(me.name)

for some reason the me.name, although is the name of the form, doesn't pass it to the clearform sub because it doesn't recognise it in the select case statement

can anyone give me a clue as to why it is doing this

Many Thanks


.clear
Hey all,
Im just wondering about a .clear method in VBA.As in Code:fsheet.clear.Does this method exist?From what version of excel on is it in.Is there anything equivalent I can do if my version of Excel doesnt have the method in it.thanks.

Clear A PictureBox
If I load an image (in this case a bitmap) into a PictureBox and then use PictureBoxName.cls the image stays the same and doesn't disappear. Its probably some thing very simple. (Btw 'AutoRedraw' is set to 'True'). Thanks.

Clear Txt File?
Is there a command that deletes all text of Input #1..

all text in the opened txt file.


thx!

Clear Pictures
How can I make certain colors of an image transparent? I already got the form transparent but now I need to get rid of the edges on some pictures i loaded in, Or is there a skin module out there that would make this process smoother.

Clear Button For Tic Tac Toe
I am having a dilemna regarding my coding for my clear button in a tic tac toe game that I have created. I want it to clear the screen so that another game can be played. Unfortunately, the way it is now is when you click the clear button right now you get the message box that we created coming up and saying you win. It clears the screen but only after you click ok for the msgbox 3 times.

Could someone take a look at the .frm and .vbp files I have provided a link to and let me know how to fix this? Thanks

Tic- Tac- Toe Code

Clear Data?
im using winsock and i want to send two SEPARATE blocks of data... this is basically what i have

winsockDialog.SendData "hey"
winsockDialog.SendData "sup"

BUT!!!!! with the Private Sub winsockDialog_DataArrival, it sticks em together! how can i fix this?

thanks,
jared

Clear A Surface
how would i clear a surface? like in a VB form "cls"

How Do You Clear Out An OLE Container?
I have linked a word document to an OLE container to display its contents. I want to be able to clear the control so that it nolonger displays the document. I have tried a few of the usual things (.action = , .close etc..) but nothing seems to work with a linked document.

Andy

Copyright 2005-08 www.BigResource.com, All rights reserved