Question about FarPoint Spread For Windows Forms (F02 013F) for PC

Open Question

Seltext Hi I am usin farpoint spreed sheet in my appliccation . i want to select a text in a cell using selstart and sellength property . i could not set these properties . why and how to achive this ?

Posted by on

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

My microsoft acess is read only, how do i change it?


Setting the Allow Edits property is a fine way to lock the record. Note that "Changing a field value programmatically causes the current record to be editable, regardless of the AllowEdits property setting." from this reference. I would suggest reading all of that page anyway.

To find this property:

  • Open the form in design view
  • Open the Property Sheet
  • Make sure that "Form" is selected in the drop-down at the top of the Property Sheet
  • Select the Data tab
  • You will see Allow Edits toward the bottom of the list
If you don't have too many controls to worry about, or you only want to lock individual controls, you can set their Locked and/or Enabled properties for the same effect.

Apr 25, 2011 | Microsoft Office Professional 2007 Full...

2 Answers

In one cell I am trying to add the text .jpg to the data from another cell but I keep getting error when entering for example =J259&".jpg" , also the content of cell J259 is a formula which is...


This is a long shot ... I dont know what spread sheet you are having trouble with. It might be that your sheet thinks you are entering text when you put in the reference "J~" Be dure you are entering a formuila and not test that looks like a formula (to you)

Sep 14, 2009 | Business & Productivity Software

1 Answer

I had data on sheet one and for same the text format on another i want to copy data in the sheet having text format for particular cell reference which is there on first sheet


Try using "Paste Special". Select the data you want to copy. Position your cursor on the new sheet. Select Edit / Paste Special. Try the "Values and number formats". If that doesn't copy all the formatting you want, on the second time select "Formats". I often do this as a two step process: do a normal cut and paste, then go back and do a "Paste special" selecting "Formats" to get the formatting correct.

Jun 26, 2009 | Microsoft Excel for PC

1 Answer

I downloaded updates and now I'm getting "runtime error" messages


Turn off the Machine Debug Manager Service. It is only needed if you are debugging Visual Basic software.
To do so:
  1. Click START, select RUN
  2. Type "Services.msc"
  3. When the Management Console opens, search for "Machine Debug Manager" on the right hand panel and doubleclick on it to open it's property sheet
  4. On the property sheet, on the "Service Status",click "STOP". On the "Startup type:" select Disable (or Manual)
  5. Close the Property sheet; Exit the Management Console
You may need to reboot the pc.
I recommend a program named Autorun from SYSTERNAL to control what runs on a PC.


Dec 12, 2008 | Microsoft Office 2003 Basic Edition...

2 Answers

What function can make a text/string BOLD?


Hi,
Try selecting a cell and right click, Format cells, Font - Bold the text the way you want it to appear in that cell and then let it be the value you want to appear when you select that cell as a solution to a "What If" statement.
I build training spread sheets that let people generate pre-programmed answers to various data entries. Answers appear like magic.
Glad to be of assistance - please rate the posting - I can learn from you.

Oct 26, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer

Macro


Hi alwinkumar

You can set a default value in most form items under the properties of that item. Look for "value". You can also do this in code, by setting up a sub routine to set/reset the values on your form. Then just run the sub routine before you open or enter the form.

Private Sub resetForm()

'formname.itemname = value
UserForm1.Label1 = "Hello World"

End Sub

For the second one you have a couple of options, you can find the bottom on the data and store the row index in a variable, use a loop to find the next empty cell in a row, and store the value or you can use the current region method to select all the cells with data continously touching the selected range. Example below

numberOfRows = Sheet1.Range("A1").CurrentRegion.Rows.Count

Jul 16, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Excel text boxes


If you are talking about deleting the text boxes at a time that have been inserted to your cell of excel worksheet, plz follow the steps.
STEP-1
1. Open your excel sheet where the textboxes are inserted.
2. You can click one of the text box (do not click in the cell).Now press control and select the other ones with the mouse.
3. Now press the delete key and your box will be deleted.
else if you want to delete all at a time follow this.
STEP-2
1. Open your excel worksheet that contain text boxes. Now right click on the blank area of Menu bar (At top right corner area). 5e70363.jpgChoose Drawing tool bar if not selected. Now from the drawing toolbar (above the TASK BAR) choose the --> (arrow mark) at bottom left corner of the drawing bar.
c72d4bc.jpg 2. Now your mouse pointer will be changed to arrow shape. Now click on the bigining of the excel sheet and drag till the page end without releasing your mouse button. Now you will see all the text boxes will be selected.(No text will be selected, Only objects will).
466bdaf.jpg dcf40c0.jpg 3. Now press delete key and all your text boxes will be deleted at a time.

Hope it works, otherwise mail mei will give you the screen shots.

Feb 16, 2008 | Business & Productivity Software

1 Answer

VISUAL BASIC TOOL LIKE SCROLL BAR, COMBO BOX US IN EXCEL


hello

You can make a link into cell that you want by right mouse click
Heperlink, link to , place in thins document , on the feild type the cell reference (A22 ,E56) ...etc , & link where is the cell that you want link to . & in which sheet it is .


i hope good luck

Jan 10, 2008 | Business & Productivity Software

5 Answers

Formula required


at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

2 Answers

Conversion from date to text formet


Block off the cells (or row or column) in question, right-click and choose FORMAT CELLS. In the NUMBER tab, choose TEXT. This will make your dates appear exactly as they are typed, and not allow Excel to reformat them.

Nov 18, 2007 | Business & Productivity Software

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

71 people viewed this question

Ask a Question

Usually answered in minutes!

Top FarPoint Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a FarPoint Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...