Question about Microsoft Office Standard for PC

1 Answer

Search code in visual basic

I am making a project in visual basic about computer lab manegment.I also maked data base in ms access.i also connect it with forms.now, I want if i press 1 in form at run time,only the content of 1st row is show and other is hide.after it if I press 2 than the content of 2nd row in the data base is show and other is hide.how i can do this?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 4 Answers

If your rows are being displayed or hidden on the form, the easiest way would be to use a filter on that part of the form. The filter would be based on the button being pushed; each button would invoke a different filter.

Make sure that the filter property of the form is ON.

Posted on Dec 01, 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

How can i save the data inputted from a textbox to the recordset or to its table in MS Access?


If you want to save it in MS Access, you need an OLEDB Connection.

You need to declare few arguments first to accomplish your tast like, OLEDB Connection String, Connection, Data Adapter....

I'll write a simple program to show you.
---------------------------------------------------------------------------
Const cn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "data source=path of Access file(2003) where you want to save input data.mdb;"

Dim conn As New oledb.OleDbConnection(cn)

Dim objda As New oledb.OleDbDataAdapter

Dim cmd as string = "insert into login (loginid,pass) values('" & TextBox1.Text & "')"

conn.Open()

objda.InsertCommand = New OleDbCommand(sql, conn)

objda.SelectCommand.ExecuteNonQuery()

conn.Close()
----------------------------------------------------------------------

Copy and paste the above source code, and then tell me what happens.
If you got any more quries, don't hesitate to ask.

And If I was helpful, Kindly do Rate!
Regards,
Waqar.


Sep 03, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

I want to programaticaly modify an SQL statement in VB6


If I remember correctly you need to call ExecuteQuery or something similar otherwise it does not update the database.


Regards
GeWiz.

Jun 16, 2009 | Microsoft Visual Basic Enterprise Edition...

1 Answer

Retrieving acess data which is password protected thru VB


You will need to use a connection string. But - before you can configure the string correctly, I'd need to know how the data is stored (Access, SQL, ODBC, etc). You can find examples online. Just know that you are looking for "Connection String." Here's two examples:
1. For MS Access (Jet files):
' Set up the connection string.
m_strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strDestDBPath & ";" & _
"Jet OLEDB:Engine Type=5" ' NOTE: Use Type=5 for Jet 4.x.

2. For SQL database:
g_strADOConn = "Provider=SQLOLEDB;" & _
"Data Source=SERVER_NAME;" & _
"Initial Catalog=DATABASE_NAME;" & _
"User ID=mssql_userid;" & _
"Password=mssql_password;"

Apr 22, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

How to access data from ms access with buffer in class code with vb application


Use ADO and create a connection string for a Jet file (version matters here when creating the string). Then use ADO commands and return recordsets to buffer your data.

Mar 26, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

What is the compatible database for visual basic 6.0?


Microsoft Access uses the Jet Engine. In VB 6, you can create a data connection using ODBC or OLE DB. Here is an example of OLE DB:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YourAccessDB.mdb;User Id=;Password=;" Good luck

Mar 09, 2009 | Microsoft Press MS Access 2000 and Visual...

1 Answer

Write into excel format


Your code does not save in access format it just makes a copy of existing file. You need to open table by table and export data using csv format.
It can be done using access OLE to export, or
write some VB code to access the database tables via ODBC and save row data to csv file

Feb 17, 2009 | Microsoft Visual Basic Professional...

1 Answer

Visual basic


Read the MSDN articles on the MS Access in question, paying attention to the version of Visual Basic recommended also.  Not a lot to do with Yahoo! 4D Soft Scroll Mice, is it!?

Aug 12, 2008 | Sakar Yahoo 4D Internet Soft Scroll Mouse

1 Answer

Coding in ms word by using visual basic editor


Hello Kavita! If you want to get the most of VB then i advice that you install Microsoft visual studio...But just in case you want it for free you can find it here..
http://www.brothersoft.com/downloads/vb6.html

Nov 10, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

90 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18346 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...