Question about Computers & Internet

1 Answer

How to add columns(Vertical) only in Msflexgrid from database table using VB.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 100 Answers

You have to open your current project in VB then go to "add references" (its somewhere in the menu bar) then go find microsoft acess and add it as a reference. then go to object browser and you'll find all the functions you need to interface between your project in VB and MS Access.

good luck !!!

Posted on Dec 30, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Merge rows and columns of table in vb


Under edit there should just be a button called merge cells. Columns you want to merge by holding shift and clicking on them. Then click merge cells.

May 03, 2011 | Computers & Internet

1 Answer

I can not draw a table in microsoft word


hi ermelitacapa,

To create a table in Microsoft Word please do the following:

1. Go to the Table menu and select 'Insert Table'. The Insert Table window will open.
2. Select the number of rows and columns you want in your table.
3. Select the column width (up to 22 inches) or choose 'Auto' to have the column with adjust automatically, making the table extend across the width of the page.
4. Select the AutoFormat button to select one of Word's pre-formatted table styles. The Table AutoFormat window opens.
5. Click one of the styles in the Formats box in the upper left side of the window.
6. Preview each format, after selecting it, in the Preview box in the upper right side of window.
7. To customize a pre-selected format, select or de-select the borders, shading, font, color, heading rows, first column, last row and last column boxes.
8. Select AutoFit, and Word will automatically fit the table to your page.
(To manually change the width of a table or column after you have created it, use the mouse to place the pointer over the vertical line you want to move. When the pointer turns into a double-headed arrow, drag the line to the position you want it in the table.)'

I hope this helps!

** If you find this information helpful please leave feedback to help us help others **

Feb 24, 2011 | Microsoft Windows 7 Home Premium 64BIT...

1 Answer

DAO in vb


Nice try. Find an upper-class student to give you one-on-one tutoring with your homework.

Apr 16, 2009 | Computers & Internet

1 Answer

How to connect vb with ms access


se Adodc OR Even better.. ADODB. for this you need to get MDAC fromMicrosoft free download.(check under project_References- Microsoft DataActiveX objects.. the current no is 2.8. if it is not there download invb directory.

next, you can learn about creating a DSN from control panel, ODBC. onceyou learn this, connection becomes a piece of cake. get some free vbtutoriasl from WWW.

then

you need to use DAO or ADO to connect to the database. better study both but since ADO is current, i am showing that code.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string
Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub
and for adding records:
say let us say you have 3 fields. then have 3 textboxes and 1 command button on the form.

private command1_click()
esql1="select * from Yourtablename"
rec.open(esql1),conn,, adOpenDynamic, adLockOptimistic
rec.AddNew
rec.Fields(0) = text1.Text
rec.Fields(1) = Text2.text
rec.Fields(2) = text3.text
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.
rec.update
if not rec.eof then rec.movenext
rec.close
conn.close
set conn to nothing
end sub

this will add new records to access table from VB.
' for picture store the full path of the path and the picture file nameint the text field. and in the picturebox of VB form for viewingrecords again you need ADO or ADODC and here you code:picture1.picture=Loadpicture(rec.fields(3) ' depending on where thepicture field is located. you need to make a few trials.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string

Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub

and for accessing records:

private command1_click()
esql1="select * from Yourtablename where id =" & val(text1) ' for integers

esql1="select * from Yourtablename where name=" & "'" & text1 & "'" ' for string

rec.open(esql1),conn, adOpenstatic, adLockreadonly

label1.caption =rec.Fields(0)
label2.caption= rec.Fields(1)
label3.caption= rec.Fields(2)
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.

rec.close
conn.close
set conn to nothing
end sub


' similarly there are routines to ADD, Delete, Edit, View etc.

Feb 26, 2009 | Computers & Internet

1 Answer

Migration from single machine to multiuser environment


have you made sure that the ADODC path points to the machine that holds the database on a remote path for example (\\ComputerName\c$\Data\) and that it isn't a local path. (C:\Data\)

Dec 15, 2008 | Microsoft Windows Server Standard 2003 for...

1 Answer

Edit unbound msflxgrid rows save changes in database


unbound FlexGrids do not directly accept data entry, but can accept data through the FlexGrid's KeyPress event or via a Textbox

For more detail see

http://www.pbdr.com/vbtips/gen/Article-UsingFlexGrids%282%29.htm

Dec 12, 2008 | Microsoft Windows XP Professional

1 Answer

Flex Grid


The most common multidimensional array, the two dimensional array table, is best presented to your users in row and column format. The grid control offers a convenient way for you to display table data to your users. The users can navigate the table's values using scrollbars. Therefore, the grid control does not have to be as large as the table, because the grid control automatically displays scrollbars.
To add the flex grid control to your toolbox, select project and components. Add the flex grid control:
lesson97-1.jpg Once it is added, you will see the yellow flex grid control in your toolbox:
lesson97-2.jpg When you place the grid control on your form, you will have to resize it before the control takes on a tabular appearance. As you expand the size of the control, it does not look to much like a table. The problem is that the table's default number of rows and columns are two. To fix this problem, you must configure the rows and columns in the properties window:
lesson97-3.jpg lesson97-4.jpg lesson97-5.jpg The grid control supports fixed rows and columns. These refer to rows and columns in a grid control that do not scroll when the user clicks the scrollbars. The fixed rows and columns provides labels that describe the data. The fixed rows and columns are often called row and column headers.
lesson97-6.jpg When working with the grid control, much code is needed to provide the grid with functionality. Call statements are used to break the code required by the grid control into smaller, more manageable procedures. This is referred to as modular programming (which refers to the practice of placing code with a single purpose in a general subroutine procedure and then calling the code from a second procedure.)
Here is the code for the form load procedure (this example is based on the computer disk example used in the last lesson)


Private Sub Form_Load()
Call SizeCells
Call CenterCells



grdGrid.Row = 0
grdGrid.Col = 1
grdGrid.Text = "Single Sided; Low Density "
grdGrid.Col = 2
grdGrid.Text = "Double Sided; Low Density"
grdGrid.Col = 3
grdGrid.Text = "Singled Sided; High Density"
grdGrid.Col = 4
grdGrid.Text = "Double Sided; High Density"

grdGrid.Row = 1
grdGrid.Col = 0
grdGrid.Text = "3 1/2 inch"
grdGrid.Col = 1
grdGrid.Text = "$2.30"
grdGrid.Col = 2
grdGrid.Text = "$2.75"
grdGrid.Col = 3
grdGrid.Text = "$3.20"
grdGrid.Col = 4
grdGrid.Text = "$3.50"



grdGrid.Row = 2
grdGrid.Col = 0
grdGrid.Text = "5 1/4 inch"
grdGrid.Col = 1
grdGrid.Text = "$1.75"
grdGrid.Col = 2
grdGrid.Text = "$2.10"
grdGrid.Col = 3
grdGrid.Text = "$2.60"
grdGrid.Col = 4
grdGrid.Text = "$2.95"

End Sub
Notice how the form load procedure is used to populate the cells in the grid control. To control cell size and cell alignment, two smaller procedures are created and each procedure is called by the form load procedure.


Private Sub SizeCells()
Dim intColumn As Integer

grdGrid.ColWidth(0) = 1100

For intColumn = 1 To 4
grdGrid.ColWidth(intColumn) = 2200
Next intColumn

End Sub

Private Sub CenterCells()
Dim intColumn As Integer

For intColumn = 1 To 4
grdGrid.ColAlignment(intColumn) = flexAlignCenterCenter
Next intColumn

End Sub

Notice that the size and alignment procedures are only applied to columns 1 through 4. Column 0, which is a fixed column reserved for labels, is not formatted using either of the above two procedures.
Here is the final result:
lesson97-7.jpg

Mar 26, 2008 | Computers & Internet

1 Answer

Vb database connectivity


use odbc tool located in controll pannel and make a database file for use from visual basic6.0

Mar 22, 2008 | Computers & Internet

2 Answers

Vb.net2005 flexGrid


http://blogger007007.blogspot.com

Here you can get download links for 18 GB of engineering and programming books. Just do a search of "visual basic" or "2005".

Feb 15, 2008 | Computers & Internet

1 Answer

Executing VB application from shared drive


I donot have much expertise on the subject but I think you can do the same by connecting your Database through ODBC connectivity than direct connection. In that way your database will be only on one Server and all can use the same by just using the program from their own console.

Feb 04, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

162 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98868 Answers

David Payne
David Payne

Level 3 Expert

14086 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...