Recent content by sparrow

I have an Access 97 database that has suddenly come up with the above error. The repair utility will not work becuase there is no index 1. How has this happened ? 2. Can it be fixed Thanks in advance Paul

I remeber a small program called SNOW that did this, I found it on the internet, but I can not rember where. Try searching ENCRYPT SNOW Paul

Try This Set OL = GetObject(, "Outlook.Application") Set OL_Mail = OL.CreateItem(0) OL_Mail.Attachments.Add (filename) Paul

It is not clear if you mean that the user starts a second instance of your VB Program, or a second instance of MQ Series. However. This is the code I have in the MAIN module that starts when my users try to run my VB Executable Dim SaveTitle As String On Error GoTo handler If App.PrevInstance...

How about QueryOne Select Salary, Date from Table Where Date < *Date QueryTwo Select Salary, max(Date) from QueryOne Paul

From &quot;My Computer&quot; select View>Options from the menu Select &quot;File Types&quot; Scroll down to find MS Excel Worksheet (extension = xls) Select EDIT Select the OPEN action and EDIT You should have something like &quot;C:\Program Files\Microsoft Office\Office\excel.exe&quot...

Try changing the field type to MEMO Paul

I normally use .RecordCount for my recordsets. What I have found is When I open the record set RecordCount = 0 or 1 If it is 1 then MoveLast resets RecordCount the the number of recordss in the record set Hope this is helpful Paul

What about If Adodc1.Recordset.NOMATCH Then This is checing for a matching record rather than end of file Paul

In our office we are using Access 97 connecting to Sybase 10 ODBC. If I create a new database and connect to tables and run a query then each returned record is exactly the same. It seems to return the first record found in the database as the result for each record that should be returned. If...

I have just started amending an old project, but when I try to run it I get the error message &quot;cant find project or library&quot;, folowed by the reference &quot;Microsoft Calendar Control 8.0&quot; beung highlighted. If I create a new project then there is no problem. Any hints as to...

I think it might have been moved under ACCESSORIES Paul

How about Import the text file to a Temp table. Run an Update query against the Temp table and Update the Price in the Product table Paul

Simon I am using VB5, this function is not available Paul

Simon This is part of a financial program allocationg invoice amounts by percentage. Because a percenatage of an amount can have many decimal places I am trying to ensure that the value is set to only 2 decimal places. Paul