Visual Basic

Re: VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

30-Jul-15 9:59

Turn what off and on again? AccessDatabaseEngine_64 was installed, rebooted, test failed, uninstalled AccessDatabaseEngine_64, rebooted still fails.

Wendelius30-Jul-15 8:44

Wendelius

30-Jul-15 8:44

The problem is that your application is 32 bit so it requires a 32 bit driver. In order to get the current application working you should install 32 bit version. Try downloading it from https://www.microsoft.com/en-us/download/details.aspx?id=13255[^].

Another option is to compile the application as 64 bit and use the 64 bit driver.

Re: VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

QuickBooksDev30-Jul-15 9:58

Re: VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

30-Jul-15 9:58

As I said below that will not install. Error message=You cannot install the 32 bit version of Microsoft Access Database Engine 2010 because you current have 64-but Office products installed. If you want to install 32-bit installation of Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products. After uninstalling the following product(s), return setup in order to install 32-but version of Microsoft Access Database Engine 2010:
Microsoft Office Standard 2010.
I really do not want to uninstall Office. I do not know if my customers have the 32 bit versions or would be using them. Seems like the 64-bit version is pre-installed on some machines.

Wendelius30-Jul-15 10:01

Wendelius

30-Jul-15 10:01

Then it sounds that you should try the 64 bit compile.

Re: VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

QuickBooksDev30-Jul-15 10:03

Re: VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

30-Jul-15 10:03

Can't an interface that the program uses for QuickBooks requires 32bit.

PIEBALDconsult30-Jul-15 10:01

PIEBALDconsult

30-Jul-15 10:01

QuickBooksDev wrote:
I really do not want to uninstall Office

You don't need to install ACE on a system that already has Office.

Re: VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

QuickBooksDev30-Jul-15 10:05

Re: VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

30-Jul-15 10:05

Ok, then what should I do to make it work. I was just following other postings on the web and some said that ACE was needed. If not great but it still does not work.

PIEBALDconsult30-Jul-15 10:08

PIEBALDconsult

30-Jul-15 10:08

ACE is included with Office.

Re: VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

QuickBooksDev30-Jul-15 10:10

Re: VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

30-Jul-15 10:10

What do I have to do to make it work? I cannot change the program to 64bit.

Richard Deeming30-Jul-15 10:31

Richard Deeming

30-Jul-15 10:31

If you've got a 64-bit version of Office installed, you can't install the 32-bit driver. There doesn't seem to be a sensible reason for this, but you'd have to ask Microsoft for a definitive answer.

Depending on the files you're reading, you might be able to get away with installing the Office 2007 version[^] of the driver, as suggested in this SO answer[^]. The 2007 drivers were 32-bit only, and shouldn't be blocked by the 64-bit version of Office 2010.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Previous and Next button Problem

Member 1178652230-Jul-15 3:23

30-Jul-15 3:23

I am currently working on a cbt software and i want the questions to be coming randomly ( one per page) which is working. Please how can i program Previous and Next button with WPF of VB.NET so user can skip and later go back before the exam finishes. Please help me. Have been on it for like 3 weeks now. thank you

Ralf Meier30-Jul-15 5:34

30-Jul-15 5:34

At which point do you stuck ?
I think, at first you have to build up a kind of collection in which all Page-Contents are memorized, the selected answers and also the order of appearance.
After that you build up a Page, which has the 2 Buttons which increase or decrease the Collection-Pointer and which displays the Collection-Content at pointer-position.

Member 1178652230-Jul-15 7:51

30-Jul-15 7:51

I used a loop with total number of question a user can answer.. so when it clicks next. it gets incremented by one.. example Is a user can answer 10 questions and he is on number 7, he now moved back to question two, how do I program it to fetch what's on question two and when he is done , he won't see different questions from 4-7 he already did and also move on to complete the questions.. I am really struck there, please help me

Ralf Meier30-Jul-15 8:50

30-Jul-15 8:50

As I have written before :
I would create a class which could memorize all the necessary information - for example the question-text, the given answer and so on (all what you think that you need).
Now you initialize your question-catalogue - each question is stored in this class-variable and the class is stored in the collection.

How much experience do you have with classes, collections, dynamic creation of classes ?
Could you imagine, what I tried to explain you ?

Member 1178652230-Jul-15 12:01

30-Jul-15 12:01

six month now...

Ralf Meier30-Jul-15 18:25

30-Jul-15 18:25

OK ... you understood what I have decribed ?
How should we go further ?

Member 1178652230-Jul-15 23:00

30-Jul-15 23:00

yes i do. we can go further with practical examples ( probably a simple sample code) or what do you think?

Ralf Meier30-Jul-15 23:54

30-Jul-15 23:54

OK ... of course ...
I suggest that you create a class with the (from your point) necessary properties.
After that I need to know which Information out of your database should be stored for questioning.
Then we could fill the from me suggested collection with the new class-items which could be used (later) for your visualisation on the form.

It's your turn ... Wink | ;)

Member 1178652231-Jul-15 1:29

31-Jul-15 1:29

yes i have created a class called "Bank"for the questions, it has the questions, options and correct answer, and its selecting per group (i.e. for a particular subject example English)
i have the properties as follows

public property questionNo as String
public property question as String
public property optionA as String
public property optionB as String
public property optionC as String
public property CorrectAnswer as String

Ralf Meier31-Jul-15 1:50

31-Jul-15 1:50

OK ...
Now you should create the Collection for the Animation/Visualisation.
This could work like this :

dim QuestionCollection as new collection

Sub Initialize_Collection
    QuestionCollection.clear 

    for i as integer = 1 to 10
       dim myBank as new Bank
       myBank.QuestionNo = ""    ' assign the Question-No. here
       myBank.Question = ""      ' assign the Question-Text here
       myBank.OptionA = ""       ' assign the Option-Value A here
       myBank.OptionB = ""       ' assign the Option-Value B here
       myBank.OptionC = ""       ' assign the Option-Value C here
       myBank.CorrectAnswer = "" ' assign the correct Answer-Text here
       myBank.Result = false     ' you should add a boolean as result for the question to 
your class
       QuestionCollection.add (myBank) 
    next  
End Sub

now you could work with this Collection on your Form.
With your Buttons you should select the index from the Collection-Entry and put the data of it to your Form-Labels/TextBoxes/OptionButtons etc.

Do you understand what I mean ?

Member 1178652231-Jul-15 2:49

31-Jul-15 2:49

Yes, i understood it a bit. like am creating a new List(of Collection) . and the loop means the user has 10 questions to answer, can you explain further please.. sorry for bothering you this much

Ralf Meier31-Jul-15 2:58

31-Jul-15 2:58

NO ... if you want to do it with a List then you have to use a List (of Bank) - not of collection.
Either a collection or a generic List.

When you generate the List (or collection) you create severall instances of Bank (your class-definition). Each Instance should be filled with the needed data - for example the question-text and so on.

Please think a bit - some of the work should be done by you ... Cool | :cool:

Member 1178652231-Jul-15 3:49

31-Jul-15 3:49

i know right.. let me work more on myself, i would get back to you. thanks alot, i really appreciate. God bless you

Ralf Meier31-Jul-15 9:29