Search results

Hi Holger, I want the picture to be right justified within a cell, like u mentioned, pass the position? but how do i really pass the position? can u kindly elaborate? thks.. FT :)

Hi all, I want to insert a picutre into my MS excel spreadsheet. However, I want to dictate the position within a cell that the picture shld appear in.. For example, i wan it to be right justified when it is inserted..Is it possible to be done? Thks FT :)

Rod D, A space indeed causes my words in cell A to be hidden behind a seemingly empty cell B.. Thank u for enlightening me.. i managed to solve my prob

Thks rod D, it seems like u r absolutely correct.. u been of great help... To others who have assisted me with your suggestion, thks as well.. :)

wow, tats a very detailed solution, john.. thks alot.. i will go give it a try.. thks agn FT:)

Hi all, i have got 2 questions here : 1. When i click on the dropdown list, i am able to select the listed options, but how do i DISallow the user from entering text into the combo box? I do not wan the user to edit the text in the combo box. thks.. 2. After selecting an option in the combo...

thanks Holger, I think you mis-interpreted my qn. What i meant was, i wanted the string to span beyond the 1st column without having to adjust the width of the 1st column. At times, i seen tat on my spreadsheet, but at times, the string is hidden mehind the 2nd cell.

Hi all, For example u have a string tat spans the width of 1.5 Cell, (e.g. cell A & B). In some circumstances, the string will be chopped off at the length of cell A, tat means, certain words are hidden behind cell B. However, at other instances, the entire 1.5 length of the string can be seen...

thks Mstef and Rod D for ur replies.. it works fine

Hi all, I am using a combo box in my form and its row source is set to Table A, however, the data in the combo box arent displayed in alphabetical order even though the data from Table A is sorted in ascending order. can pls help me by teaching me How to display "row source" in combo box in...

Hi Rod D, u r rite, i am trying to loop through a range of cells, tats y i am using the while loop.. i will go try n see if by adding in the onErrorGoto wil work, i think it will.. thks for ur suggestion.. u been of great help:p

I am using find method to look for a certain string within a cell. However, if that certain string does not exist, it will generate an error. I understand tat if the string is not found, excel will return a #VALUE, my qn is how can i turn off this error msg? FYI, this is how i called the find...

okies, thks alot...

Hi all, How can i ensure tat a particular form will always open upon MS Access is launched? thks FT:)

anbody knows?

Hi all, To export a file to MS excel from my form, i used the command DoCmd.OutputTo acOutputQuery, langName & partName, acFormatXLS, exportPath, False however, i realised that the format of the excel spreadsheet (excel version 5.0/95) that i have exported is slightly different from the...