Search results for query: *

Sub loadForm() oktoGo = False formQuestion.Show End Sub 'loadForm which is turn calls Private Sub UserForm_Initialize() On Error GoTo ErrHandler globalFunctName = "UserForm_Initialize" spinQuestionValue.Value = 1 textQuestionValue = spinQuestionValue...

Ken What I do is close my orginal file MyExcelFile.xls which is on the server. I then copy and paste it into Temp on my local directory as either MyExcelFile.xls or copy_MyExcelFile.xls. So the orginal still exists on the server but is definitely closed. To get the errors, what I do is click...

I am in need of some help with Microsoft Excel 2002 (SP3). I have created a spreadsheet with Macros and VBA behind it to do various data manipulations. Only limited data is actually stored so Excel was chosen as the approriate application for this work. Anyway, it all works super fine until I...

You might need to look at what other processes you have running on other apps at the same time. It could be that the 2 processes are using the same libraries. It is hard to imagine why it would happen so (aparently) randomly otherwise. Snowcrash

Or in your query you could write SELECT * FROM TableA ORDER BY CAST(StringCol AS Integer) Although if numbers are all you are going to be storing in this field, then datatype of number it should be.

SELECT TOP 20 * FROM Table_A should work fine. Snowcrash

Hey SELECT * FROM Delete_Table WHERE TableValue LIKE "a?a" Returns only records that HAVE values that start with a and have a third letter of a. SELECT * FROM Delete_Table WHERE TableValue LIKE "a*a" Returns records the same records above but also records like "aa" which have no values in...

You are wanting a loop within a SQL query and transactional SQL does not cope with that. You could easily write a function to manage this or you could do get the result by playing dirty eg create a new table, countTable, with a single field countID populated with 15 fields starting at 0 up to...

Hey This error "run time error 3061, Too few parameters. Expected 2" indicates that a field in your query (and in this case 2) do not match the fields in your table. Output the table name before you run the query to make sure you are passing the correct name and then output the query string...

ISNULL:- The ISNULL Function replaces NULL with the specified replacement value and is like an If Then function. It takes 2 arguments: the first is the field which you are testing and the second is the value you wish to replace the NULL with if encountered. So the statement SELECT CountryID...

Further to the above post, I downloaded the files onto my other computer that has XP on it. The 9i install files work on both NT and XP. I ran the install process on the XP box and it ran without error (well up to a point as I didn't want to actually install it on XP but I did get the Oracle...

Hey Thanks for that although it has not helped. I was using another zip product so I downloaded winZip. I did as you suggested and checked the Use Folder Names option and extracted to each Disk(n). In Disk 1 there are, amongst other folders, a Stage and Install folder but not an ImportSpecs...

Ok, now first off I am a total database installation novice. I am required to install Oracle 9i onto an old NT configured thus: a small partition with NT loaded and a second large partition (E:\). Downloaded all 3 Oracle.zip files and unzipped as directed to 3 folders on E drive. All is well...

You need to post your code as it will likely be something that occurs prior to this statement.

It is possible to to update recordsets although there are the following restrictions. The recordset cannot be based on (from MS Help): A query based on a many-to-many join. A query based on data marked as read-only in the database. A query that violates constraints on the base tables. A...

My first suggestion would be to make the function public rather than private.

I believe you will need to use a subquery for this eg: DELETE FROM SLALLO WHERE SLALLO.columnname = (or IN if many will be returned by the following) ( SELECT MBADREP.columname FROM MBADREP (which is the same datatype as SLALLO.columnname) WHERE ADAKDT > 1040731 AND ADUUQ1 > 0...

The following code although compiles without error, does not expand the nav tree to show the newly inserted node. What am I doing wrong here? VCmpNavTreeNode savedNode = curHandler.requestSaveNavTreeNode( treeNode ); // Check that the returned node has been properly saved by // checking...

The doco you get with the driver is only very minimal. No where does it tell you how to form an connection string. It only offers advice through wizard interfaces on how to connect to general apps (Word, Excell etc). And to contact MYOB for any assistance costs more money than I have. Not to...

I have a large Java application that connections to any number and type of database. I have it successfully connecting to Access, MySQL, SQL Server etc but cannot get this to work with MYOB. I have purhcased the MYOB driver but believe it is the syntax that I am using in either the driver or...