Unknown table name in VB.net using microsoft Access?

Question

1.00/5 (1 vote)

See more:

Hai there guys. Sorry if my subject isn't clear enough because I don't know how else to put. So here's the thing, I need to debug and test a VB.NET windows application for hotel management system. I'm quite new to VB.NET, so there is a few lines of database query that I didn't get. There is a few lines such as :

VB

Com.CommandText = "Select * from QRoom Order by RoomNo"

or

VB

Com.CommandText = "Select Floor from QRoom where RoomNo=" & cbo.Text & ""

as you can see the table name there is QRoom but when I check within the Access database, there is no table name QRoom. But if I change the table name to the one that us in the database(which is my case, it is TblRoom), then there will be errors. So I didn't get why is that. Any help is appreciated. :)

p/s : the guy who wrote this code is unreachable st the moment so I cannot directly ask him. :(

Posted 26-Nov-12 22:03pm

nizam15

Add a Solution

Comments

André Kraak 27-Nov-12 4:37am

Did you check to see whether QRoom is a query in the database?
Does the table TblRoom contain the field RoomNo?

nizam15 27-Nov-12 4:42am

yes, there is a field name RoomNo within the TblRoom table.
where to check if there is a query in the database?sorry this is my first time using microsoft access.

André Kraak 27-Nov-12 4:51am

I tried finding something that shows where the queries are. This might help Queries For MS Access 2007[^].

nizam15 27-Nov-12 5:32am

I did find the queries. But what I didn't understand is why is it when I change the queries I posted above to an actual table name within the database, it came up with an error :
"No value given for one or more required parameters."

as if that table doesn't exist.

_Vitor Garcia_ 28-Nov-12 5:02am

My best guest is that QRoom is a query with parameters.
Find the query and see which parameter it is waiting for and act accordingly.

_Vitor Garcia_ 28-Nov-12 5:03am

Which version of ms access are you using ?

Ezra Neil 3-Jan-13 6:07am

I agree with this. It is most probably another query with parameter. Look carefully in the list of tables.

nizam15 27-Nov-12 5:01am

thanks for the reference. Well if I follow that correctly, I can't seem to find any query for that particular table.

[no name] 27-Nov-12 10:58am

Did you check to see if its in the list of views?

[no name] 27-Nov-12 10:59am

Please post the code preceeding the query

nizam15 28-Nov-12 9:40am

it's ok guys, I'm satisfied by finding what is the mysteries behind the Q table. Thanks a bunch guys~ :)

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)