Replying to VB6-MS Access Question

code for search button with back end was ms- access,with adodcVB6-MS Access Question

I develop a product it was belong to employee details using adodc connector with access as a backend.Now I want a code such as if we enter the employee id we got the total information about him using search button. So please tell me the code.

-reply by rammohan

 

I am developing an application in Visual Basic 6.0 and using MS AccessAs my backend.

but project code is error,,how can I solve this problem,,,,problem have error occured,,

please help,,,

-reply by jashi

Retrieve tree View database structure from MS-Access using VB6VB6-MS Access Question

Hi,

I am facing problem in Vb6 that how can I retrieve a tree structure data from MS Access.

My table def. Is as follow:

    CurrentID         Description       PrvID

  1                         Node1 0

      2                       Node2 1

      3                         Node3               2

      4                       Node4               2

      5                   Node5   2

      6                         Node6             3

    7                       Node7           3

      8                       Node8           1

Now the question is this that:

1)   How can we retrieve the entire structure in tree view form in a list box

2)   suppose we want to retrieve then tree structure of a particular node Like Node2.How?

3) I have some idea that this problem can be solve through recursion method.

Solve this problem and mail me.

Thanks in advance.

   

-question by VikramKeywords:

Unrecognized databaseVB6-MS Access Question

I have install the VB 6.0 Professional and MSDN 2000 Library on the system.

 I have MS office 2000. I make database in ms Access and access the table data in visual basic by drag & drop the data control.

 After that I set the property of data control like this

 Database name : give path of database where I stored.

When I set the Property of Recordsource it display the message "unrecognized format of the database store in "path where I store database (like db1)" .

 Pl. Help me what should I do when such type of message display on screen.

calling ms acccess switchboard by vb6 but the report of the switchboard is not openingVB6-MS Access Question

I make a ms access database with switchboard. I used vb code to call the switchboard of msaccess. The forms of the switchboard are working fine when I click but the reports are not opening. When I click the report from the switchboard, it looks like opening but it doesn't pop up. From ms access report properties, I make pop up and madal to yes but still not working.Is there any one who can help me with this? your help will be much appreciated.

-reply by ahid zameel

opening a database in vbaVB6-MS Access Question

We have just converted over to office 2007.  In my databases I have one database calling another, before the conversion it opened fine, now it just opens and then closes.   the code I used is

dim strdb as string

strdb = "flie name and path"

set appAccess = CreateObject("Access.Application")

With appAccess

.OpenCurrentDatabase strdb

. Visible = True

.RunCommand acCmdAppMaximize

end with

can anybody help me with this

 

 

-question by rick

 

Replying to iGuest-Jawa JamesVB6-MS Access Question

Replying to iGuest-Jawa JamesI think the memory of your computer is so small that's why it takesTime to access the data of your data base.. I suggest to uninstall the other programs in your computers so that it will run accurately..

-reply by janmark

 

vb6 - accessVB6-MS Access Question

If you want to access the data of MS access using visual basic 6,, you have to follow the following steps:

step 1:

go to control panel click "performances and maintenance", then click "administrative tools", and double click "Data Sources (ODBC)". When you see a dialog, click "system dsn" and click "add" then double click "microsoft access driver (*.Mdb)". click "select", then find the  MS access database where you save. And click ok. in "data source name type" the filename of your Ms access data base ( for example db1) . Then click OK. Press enter.

step 2:

start an vb6  then select "standar EXE".  click "project", click "components". In control check the "microsoft ado data control 6.0 (OLEDB)" then click ok. Then click the data control in the tools and add it in your form1 "adodc1" right? 'you can see it in the last tools beside the OLE name adodc1'. Put it in the form1.

 

after that. Righ click adodc1, click "adodc property" select the  ADODC data source name and fill the file name of your MS access data base (for example "db1"). After that click "record source" then fill the "command text (SQL)" input this command "select * from table1",,, if the table name of your data base is table1. Then click ok.

step 3:

 make a text name text1 then click it. And fill the properties bellow

datasource = click the arrow bellow and select adodc1

datafield =  click the arrow bellow and select field ( for example "name")

 

step 4:

try to run your program.

 

this is very sensitive.. That's why I advice to use a filename of your database is "db1" and the table is "table1" so that you can follow all the instructions I've given.. That's it.

 if the data of your MS data base is in the text1.Text, it means you got it.. But if not.. Try to analize of your mistake.. This is very sensitive... Try to be positive and patient.. I hope this comment will lead you success..

 -reply by janmark

visual basic 6.0VB6-MS Access Question

how do you search a particular table which is given by user as a string in visual basic 6.0 and he wants to search whether that particular string which is the table name in database is present or not what is the query that I can write plz help

its urgent thnx in advance 

-question by sabiha

Please, how do I link vb to access?
After filling a form in vb, how di I link the submit button of vb to access table. Also, how will I access the store values in access.
Please, help me with the procedure and the code.
Thank you


-reply by ibilola