Search:

SELECT * FROM table WHERE Month([date field])=1 AND YEAR([date field])=2007

in SQL ...WHERE Field IS NOT NULL

in VB
If not isnull(rs!field) then ...

There are several possible reasons.
Are you using a recordset that gets data from than one table and then you try to delete with rs.delete method?
Please paste the line of code that fires the...

Here is a good link with example. Good luck :)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconpartsofdatareport.asp

On the project explorer right click -> Add -> DataReport.
It works with recordsets
I'll give you an example.

With DataReport for example.

Hi all!
How can I make a ZIP archive? I have my database, I make BackUp's but I want to compress the database also.
I've been searching a lot but could not actually find a good example.

Good...

If the property of the TextBox in the DataReport "CanGrow" is set to TRUE then make it FALSE.
And also you should make the TextBox width to be able to show the longest string in your database.

Hm, if you have Visual Studio installed then just find the PROJECT file and double click on it... (.vbp) or something like SOLUTION1 ...

What is wrong with the textboxes
put one and you'll get all name listed, it looks just like label...

sorry, did not have enough time to be online and answer you soon.
But this does not look like a VB or DataBase problem it is more like WINDOWS.
If the program is not XP Style then tell us, are the...

I AM LEAVING NOW. Wish you GOOD LUCK!
;)

And REMOVE that CLOSECONN
You use your recordset, but you close the connection, that is not correct

SELECT Count(Id) FROM Table WHERE DateCreated BETWEEN #1.07.2006# AND #07.07.2006#

SELECT Name, Count(Name) as cntNames FROM tblVotes GROUP BY Name
That's it...

Yeah ;)

We need more info, where is the error, what is the error exactly

try FileCopy...
first close any connections to the .MDB then
FileCopy "Your.Mdb", "C:\BackUp\Your1.mdb"

Here is a way to return all result similar to the entered in the SearchString.
SORRY if I uploaded the wrong project before,
HERE IS THE NEW ONE NOW, take a look, I just made it.

As far as I see you need to search by more than one criteria? Is that right?
You need more that one result that replies to the SEARCH STRING entered by the user?

Here it is...
(Have in mind that when user select a line from the ComboBox then it points to exactly one line in the database, if you want all of them with having name
"Peter" for instance, that...

I'll make a new project for you, that does what you need.
Sorry I could not connect to your database, but if get the idea... you'll succeed

You have ODBS that I don't and wasn't able to test the program, but here it is...
Good luck!

I finished work, so I will see it tommorow.
Good night!

Thanks I'll remember that ! :thumb:

When you go to ADVANCED you will notice down a button "MANAGE ATTACHMENTS" you will browse then for your zip...

If it is reserved you may try brackets
sql = "SELECT cname, cimage, cid, cdirec FROM [cat]"

WHAT IS THIS?
(rst.Open) Just this?
Where did you set which connection to use or what is the source? Where are the locktypes?

rst.Open SQL,Connection, adOpen..., adLock
use this and you won't...

:'( :'( :'( I can not belive it ...

And post your code again I wanna see it all.

BUT Of cource you will :(
Do all these spets before this line
Temp$ = rst.Fields("User").Value

Dim rs as adodb.recordset
set rs = new adodb.recordset
rs.open......
if not rs.Eof then temp$ =...

And another thing I see.
You first set the DataGrid.DataSource and THEN you filter the RecordSet...
After the .FILTER
put the line

Set DataGrid.DataSource = Nothing
SET DataGrid.DataSource=...

So where is the problem and what is the question?
I don't get it? What is the result you get? You do not get the right data on the DataGrid or you get error or you need to select more than one...

Ok let's make it right.
If I understand correctly you need something like:

rst.Filter=""
rst.Filter = ("Field1<" & Date & "Field2='" & ComboBox.text & "'")
DataGrid.DataSource = Rst.DataSource

Here is code that writes to TXT file:
Public Sub WriteAll(Text As String, filename As String, _
Optional AppendMode As Boolean)
Dim fnum As Integer, isOpen As Boolean
On Error GoTo...

Great code
I bet it works without any edit :) ;)
Just kidding, because it does not give enough info.
You want to save all the data from a LISTBOX to a FILE ?

Wow that's a long one...I can not even get it all right now...
I gave just an idea that came to my mind:
stplit the string letter by letter and then swap them, but you already SO...

THAT WAS THE ONLY PROBLEM si_the_geek :(
I can not install any service pack because of this error.
Vb was working but my project not entirely without SP6.

Anyway...I wasted enough time, so I...

Let's try something:
Letter by letter we move through the string.
aaaabaaaab
First letter is "a" so we store it in a variable
(dim strCheck as string, strAll as string)
strAll = "aaaabaaaab"
...

The first thing I see is that you filter your recordset in one SUB and then you use another recordset with the same name and may you expect that it is still filtered?

If so USE declare your...