Search results

More I've added the control to the form but how do I get the dialog box to open In VB its dlgbox.showopen but I don't have the show open option in access 97.

I'm trying to display the contents of a directory( as windows does) when a button is clicked. Any one help?

reply Got it it was the ' around the field. It was turning it into a string and not leaving it numeric.

I have the code below in a routine Dim dBase As Database Dim rsSet As Recordset Dim count As Integer Dim SQL As String Dim jobSQL As Currency Dim rsJob As Recordset Set dBase = CurrentDb SQL = "SELECT count(recordid) FROM tblHistory WHERE tblhistory![recordid] = '" _ &...

The sql I currently have is ("SELECT count(recordid) FROM tblHistory WHERE tblhistory![recordid] = '" & Forms!frmMain.Form!ID & "'") As well as recordid = form id I want to say "and tblhistory[history type]="complaint"

need a bit more help How do I add another criteria to the end of the SQL statement ie current statement with "[recordid]="complaint" cheers

Sorted. When I copied your code it copied an extra space so it would have been looking for space(fieldname) and therefore wouldn't find anything. Works fine when I remove the space. Thanks for your help.

Tried it ie movelast and I get no current record so I can presume that the recordset is empty. Anything else I can try.?

Tried it using the second one you gave it runs with no errors but I always get 0 in the recordset count when there are matches in the table.

Had notification that this has been replied to by jimbob but when I look theres no reply been entered. Help!

I've tried the above and all I get is "missing )" error.

want to return a record set using the statement below. Set rsSet = dBase.OpenRecordset("SELECT * FROM tblhistory _ WHERE "[recordid] =" & [form]![frmmain.id]) Any Idea

tried to inset one as a picture. It inserts the picture but no animation. Surely there must be a way to do it.

Is it possible to use animated gifs on Access forms. If so how?

Using a query and a module how can I remove certain words from a string

AM using ADO but can't find a command to create table. I've also tried MS Knowledge base

How can I create an access table using purely vb6. I want the user to be able to specify how many columns the table will be in the vb app I also need to be able to sort an existing table in the access database by a certain column. 2 questions in one. Any ideas?

No. The version number sits within a VB6 project as a properties value. I don't now the command to get hold of these properties, if its possible.

When you compile a vb projext and have the auto increment switched on for the version number. Is there any way to display the version number on a form without changing a label on the form every time?

Is there a way to find the first space from the right hand side of a string ie finding the surname out of a name string?