|
But he's not useing SQL Server, he is using Access.
---
b { font-weight: normal; }
|
|
|
|
|
Other databases, like SQL Server and MySQL, uses % for wildcard. Access uses either * or %, at least in most cases, and at least some versions of Access.
It sounds a bit strange if the same version of Access handles this differently in certain queries, but strange is not really surprising when it comes to Access... Have you noticed any patterns in the behaviour, like a difference between using Text and Memo fields?
---
b { font-weight: normal; }
|
|
|
|
|
Are you mixing DAO and ADO code?
Normally access uses * as a wildcard but if you use ADO to access it you need to use %.
So a query in the Query designer in access will always be * but 'normally' (you should be using ADO really) in code it will be %. The exception is DAO which is an older access method is closely tied to jet and is in some case much faster and better for dealing with access databases will use * as it is so closely linked to the Jet engine.
Jon
|
|
|
|
|
hellow to all ..
i wanna know what items are selected when i do a group selection in a datagrid like to mark more than item , i wanna know what items are marked .
thxx
|
|
|
|
|
pls help on
1. reading and writing on textfiles using vb6
2. previewing report on vb6 using msword
3.reading and displaying acces database structure and has
a. ability to add, drop, truncate table
b. ability to add, drop, truncate field
adikkaymonic
|
|
|
|
|
You'll find help in these places:
1. Visual Studio help files (that's what the F1 key and the Help menu are for).
2. MSDN[^]
3. Google[^]
Learn to use them - thay are your friends.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
How could I forget - there is a fourth!
4. The Code Project[^]
Just use the Search facility (at the top of the web page).
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
Hi all,
i want to load forms dynamically in the project window at run time...
how can i do tht..
thx
Plzz help me.... 
Arshaad
-- modified at 7:14 Wednesday 22nd March, 2006
|
|
|
|
|
Populating a treeview with infomation from 3 tables in a sqlserver express DB needing
catagory 1 as parent
catagory 2 as child
and list as grandchild
I cant seen to declare anything as a node my its me but I cant grasp a way to to this ant help would I be gratefull
|
|
|
|
|
I have a web control which is a dropdown list box (created & populated in VB.NET) - I want to be able to manipulate the selected value of this dropdown box based on text entered elsewhere (in another control - a textbox).
For this I'd like to use the onkeyup or onkeypress methods and trigger a Javascript function which will select a particular value in the dropdown box. My dropdown box is not a typical HTML options box, but it's a VB dropdown web control.
Such being the case how do I do this in Javascript? I found some code elsewhere (which I'm listing below) but this will not apply (I think) in my case - do I use some other getElement* method to get to the first item populated in the dropdown box?
function searchDropdown(searchStr,ddObj) {
var index = ddObj.getElementsByTagName("option");
for(var i = 0; i < index.length; i++) {
if(index[i].firstChild.nodeValue.toLowerCase().substring(0,searchStr.length) == searchStr.toLowerCase()) {
index[i].selected = true;
break;
}
}
}
|
|
|
|
|
That code is really ugly...
It is designed to go trough all the options in all the selectobxes on the form.
But when it finds the first item that match it breaks from searching leaving other potential mathing options (in other selectboxes) un-selected.
What you should do is write a function that will take two arguments. One is search string, and the other is the ID of your select box.
This function should only go trough the options of that selectbox.
Then you simply add the onkeydown event and call your function from there.
--------------------------------------------------------
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
How to convert Word do:-Ocument to XML and XML document to Word using VB.NET?
|
|
|
|
|
I need to create a grid thats a logarithmic scale for plotting curves. I've heard I'll have to use GDI+ to achieve this, and I'm using ZedGraph at the moment, but I have NO idea how to create a grid that is a base 10 logarithmic scale for an axis.
Any help would be greatly appreciated!
|
|
|
|
|
Hi all,
How to integrate "windows image and fax viewer" in vb.net application to view images. ?
how to run .exe from application ? as like 'shell' in vb6
|
|
|
|
|
I would like to get assistance on the following:
1) I am using an "Explorer Form" which should show on the left side a tree view of specific paths, for example:
- root (mapped to c:\tmp; or mapped to whatever specific path I would like)
- subdira (c:\tmp\dir1)
- subdirb (c:\tmp\dir2)
The form should allow me to add/remove/modify these nodes as I wish... Like I could add a subdirc, subdird, etc... And also remove them; however these should not be removed if there any files besides the descriptive "Desktop.ini" I am explaining later. When creating each, a modifiable "Desktop.ini" file would be created under each that needs to contain the folder's description, so that if I highlight the folder, a description will automatically pop-up, and if I need to go and change such description I could do so too. In essence, I can create a folder, add a description for it, it can contain certain types of files (example image files: jpeg/jpg, gif, bmp, etc), or whichever types I decide to be able to add to it.
2) However, this is where the subdirectory creation should end, by that I mean there should be no more ramifications under these newly created directories. No subdira\sub-subdira (c:\tmp\dir1\whatever; it should end at c:\tmp\dir1).
3) In doing so, I would also like to be able to view the contents of the folders on the right pane, just like Windows explorer does. However, these should be only represented as small icons (or thumbnails for images), and if double clicked on a particular image, it can be sized to larger size that will fit most if not all of the right pane (not open another program, but just enlarge to fit on the right pane).
Any suggestions or known links that already request such structure?
Thanks!
 
madxxi
|
|
|
|
|
Hello to everyone. for my project i need to display some data in a datagridview. these data are contained in an Adodb.recordset object, that is given from an external class they gave me (and i am _forced_ to use adodb.recordsets).
the problem is, i can't set the datasource for the datagridview to be the recordset. i'll give you an example:
Dim dy As New ADODB.Recordset
Dim query As String = "SELECT * FROM table1"
''MyConn is an instance of the class i must use
MyConn.OpenRecordset(dy, query)
at this point i would write:
DataGridView1.DataSource = dy
it doesn't give me an error, but it doesn't work either, my datagridview remains empty.
is there any way to work on it without using datasets? i sadly have to use recordsets...
thanks in advance and sorry for my bad english.
~~~ From Milano to The Hague, easy as it goes ~~~
|
|
|
|
|
Since the ADODB.Recordset class doesn't support the required Interfaces, you can't use it to bind to a DataGridView. You'll have to translate it into a DataSet object to use the data.
If you're writing the code, why on earth do you HAVE to use the older classes???? I see no point to it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i HAVE to use the older classes because i work in a place full of quiche-eaters, who programmed in vb 6 until two days ago, and they suddenly decided to go VB.NET. so they hired me (and i am a c# programmer, who programmed serial interfaces with no experiences on databases, not even a vb.net one) and they gave me their old classes, just automatically converted. and of course, they forbid me to rewrite the class from scratch, because otherwise they would not be able to use it. this is my unlucky story...
however this morning i found a way, i use an OleDb.OleDbDataAdapter and with the method Fill i convert the recordset to a datatable. thanks anyways for having listened to my rant! ^__^
~~~ From Milano to The Hague, easy as it goes ~~~
|
|
|
|
|
|
Dave Kreskowiak wrote: Wouldn't be able to use it or wouldn't be ablt to understand it?? There's a huge difference you know!
they won't understand it, and thus they won't be able to use it when i'll quit the job (in september, i hope  )
~~~ From Milano to The Hague, easy as it goes ~~~
|
|
|
|
|
Don't you hate being the most intelligent person in the room?? Noone to learn anything from...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i should have never taken this job, but you know, they caught me with a "WILL CODE FOR FOOD" sign around my neck...
~~~ From Milano to The Hague, easy as it goes ~~~
|
|
|
|
|
My employer wants a streaming ticker tape on the bottem of the tv screen like the stock market to show precentage of work done on current projects and any messages for employees. It needs to also be up to date maybe 5-10 min update cycle and would use a wireless barcode scanner to update said precentage I've been coding for about 2 months in the real world and not sure if this is way out of my scope. Sorry for the bother but I'm lost thank you for any help.
scott
|
|
|
|
|
|
How to add icons to main menu items...???
<blink>FeRtoll Software.net
------------
E-Mail me
WebPage
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
Wouldn't be able to use it or wouldn't be ablt to understand it?? There's a huge difference you know!