473,394 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Access queries/ Search criteria

I am using a Access Database to search/add a bunch of information in
MS VB.net 2005 express. In the query (querybuilder) everything seems
right, but in the WHERE statement I use [Number] = me.textbox.text .

Then in the statement I have an if statement

IF combobox.text = option1 Then
e.databaseadapter.GetDataBy2() 'which is the query i built
end if

I get an error each time, and can't figure out if it is with the sql
statement, or the execution. Is there a search critria field i need
to put in place of me.textbox.text?

Apr 18 '07 #1
11 2259
On 18 Apr 2007 05:17:50 -0700, Ri*****@gmail.com wrote:

¤ I am using a Access Database to search/add a bunch of information in
¤ MS VB.net 2005 express. In the query (querybuilder) everything seems
¤ right, but in the WHERE statement I use [Number] = me.textbox.text .
¤
¤ Then in the statement I have an if statement
¤
¤ IF combobox.text = option1 Then
¤ e.databaseadapter.GetDataBy2() 'which is the query i built
¤ end if
¤
¤ I get an error each time, and can't figure out if it is with the sql
¤ statement, or the execution. Is there a search critria field i need
¤ to put in place of me.textbox.text?

What is the error that is being generated? BTW, Number is a Jet reserved word so it may not be a
good choice for a column name.
Paul
~~~~
Microsoft MVP (Visual Basic)
Apr 18 '07 #2
On Apr 18, 9:59 am, Paul Clement
<UseAdddressAtEndofMess...@swspectrum.comwrote:
On 18 Apr 2007 05:17:50 -0700, Riva...@gmail.com wrote:

¤ I am using a Access Database to search/add a bunch of information in
¤ MS VB.net 2005 express. In the query (querybuilder) everything seems
¤ right, but in the WHERE statement I use [Number] = me.textbox.text .
¤
¤ Then in the statement I have an if statement
¤
¤ IF combobox.text = option1 Then
¤ e.databaseadapter.GetDataBy2() 'which is the query i built
¤ end if
¤
¤ I get an error each time, and can't figure out if it is with the sql
¤ statement, or the execution. Is there a search critria field i need
¤ to put in place of me.textbox.text?

What is the error that is being generated? BTW, Number is a Jet reserved word so it may not be a
good choice for a column name.

Paul
~~~~
Microsoft MVP (Visual Basic)
This is basicly the error I get.

http://img107.imageshack.us/img107/8965/vbcn6.jpg

Apr 18 '07 #3
On Apr 18, 1:34 pm, Riva...@gmail.com wrote:
On Apr 18, 9:59 am, Paul Clement

<UseAdddressAtEndofMess...@swspectrum.comwrote:
On 18 Apr 2007 05:17:50 -0700, Riva...@gmail.com wrote:
¤ I am using a Access Database to search/add a bunch of information in
¤ MS VB.net 2005 express. In the query (querybuilder) everything seems
¤ right, but in the WHERE statement I use [Number] = me.textbox.text .
¤
¤ Then in the statement I have an if statement
¤
¤ IF combobox.text = option1 Then
¤ e.databaseadapter.GetDataBy2() 'which is the query i built
¤ end if
¤
¤ I get an error each time, and can't figure out if it is with the sql
¤ statement, or the execution. Is there a search critria field i need
¤ to put in place of me.textbox.text?
What is the error that is being generated? BTW, Number is a Jet reserved word so it may not be a
good choice for a column name.
Paul
~~~~
Microsoft MVP (Visual Basic)

This is basicly the error I get.

http://img107.imageshack.us/img107/8965/vbcn6.jpg- Hide quoted text -

- Show quoted text -
Any Ideas?

Apr 19 '07 #4
On 19 Apr 2007 05:14:37 -0700, Ri*****@gmail.com wrote:

¤ On Apr 18, 1:34 pm, Riva...@gmail.com wrote:
¤ On Apr 18, 9:59 am, Paul Clement
¤ >
¤ >
¤ >
¤ >
¤ >
¤ <UseAdddressAtEndofMess...@swspectrum.comwrote:
¤ On 18 Apr 2007 05:17:50 -0700, Riva...@gmail.com wrote:
¤ >
¤ ¤ I am using a Access Database to search/add a bunch of information in
¤ ¤ MS VB.net 2005 express. In the query (querybuilder) everything seems
¤ ¤ right, but in the WHERE statement I use [Number] = me.textbox.text .
¤ ¤
¤ ¤ Then in the statement I have an if statement
¤ ¤
¤ ¤ IF combobox.text = option1 Then
¤ ¤ e.databaseadapter.GetDataBy2() 'which is the query i built
¤ ¤ end if
¤ ¤
¤ ¤ I get an error each time, and can't figure out if it is with the sql
¤ ¤ statement, or the execution. Is there a search critria field i need
¤ ¤ to put in place of me.textbox.text?
¤ >
¤ What is the error that is being generated? BTW, Number is a Jet reserved word so it may not be a
¤ good choice for a column name.
¤ >
¤ Paul
¤ ~~~~
¤ Microsoft MVP (Visual Basic)
¤ >
¤ This is basicly the error I get.
¤ >
¤ http://img107.imageshack.us/img107/8965/vbcn6.jpg- Hide quoted text -
¤ >
¤ - Show quoted text -
¤
¤ Any Ideas?

Yes, the error indicates that one of the column names or criteria is not being recognized. I didn't
see your complete statement but it should look something like the following (assuming Number is a
numeric field):

"WHERE [Number] = " & me.textbox.text

In your example, me.textbox.text will not be evaluated until it is sent to the database engine
(which will have no clue as to what it is).
Paul
~~~~
Microsoft MVP (Visual Basic)
Apr 19 '07 #5
On Apr 19, 10:23 am, Paul Clement
<UseAdddressAtEndofMess...@swspectrum.comwrote:
On 19 Apr 2007 05:14:37 -0700, Riva...@gmail.com wrote:

¤ On Apr 18, 1:34 pm, Riva...@gmail.com wrote:
¤ On Apr 18, 9:59 am, Paul Clement
¤ >
¤ >
¤ >
¤ >
¤ >¤ <UseAdddressAtEndofMess...@swspectrum.comwrote:

¤ On 18 Apr 2007 05:17:50 -0700, Riva...@gmail.com wrote:
¤ >
¤ ¤ I am using a Access Database to search/add a bunch of information in
¤ ¤ MS VB.net 2005 express. In the query (querybuilder) everything seems
¤ ¤ right, but in the WHERE statement I use [Number] = me.textbox.text .
¤ ¤
¤ ¤ Then in the statement I have an if statement
¤ ¤
¤ ¤ IF combobox.text = option1 Then
¤ ¤ e.databaseadapter.GetDataBy2() 'which is the query i built
¤ ¤ end if
¤ ¤
¤ ¤ I get an error each time, and can't figure out if it is with the sql
¤ ¤ statement, or the execution. Is there a search critria fieldi need
¤ ¤ to put in place of me.textbox.text?
¤ >
¤ What is the error that is being generated? BTW, Number is a Jet reserved word so it may not be a
¤ good choice for a column name.
¤ >
¤ Paul
¤ ~~~~
¤ Microsoft MVP (Visual Basic)
¤ >
¤ This is basicly the error I get.
¤ >
¤ >http://img107.imageshack.us/img107/8965/vbcn6.jpg-Hide quoted text -
¤ >
¤ - Show quoted text -
¤
¤ Any Ideas?

Yes, the error indicates that one of the column names or criteria is not being recognized. I didn't
see your complete statement but it should look something like the following (assuming Number is a
numeric field):

"WHERE [Number] = " & me.textbox.text

In your example, me.textbox.text will not be evaluated until it is sent to the database engine
(which will have no clue as to what it is).

Paul
~~~~
Microsoft MVP (Visual Basic)
SELECT [Asset Tag Number], [User], Username, [Department Name],
[Asset Name], [Asset Type], Catergory, [Serial Number], [Purchase
Order Number],
[Purchase Price], [Purchase Date], Warrenty,
Notes
FROM PPC_Inventory
WHERE '[Asset Tag Number] =' & me.ToolStripTextBox1.[text]
ORDER BY [Asset Tag Number]

is my query, in query builder. No luck still. any help?

Apr 20 '07 #6
On 20 Apr 2007 07:22:37 -0700, Ri*****@gmail.com wrote:

¤ ¤ On 18 Apr 2007 05:17:50 -0700, Riva...@gmail.com wrote:
¤ ¤ >
¤ ¤ ¤ I am using a Access Database to search/add a bunch of information in
¤ ¤ ¤ MS VB.net 2005 express. In the query (querybuilder) everything seems
¤ ¤ ¤ right, but in the WHERE statement I use [Number] = me.textbox.text .
¤ ¤ ¤
¤ ¤ ¤ Then in the statement I have an if statement
¤ ¤ ¤
¤ ¤ ¤ IF combobox.text = option1 Then
¤ ¤ ¤ e.databaseadapter.GetDataBy2() 'which is the query i built
¤ ¤ ¤ end if
¤ ¤ ¤
¤ ¤ ¤ I get an error each time, and can't figure out if it is with the sql
¤ ¤ ¤ statement, or the execution. Is there a search critria field i need
¤ ¤ ¤ to put in place of me.textbox.text?
¤ ¤ >
¤ ¤ What is the error that is being generated? BTW, Number is a Jet reserved word so it may not be a
¤ ¤ good choice for a column name.
¤ ¤ >
¤ ¤ Paul
¤ ¤ ~~~~
¤ ¤ Microsoft MVP (Visual Basic)
¤ ¤ >
¤ ¤ This is basicly the error I get.
¤ ¤ >
¤ ¤ >http://img107.imageshack.us/img107/8965/vbcn6.jpg-Hide quoted text -
¤ ¤ >
¤ ¤ - Show quoted text -
¤ ¤
¤ ¤ Any Ideas?
¤ >
¤ Yes, the error indicates that one of the column names or criteria is not being recognized. I didn't
¤ see your complete statement but it should look something like the following (assuming Number is a
¤ numeric field):
¤ >
¤ "WHERE [Number] = " & me.textbox.text
¤ >
¤ In your example, me.textbox.text will not be evaluated until it is sent to the database engine
¤ (which will have no clue as to what it is).
¤ >
¤ Paul
¤ ~~~~
¤ Microsoft MVP (Visual Basic)
¤
¤ SELECT [Asset Tag Number], [User], Username, [Department Name],
¤ [Asset Name], [Asset Type], Catergory, [Serial Number], [Purchase
¤ Order Number],
¤ [Purchase Price], [Purchase Date], Warrenty,
¤ Notes
¤ FROM PPC_Inventory
¤ WHERE '[Asset Tag Number] =' & me.ToolStripTextBox1.[text]
¤ ORDER BY [Asset Tag Number]
¤
¤ is my query, in query builder. No luck still. any help?

Warranty is spelled incorrectly. Is that how it appears in the database table?
Paul
~~~~
Microsoft MVP (Visual Basic)
Apr 20 '07 #7
On Apr 20, 10:50 am, Paul Clement
<UseAdddressAtEndofMess...@swspectrum.comwrote:
On 20 Apr 2007 07:22:37 -0700, Riva...@gmail.com wrote:

¤ ¤ On 18 Apr 2007 05:17:50 -0700, Riva...@gmail.com wrote:
¤ ¤ >
¤ ¤ ¤ I am using a Access Database to search/add a bunch of information in
¤ ¤ ¤ MS VB.net 2005 express. In the query (querybuilder) everything seems
¤ ¤ ¤ right, but in the WHERE statement I use [Number] = me..textbox.text .
¤ ¤ ¤
¤ ¤ ¤ Then in the statement I have an if statement
¤ ¤ ¤
¤ ¤ ¤ IF combobox.text = option1 Then
¤ ¤ ¤ e.databaseadapter.GetDataBy2() 'which is the query i built
¤ ¤ ¤ end if
¤ ¤ ¤
¤ ¤ ¤ I get an error each time, and can't figure out if it iswith the sql
¤ ¤ ¤ statement, or the execution. Is there a search critriafield i need
¤ ¤ ¤ to put in place of me.textbox.text?
¤ ¤ >
¤ ¤ What is the error that is being generated? BTW, Number is aJet reserved word so it may not be a
¤ ¤ good choice for a column name.
¤ ¤ >
¤ ¤ Paul
¤ ¤ ~~~~
¤ ¤ Microsoft MVP (Visual Basic)
¤ ¤ >
¤ ¤ This is basicly the error I get.
¤ ¤ >
¤ ¤ >http://img107.imageshack.us/img107/8...jpg-Hidequoted text -
¤ ¤ >
¤ ¤ - Show quoted text -
¤ ¤
¤ ¤ Any Ideas?
¤ >
¤ Yes, the error indicates that one of the column names or criteria is not being recognized. I didn't
¤ see your complete statement but it should look something like the following (assuming Number is a
¤ numeric field):
¤ >
¤ "WHERE [Number] = " & me.textbox.text
¤ >
¤ In your example, me.textbox.text will not be evaluated until it is sent to the database engine
¤ (which will have no clue as to what it is).
¤ >
¤ Paul
¤ ~~~~
¤ Microsoft MVP (Visual Basic)
¤
¤ SELECT [Asset Tag Number], [User], Username, [Department Name],
¤ [Asset Name], [Asset Type], Catergory, [Serial Number], [Purchase
¤ Order Number],
¤ [Purchase Price], [Purchase Date], Warrenty,
¤ Notes
¤ FROM PPC_Inventory
¤ WHERE '[Asset Tag Number] =' & me.ToolStripTextBox1.[text]
¤ ORDER BY [Asset Tag Number]
¤
¤ is my query, in query builder. No luck still. any help?

Warranty is spelled incorrectly. Is that how it appears in the database table?

Paul
~~~~
Microsoft MVP (Visual Basic)
yea, thats not the problem. its spelled like that in the database too.

Apr 20 '07 #8
On 20 Apr 2007 08:42:18 -0700, Ri*****@gmail.com wrote:

¤ ¤ ¤ This is basicly the error I get.
¤ ¤ ¤ >
¤ ¤ ¤ >http://img107.imageshack.us/img107/8...jpg-Hidequoted text -
¤ ¤ ¤ >
¤ ¤ ¤ - Show quoted text -
¤ ¤ ¤
¤ ¤ ¤ Any Ideas?
¤ ¤ >
¤ ¤ Yes, the error indicates that one of the column names or criteria is not being recognized. I didn't
¤ ¤ see your complete statement but it should look something like the following (assuming Number is a
¤ ¤ numeric field):
¤ ¤ >
¤ ¤ "WHERE [Number] = " & me.textbox.text
¤ ¤ >
¤ ¤ In your example, me.textbox.text will not be evaluated until it is sent to the database engine
¤ ¤ (which will have no clue as to what it is).
¤ ¤ >
¤ ¤ Paul
¤ ¤ ~~~~
¤ ¤ Microsoft MVP (Visual Basic)
¤ ¤
¤ ¤ SELECT [Asset Tag Number], [User], Username, [Department Name],
¤ ¤ [Asset Name], [Asset Type], Catergory, [Serial Number], [Purchase
¤ ¤ Order Number],
¤ ¤ [Purchase Price], [Purchase Date], Warrenty,
¤ ¤ Notes
¤ ¤ FROM PPC_Inventory
¤ ¤ WHERE '[Asset Tag Number] =' & me.ToolStripTextBox1.[text]
¤ ¤ ORDER BY [Asset Tag Number]
¤ ¤
¤ ¤ is my query, in query builder. No luck still. any help?
¤ >
¤ Warranty is spelled incorrectly. Is that how it appears in the database table?
¤ >
¤ Paul
¤ ~~~~
¤ Microsoft MVP (Visual Basic)
¤
¤ yea, thats not the problem. its spelled like that in the database too.

You're not trying to run this from the query builder are you?
Paul
~~~~
Microsoft MVP (Visual Basic)
Apr 20 '07 #9
On Apr 20, 3:15 pm, Paul Clement
<UseAdddressAtEndofMess...@swspectrum.comwrote:
On 20 Apr 2007 08:42:18 -0700, Riva...@gmail.com wrote:

¤ ¤ ¤ This is basicly the error I get.
¤ ¤ ¤ >
¤ ¤ ¤ >http://img107.imageshack.us/img107/8...Hidequotedtext -
¤ ¤ ¤ >
¤ ¤ ¤ - Show quoted text -
¤ ¤ ¤
¤ ¤ ¤ Any Ideas?
¤ ¤ >
¤ ¤ Yes, the error indicates that one of the column names or criteria is not being recognized. I didn't
¤ ¤ see your complete statement but it should look something likethe following (assuming Number is a
¤ ¤ numeric field):
¤ ¤ >
¤ ¤ "WHERE [Number] = " & me.textbox.text
¤ ¤ >
¤ ¤ In your example, me.textbox.text will not be evaluated until it is sent to the database engine
¤ ¤ (which will have no clue as to what it is).
¤ ¤ >
¤ ¤ Paul
¤ ¤ ~~~~
¤ ¤ Microsoft MVP (Visual Basic)
¤ ¤
¤ ¤ SELECT [Asset Tag Number], [User], Username, [Department Name],
¤ ¤ [Asset Name], [Asset Type], Catergory, [Serial Number], [Purchase
¤ ¤ Order Number],
¤ ¤ [Purchase Price], [Purchase Date], Warrenty,
¤ ¤ Notes
¤ ¤ FROM PPC_Inventory
¤ ¤ WHERE '[Asset Tag Number] =' & me.ToolStripTextBox1.[text]
¤ ¤ ORDER BY [Asset Tag Number]
¤ ¤
¤ ¤ is my query, in query builder. No luck still. any help?
¤ >
¤ Warranty is spelled incorrectly. Is that how it appears in the database table?
¤ >
¤ Paul
¤ ~~~~
¤ Microsoft MVP (Visual Basic)
¤
¤ yea, thats not the problem. its spelled like that in the database too.

You're not trying to run this from the query builder are you?

Paul
~~~~
Microsoft MVP (Visual Basic)
Yes I am, alternative?

Apr 20 '07 #10
On 20 Apr 2007 12:41:46 -0700, Ri*****@gmail.com wrote:
¤ ¤ ¤ ¤ Any Ideas?
¤ ¤ ¤ >
¤ ¤ ¤ Yes, the error indicates that one of the column names or criteria is not being recognized. I didn't
¤ ¤ ¤ see your complete statement but it should look something like the following (assuming Number is a
¤ ¤ ¤ numeric field):
¤ ¤ ¤ >
¤ ¤ ¤ "WHERE [Number] = " & me.textbox.text
¤ ¤ ¤ >
¤ ¤ ¤ In your example, me.textbox.text will not be evaluated until it is sent to the database engine
¤ ¤ ¤ (which will have no clue as to what it is).
¤ ¤ ¤ >
¤ ¤ ¤ Paul
¤ ¤ ¤ ~~~~
¤ ¤ ¤ Microsoft MVP (Visual Basic)
¤ ¤ ¤
¤ ¤ ¤ SELECT [Asset Tag Number], [User], Username, [Department Name],
¤ ¤ ¤ [Asset Name], [Asset Type], Catergory, [Serial Number], [Purchase
¤ ¤ ¤ Order Number],
¤ ¤ ¤ [Purchase Price], [Purchase Date], Warrenty,
¤ ¤ ¤ Notes
¤ ¤ ¤ FROM PPC_Inventory
¤ ¤ ¤ WHERE '[Asset Tag Number] =' & me.ToolStripTextBox1.[text]
¤ ¤ ¤ ORDER BY [Asset Tag Number]
¤ ¤ ¤
¤ ¤ ¤ is my query, in query builder. No luck still. any help?
¤ ¤ >
¤ ¤ Warranty is spelled incorrectly. Is that how it appears in the database table?
¤ ¤ >
¤ ¤ Paul
¤ ¤ ~~~~
¤ ¤ Microsoft MVP (Visual Basic)
¤ ¤
¤ ¤ yea, thats not the problem. its spelled like that in the database too.
¤ >
¤ You're not trying to run this from the query builder are you?
¤ >
¤ Paul
¤ ~~~~
¤ Microsoft MVP (Visual Basic)
¤
¤ Yes I am, alternative?

Can't you just hard code the value during testing? The query builder doesn't really know anything
about the TextBox.

If it's preventing you from saving the query then you should be able to enter the statement in the
Properties Windows for the object.
Paul
~~~~
Microsoft MVP (Visual Basic)
Apr 23 '07 #11
On Apr 23, 10:45 am, Paul Clement
<UseAdddressAtEndofMess...@swspectrum.comwrote:
On 20 Apr 2007 12:41:46 -0700, Riva...@gmail.com wrote:

¤ ¤ ¤ ¤ Any Ideas?
¤ ¤ ¤ >
¤ ¤ ¤ Yes, the error indicates that one of the column names or criteria is not being recognized. I didn't
¤ ¤ ¤ see your complete statement but it should look something like the following (assuming Number is a
¤ ¤ ¤ numeric field):
¤ ¤ ¤ >
¤ ¤ ¤ "WHERE [Number] = " & me.textbox.text
¤ ¤ ¤ >
¤ ¤ ¤ In your example, me.textbox.text will not be evaluated until it is sent to the database engine
¤ ¤ ¤ (which will have no clue as to what it is).
¤ ¤ ¤ >
¤ ¤ ¤ Paul
¤ ¤ ¤ ~~~~
¤ ¤ ¤ Microsoft MVP (Visual Basic)
¤ ¤ ¤
¤ ¤ ¤ SELECT [Asset Tag Number], [User], Username, [Department Name],
¤ ¤ ¤ [Asset Name], [Asset Type], Catergory, [Serial Number], [Purchase
¤ ¤ ¤ Order Number],
¤ ¤ ¤ [Purchase Price], [Purchase Date], Warrenty,
¤ ¤ ¤ Notes
¤ ¤ ¤ FROM PPC_Inventory
¤ ¤ ¤ WHERE '[Asset Tag Number] =' & me.ToolStripTextBox1..[text]
¤ ¤ ¤ ORDER BY [Asset Tag Number]
¤ ¤ ¤
¤ ¤ ¤ is my query, in query builder. No luck still. any help?
¤ ¤ >
¤ ¤ Warranty is spelled incorrectly. Is that how it appears in the database table?
¤ ¤ >
¤ ¤ Paul
¤ ¤ ~~~~
¤ ¤ Microsoft MVP (Visual Basic)
¤ ¤
¤ ¤ yea, thats not the problem. its spelled like that in the database too.
¤ >
¤ You're not trying to run this from the query builder are you?
¤ >
¤ Paul
¤ ~~~~
¤ Microsoft MVP (Visual Basic)
¤
¤ Yes I am, alternative?

Can't you just hard code the value during testing? The query builder doesn't really know anything
about the TextBox.

If it's preventing you from saving the query then you should be able to enter the statement in the
Properties Windows for the object.

Paul
~~~~
Microsoft MVP (Visual Basic)
Anyone use VB 2005 express and know a solution for queries using a
textbox? It hangs on the me.databaseadapter.GetDataBy2() statement,
I'm not sure what else I can use.

Apr 26 '07 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: mfyahya | last post by:
Hi, I'm new to databases :) I need help speeding up select queries on my data which are currently taking 4-5 seconds. I set up a single large table of coordinates data with an index on the fields...
0
by: s_gregory | last post by:
The mdb is considerable size 70 +- mb. A complex union query was working well, but when an additional union select... was added into the query, selecting identical fields from a different source,...
1
by: Philip | last post by:
Hey everyone, I've got a real newbie question and I'll try to make some sense as I explain it. I've got a three tables for simplification. SCREENS (screens names) CONTROLS (control names)...
4
by: Bob Alston | last post by:
Some more, rather specific Access performance questions. IN a split front-end & back-end Access/Jet ONLY LAN situation, and with all query criteria fields and join fields indexed: 1. Is is...
9
by: pic078 via AccessMonster.com | last post by:
I need serious help - I have a frontend/backend Access database (2 MDE Files) that remains stuck in task manager after exiting the application - you can't reopen database after exiting as a result...
8
by: Sid | last post by:
I hope someone could help me with this. I am trying to setup a criteria to decide when to allow/not allow user to click on the check box. logically it looks simple but I am not able to...
1
MMcCarthy
by: MMcCarthy | last post by:
Access has a number of built-in functions which can be generally used in queries or VBA code. Some of the more common ones are: Note: anything in square brackets is optional Date Functions ...
0
MMcCarthy
by: MMcCarthy | last post by:
The more data you include in your tables the more you will need to have indexes to search and sort that data. However, there is a balance between having enough indexes and too many. Too many...
2
by: MNNovice | last post by:
I am working on a database on my CD collection using Access 2003. Some of the table structures are given below. Table 1 tblMusicCategory Field 1: MusicCategoryID - Auto Number (PK) Field 2:...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.