Posts by aadarsh

Re: Image and Text

As for the text

Do this in your program, have 3 global arrays - count, imagename(1000),imagefile(1000)

Now each time user clicks increment count and store filename into the imagefile array with count as the array number
Next take the textbox.value and store in imagename.
So basically the user can keep selecting a file and filling textboxes and will be stored as successive values in array

Aadarsh

Re: Image and Text

try using the getopenfilename function with a filter for image files

put this in the button_click sub

Filt = "JPG Files(*.jpg),*.jpg," & _
           "BMP Files(*.bmp),*.bmp," & _
           "All Files (*.*),*.*"
    
    FilterIndex = 1
    Title = "Select the Image File"
    
     Filename = Application.GetOpenFilename _
        (Filefilter:=Filt, _
         FilterIndex:=FilterIndex, _
         Title:=Title)

The above code will select your filename and store it in filename

If You need more details just post back

Aadarsh

Re: text in a popup box when going over cell

Ok let me break it down

I have a large text file from which i extract data. The point is data is in form of blocks similar to the one below

value RadioLinkDeletionRequest : 
		    {
		      protocolIEs 
		      {
		        {
		          id 143,
		          criticality reject,
		          value NodeB-CommunicationContextID : 2
		        },
		        {
		          id 44,
		          criticality reject,
		          value CRNC-CommunicationContextID : 24
		        },
		        {
		          id 213,
		          criticality notify,
		          value RL-informationList-RL-DeletionRqst : 
		          {
		            {
		              id 206,
		              criticality notify,
		              value RL-informationItem-RL-DeletionRqst : 
		              {
		                rL-ID 1
		              }
		            }
		          }
		        }
		      }
		    }
		  }

Sometimes ten times the length..
There are about 60000 such in each file
What i do is decode each and put it in a single row, after the decoded version i need one cell to have this entire above text.
Only thing is being so many lined, i dont want it to be seen unless someone really wants to...
There will be one such block on each line..
I need someway of outputting it, so rest of the output remains on a line basis(dont want to increase height of each row), but this to appear in some case. The easiest i thought was go over a cell..There can also say be a button in the cell, but is much topugher to create 60000 buttons, so was thinking of some way to say make it appear like in a link, go over it , a box appears with the above block

Aadarsh

Re: selective protection of data

Hi

to do that you can do the following

First designate the cells you dont want to be unprotected as unlocked(to do this go to format cells)

Then while protecting the sheet, uncheck the box for select locked cells

Aadarsh

Re: text in a popup box when going over cell

And also the text is dynamic, so is the excel file which is created in the program itself

Re: text in a popup box when going over cell

the problem is not so simple,
Basically i need it to be written from a code for about 60000 lines. Each line has one cell in which i need such text

Aadarsh

Hi

This is a wierd question

Is there anyway in which I can make a bunch of text appear in the form of a box, like the ones which come on going over questions say on this forum, or say the detail of a file which come when u go over a file in explorer...
I am tak=lking about the yellow boxes which text which appear when you go over certain links.

Is there any way of replicating this on an excel cell, basically if i go over a particular cell, a box appears with some text, which i designate

Thanx

Aadarsh

Re: Schduling Access Queries

I have no idea how to add code to an access form, could u help me out

Aadarsh

Hi

How can i schedule access queries to run at certain times of the day??

Aadarsh

Re: restricting textbox text entries

Thanx for the help

Re: Clearing selection from a combo box

On the Button_Click function

Write

Userform3.TextBox1.Value=NULL

Aadarsh

Re: restricting textbox text entries

Hi

Yes this is the method...

Aadarsh

Re: restricting textbox text entries

Hi

Thanx for the code...
But is there any way, I can give the kind of selections it takes

The tag 1111 allows only alphabets, but say the text strings i want to allow them are "M1", "Starhub","Singtel"

Is there any way

Aadarsh

Re: restricting textbox text entries

I cant use comboboxes bcos on all other conditions except A, any text can be filled

Aadarsh

Hi

I have a textbox for which i need to restrict the text put in it to say 3 values, without using combo or listboxes.
I need to do this based on someother condition,

ie

If A Then
'The textbox should be allowed to have only B,C or D

Hope i am clear
Aadarsh

Re: Clearing selection from a combo box

Use

Textbox1.value=NULL ...and similar for all ur textboxes
Combobox1.Value=NULL ..for ur comboboxes

aadarsh

Re: Hide/Show sheets

Hi

Try using

Sheets(i).Visible=xlSheetHidden

Aadarsh

Re: saving file over an existing file

In excel, the following command does the job, use it instaed of the docmd command

Application.DisplayAlerts = False

Re: Protecting the workbooks

Hi

1. For protecting the worksheets, first in the properties of the command button, change it to unlocked.
Then go to tools>protection>protect sheet
Then clear the checkbox against select locked cells
This will protect the sheet

2. Fr VBA, in VBA go to tools>VBA Project Properties>Protection and u can lock the code for viewing

Aadarsh

Re: Automatic Break when executing code

why do u keep going to the reference :Gen_Patterns"??

Aadarsh