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
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...
From "My Computer" select View>Options from the menu
Select "File Types"
Scroll down to find MS Excel Worksheet (extension = xls)
Select EDIT
Select the OPEN action and EDIT
You should have something like
"C:\Program Files\Microsoft Office\Office\excel.exe"...
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
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 "cant find project or library", folowed by the reference "Microsoft Calendar Control 8.0" beung highlighted.
If I create a new project then there is no problem.
Any hints as to...
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
I have a field ThisAmount defined as Double
Using the following code:
ThisAmount=4747.69
ThisAmount=ThisAmount * 100
ThisAmount=INT(ThisAmount)
ThisAmount=ThisAmount/100
The INT function converts the value of 474769 to 474768
WHY ?????
Paul McEwan
For some reason Windows ME is no longer creating automatic restore points and whenever I try to set a manual restore point the system say I must reboot (even after reboot).
What have I changed, and how can I get it to woork again
Paul
I do not have an official list, but I tend to install the following files to c:\winnt\crystal when ever I roll out an application<br>
<br>
Volume in drive C has no label.<br>
Volume Serial Number is 48A1-AD77<br>
<br>
Directory of c:\winnt\crystal<br>
<br>
04/01/00 01:06p <DIR>...
We have just had an internal mail about a "fancy display called elfbow.exe" . Note NOEL. This file was infected with a virus, but it was detected and fixed.<br>
<br>
I dont know if this a spelling mistake or if there really is another exe out there with a similar name<br>
<br>
<br>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.