This sounds like a homework assignment... I don't want to simply give you the answer. What ideas have you come up with so far?

Yes; first of all, MySQL is supported by many hosting companies. Secondly, if it is web based, then you lose any benefits to using Access. I would say MS Access's benefits really only come into...

My general rule of thumb is this: if the database is going to be used on a single workstation or a local network and by a relatively few number of people, then use MS Access, but if the database...

You are getting error 1004 because of the line:


With Selection.QueryTable


Since you have this line, you need to make sure that the selected cell when you run the code is part of the query...

Are you trying to allow the user to type in several quote values, all right under each other, and have the query show the data for each of those quote values?

You can try something similar to...

If the code in the previous post did work, then I would try the following code:



Sub Macro1()
'
' Macro1 Macro
' Macro recorded 27/04/2009 by User
'

Just so I'm clear, the code in the previous post does work, but you want to be able to select which number is selected (instead of always just showing number 5N8380). Is that correct?

As far as your error.. can you show the original code, which I assumed worked, and the modified code so that we can see the changes you made.

On the line you referenced, you have the following:
...

Here is a link to a file that shows how to connect to an Access database from Excel: http://www.oecd.org/dataoecd/55/15/35199750.pdf

It is dated and uses an older version of office, but the...

Try replacing the line
Console.WriteLine(vbTab(3) & "Menu" & vbNewLine)
with
Console.WriteLine(vbTab & "Menu" & vbNewLine)

You need to change the line:
Console.WriteLine("$" & i * 100 + 200 & "-$" & i * 100 + 299 & " is " & salaryRange(i + 1))

to

Console.WriteLine("$" & i * 100 & "-$" & i * 100 + 99 & " is " &...

There are several approaches:

FIRST APPROACH
1) Have a page to select an applicant.
2) When the user selects the applicant, a page comes up showing the details of the applicant.
3) On that...

If you don't give the entire path of the program, then Windows will search specific directories for that program.

You can change which directories it searches, but the common ones are c:\windows,...

Okay... I think I'm understanding this a little better, but I still have a few questions

(1) Is SHTS% the scoring percentage you are talking about?
(2) You mention the scoring percentage of the...

Well, I'm not sure exactly what you are trying to do, but I do have a few comments.

I noticed this block of code in the playButton_Click subroutine:


If Label1.Text = "Home Team...

Here's a link on how to read from and write to files in vb.net:

http://www.freevbcode.com/ShowCode.asp?ID=4492

Go to this site and look at Prims algorithm; while it doesn't make the hardest mazes, it is a simple algorithm to start with: http://www.astrolog.org/labyrnth/algrithm.htm

What you need to do is...

To help you in the right direction, for a maze program I made, I had a class called cell. The cell class had the following properties: bottomWall, leftWall, visited, enabled.

The bottomWall and...

First, you need to create a PictureBox. Then, you need to create code to generate a maze in an array. Once the maze is generated, you need to create code to display the maze in the PictureBox based...

Instead of declaring each number in a separate variable, you should use an array to store the numbers. Once you have them in an array, you then need to decide on a sorting method. There are many...

There are several maze generation algorithms. You can go here to see a few examples.

http://en.wikipedia.org/wiki/Maze_generation_algorithm

http://www.astrolog.org/labyrnth/algrithm.htm

Here is some example code of how to set up an array:


'Declare Array
Dim properties(3, 1) As String

'Set values of Array
properties(0, 0) = "Plaza"
...

You will need to use the LIKE operator with the % wildcard. There's more information here:
http://www.techonthenet.com/sql/like.php

You mention you get the same sum and average no matter which number you put in. Which line of code are you referring to when you say "for whatever number I put in".

Secondly, the following line
...

Add the following code to the on Click event of each of the comboboxes:


Me.ComboBox1.SelectedIndex = -1


Replace "ComboBox1" with the name of each comboBox.

When I have a lot of information to show, I use the TabControl control. This allows users to click on different tabs to view additional data. However, to get back to your question, you can use...

Hi, welcome. If you need any help with Visual Basic, please feel free to let us know here. If you are just wanting to introduce yourself, please use the following forum:
...

I don't see how this makes a 2D array in to a 1D array. All it does is loop through all the 'cells' of the array and stores a number as Index. What, by the way, is rowNum? It is neither declared...

Yes it would.

Try this:


Dim str As String
str = """House"""

What I would suggest would be to change strInputQuiz into an array that holds 5 elements. When you use the InputBox, assign each InputValue to a different element within the array.

I didn't see...

What is the purpose of having the class ArrayTest? I would recommend just having the array in the Sub New().

Please take a look at this code:


Public Sub main()
'Code to create Seats...

Since this sounds like an assignment for class, I will try to point you in the right direction and let you finish things off... let me know if you need more help.

1) You will probably want to use...

I guess I'm still not following... From your code, you are creating an array correctly with the lines


Dim test() As Boolean
test = New Boolean(0 To 10) {}


To read an element from the...

I'd be glad to help, but I'd like to know of any ideas you have concerning using an array in the code. Where do you think it would be most appropriate for one. This sounds like a homework...

Can you give us more information? Is InStr(txtOutput.Text, username) ever true? What does txtOuput.text look like within the first If block? What does count equal within the If block? I just want...

Here's a line to a site that shows how to read from a text file:

http://www.astahost.com/info.php/text-file-operations-vb-net_t6372.html

As far as writing to console, you can use this code:

...

I guess I don't know what you need help with. Do you need to know how to use a 2-d array? The problem you posted does not required a 2-d array.

It looks like you understand how to use a 1-d...

You can try code similar to this:


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim newForm(1) As Form

...

The problem you are running into is that the timer is never set to Enabled=False

After the interval, the time does not become disabled, but rather, runs the code in its block again.

Try...