Search results for query: *

Hi, I have got a program which dynamicaly compiles a vb-file when it is being executed, this allows me to alter the code in the vb-file without altering the executable. So far so good, I did manage to create this using CompileAssemblyFromSource(). The problem I have is the following.... From...

Hi, I have the following problem.... I want to print some image on a sheet of A4 paper, my printer is capable of a much higher resolution than de default resolution of A4 paper in Visual Basic. How can I change this....??? Example: Standard size for A4 in Visual Basic = 780 * 1130 My...

How do I retrieve the name of the current package from within a script task ?? Grtz, Kalin

Hi all, I have a SQL-Server database (size +/-5 GB) which filled up completely, to my suprise because this database had unlimited filegrowth enabled and the disk wasn't full. After creating a second datafile the database continued to operate normally. Any thoughs on what may have caused this...

Hi, in a db I have I have a view which is a pivottable made from a table in this db. I need to export this data to Excel on a regular basis, so I want to create a DTS package to refresh the view (drop and recreate) and then export it to Excel. Since the view is a pivot of one of the tables the...

Hi, I've got a dataviewmanager through which I filter some data in a dataset (multiple tables parent-child). So far so good. When I retrieve the data in a datagrid I get precisely the data I need but how can I retrieve this data programmaticaly ?? Thus step through the filtered dataset ...

Hi, I want to import a CSV-file into SQL-Server. The column headers for the columns are on the first line. The file contains approx. 500000 records. So far no problem.... But the columns can vary both in amount and composition. So I need to dynamicly create a table based on the file and the...

Hi all, I'm creating a function, it works when I remove the last or second last else if statement. But fails (Incorrect syntax near the keyword 'ELSE' on line 14) when I include both. Source: Alter Function fn_SwapRuimte (@LijnID nvarchar(20)) RETURNS @fn_SwapRuimte table (Origin...

Hi all, I'm trying to install both the Oracle 9i client and Forms 6i runtime on one client PC. The install works like a charm, but I want both clients to use only one Oracle home. This to prevent any switching between homes during runtime. Is this possible and if so how ??? Grtz, Kalin

Hi All, currently I'm developing a single statement for looking up the status of the different databases in an instance. The script runs OK but stumbles on the case statement. Does anyone have a resolution for this ?? Greetz, Kalin Use Master Declare @DatabaseName Varchar(50) Declare @SQL...

Hi All, I've created a Access 97 db and converted it to Access 2000. After the conversion functions like space$ and left don't seem to work anymore. Both do appear in the help file of both versions and with the same syntax...... Anyone got a clue how to solve this problem ??? Grtz, Kalin

Hi All, I've build a function but for some reason I can't get it to work. The function does compile but it seems like there is a problem with the declaration of 'weekday'. Can anyone help me ?? For ease of reading I translated the function and types to English. So any typos can be ignored...

Hi all, I have the following problem. How do I access the properties of a control on a specific record ? If I set the properties on a control from code it sets the properties for this control on all records, what I want is to set it just on one record. The application is in Access 97. Grtz...

Hi All, I'm having a problem with an ODBC-call from Access 97 to Oracle 8.0.4. The problem: The field types in Oracle are defined as NUMBER(17,2) if these are retrieved by Access they seem to be 'transformed' to TEXT fields. Does anyone know what causes this and how to solve this ?? Grtz...

Hi, where can I adjust the ODBC timeout for an ODBC-connection with Oracle ?? Grtz, Kalin

Hi, I'm looking for a way to calculate the date and year of last month which i need in a variable. I'm using digital Unix and a Korn Shell. Greetz, Grtz, Kalin

Hi all, I got a string. This string is the name of a Constant. Now I want to convert this string to the value of the constant. Does anyone know how to accomplish this ?? Already tried Eval("string") but it doesn't work. Grtz, Kalin

Does anybody know is the following is possible in Access ?? If so what is the correct syntax ?? SELECT column FROM (SELECT column FROM table) AS alias;

Does anybody know is the following is possible in Access ?? If so what is the correct syntax ?? SELECT column FROM (SELECT column FROM table) AS alias;

Does anybody have a clue as how to detect if a form in non-entry mode (AllowAdditions = False) has any records upon opening. Grtz, Kalin