Hi,

I would like to query from you people if its possible to
change back color either row wise or CELL wise in List box.

Also I would like to know any other ways of listing record in forms...

Hi,

I would like to insert a background image in an excel sheet which is generated through VB code. The image should be inserted in such a manner so that any data in the same cells can be seen...

I want to do the following in excel sheet fully using VB code.

1. Placin 1 single bitmap from (1,1) to (1,8) cell
2. Placing a text box over it.
3.filling the textbox with text.

THe above...

hi,

I want to put a textbox over a bitmap in MS Excel sheet and populate the textbox with a value from VB code. Please guide me in acheiving the same.


Regards,
Dinil

hey all,

I am developing application which has a huge data base.
From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself...

My application is developed in MS Access using VB. I have a form having multiple textboxes and other controls. Running the code for setting the scrollbar to the end is not working here and throws up...

the code is giving error!!!1

Please help any other alternative.

ExcelSheet.PageSetup.PrintTitleRows = "Sheet1!$1:$3"

Please help me in automatinng the following in my EXCEL sheet using VB.
I want to make my first two rows as Repetitve in every page of print.In excel it can be done as

PAGE SET UP->SHEET -> Print...

no

Please help me in positioning the scroll bar at the bottom of text.
Please help me by providing the code snippet.

its the name of field of NUMBER type in MS ACESS back end.

The back end value is being passed as as Integer parameter to a function.Inside the function i need to add De_hours value into a Sum...

It is not working.
Please Help

I am coding in VB to add 3 fields of MS Access back end.
If there is no value (or blank) in a particular field, I want 0 to be considered in addition.

Following code is not working for checking...

I want to populata records into a list where i can have the following functionalities.

1) Multiple selection of records

2) Back colouring of individual reords.

Among Flexgrid and Datagrid...

My requirement from list is

1) Multiple selection of records.

2)Back colouring of record.

Please suggest which Grid should i go with.?FLEXGRID or DATAGRID

I want to choose a grid which...

I want to colour the 8 the column in evry row and movement row is done by "I".

For I = 0 To lstProject_report.ListCount
lstProject_report.Column(8, 1) = QBColor(I)
Next

I am getting...

I am gettin error message
"The RowSourceType" Property must be set to "Value List" to use this method.
The code is stoping at
lstProject_report.AddItem "Color " & I
in Form_load()...

IN MS access FORM i have a list box column which is filled with colour names.

Once the form is loaded i want to make backcolour of that record same as the one mentioned in that column.
...

PLESE help me with the above post

HI,

Please help me in colourin the text frame with 2 different colours.

With ppSlide1.Shapes(3)
.TextFrame.TextRange.Text = "Wing PRR :Total Weight: "
...

hi,
I want help in developing the following code.

step1 : match Todays date with string in Paragraph.
Step 2: if Date matches, extract from Date to EndOfLine.

Step 1 code

If...

Thank you....very much

I am refering to same cell.

Title :

Ball
Cat
Dog

Title : in BOLD and Underline
Rest of the data in BULLETS

I am refering to Power point Table cell.

please tell me how to format text in a SINGLE cell of a table.
Once the following text is added. i want to format it in followinfg way.

---------------X_------------------------
Title :

...

hi,

I would like to generate ppt where data from my back end MS ACCESS dynamicall changes with record.I coded for connectin to back end.

I want the code to generate Power point using VB 6.0...

hi,

Through VB i want to set the first 3 rows of my excel sheet as HEADER so that those 3 rows will be common header for all the pages when i print them.

Regards,
Dinil

I have given below a code snippet where i am able to generate a ppt with one slide. In a loop the followig code snippet will be passed with new "dbId" and for each "dbId" new slide has to be added in...

Thanks a lot.....
Its working perfectly....
Thanks once again

Cheers,
Dinil

Hi...
In which event do I put the above piece of code??....
I tried with this:
Private Sub SSTab1_DblClick()
If Text1.Text = "" Then

If MsgBox("You should Enter Required Data", vbOKOnly,...

Hi....
I am not able to find the click event of tab2.

Hi friends....

I am using SS Tab in my form. There are 4 tabs in total. The user needs to enter a text provided on tab1 and then go to tab2. If the user clicks on tab2 without entering...

Thanks a lot.....
Its done...

Regards,
Dinil

I want to write this code from VISUAL BASIC IDE.

Regards,
Dinil

Hi friends,

I want to copy few cells of an excel sheet and paste special(picture) in ms-word. I want to develop a vb code code for this.

Please help!...

Regards,
Dinil

Thanks for your suggestions.
I used the 'update table' statement instead of 'insert into' statement.
Its working now....

Cheers,
Dinil

Thanks for your suggestions. I tried the above given solutions but still I am unable to rectify the problem.
Please find attached the snap shot of the database. The first three fields in the first...

Hi,

I have two functions. The first function fills the first three fields of the first row of an MS_Access table. I want to fill the remaining fields of the same(1st) row in the second...

Dim fso As New FileSystemObject
dim Exists as boolean
Exists = fso.FolderExists(strFolderName)

if exists=True then
'the folder path exists
else
'does not exists
endif