Search results for query: *

I am not sure about ZIP, but WINRAR has to modules for shell command: rar.exe(to compress) and unrar.exe(to uncompress). Both has parameters to specify where to (un)compress and many others. By my knowledge, winrar is able to (un)compress zip files.

Add first to the for TextBox2 control. Then Add the following event TextBox2 . This is going to fire when the text is changed. Same thing you can do with javascript. private void TextBox2_OnChange(object sender, System.EventArgs e) { string newval; string sval = TextBox2.Text...

I have a console application (c#) with a main report and several subreport. The application exports the crystal report in pdf files and creates 1000 pdf files. Problem: the application takes more and more memory with each report exported. I used "dispose" method for some of the objects...

I forgot: I am using Crystal Reports for Visual Studio .Net

I have a console application (c#) with a main report and several subreport. The application exports the crystal report in pdf files and creates 1000 pdf files. Problem: the application takes more and more memory with each report exported. I used "dispose" method for some of the objects...

I need some help with this problem: Can I create 2 triggers (FOR INSERT) on the same table ? If yes, which one is going to fire first ? One trigger (TR1) is validating the data and second trigger (TR2) is inserting in a log table the activity (in this case new rows). If is possible to have 2...

I was thinking about that BUT the first trigger is returning to me (to the application) some warnings, messages and errors.

I need some help with this problem: Can I create 2 triggers (FOR INSERT) on the same table ? If yes, which one is going to fire first ? One trigger (TR1) is validating the data and second trigger (TR2) is inserting in a log table the activity (in this case new rows). If is possible to have 2...

That means you have a different type of data in that column. May be text or date. I dont know. Try: SELECT Count(*) AS Cnt, GAPS.IDGAPID, GAPS.BSR FROM GAPS GROUP BY GAPS.IDGAPID, GAPS.BSR having (((GAPS.BSR)='2'))

How hard can be? Table1 its your table and: SELECT Count(*) AS Cnt, Table1.IDGAPID, Table1.BSR FROM Table1 GROUP BY Table1.IDGAPID, Table1.BSR having (((Table1.BSR)=2)) Success

Lets say Table1 is your table: SELECT Table1.*, Table1_1.* FROM Table1, Table1 AS Table1_1 WHERE (((Table1.Description)='File 1') AND ((Table1_1.Description)='File 2')); the result is going to look like this 1234 1234i1.doc File1 1234i2.doc File2 4321 4321i1.doc File1 4321i2.doc File2

Create first a view for each file (file1, ...fileN) and then create an select from all views. Something like this: (table1 is the same tbale with table1_1) SELECT Table1.*, Table1_1.*, Table1.id, Table1_1.id FROM Table1, Table1 AS Table1_1 WHERE (((Table1.id)=1) AND ((Table1_1.id)=2));

Try this one: SELECT Count(*) AS Expr1, Table1.id, Min(Table1.bsr) AS MinOfbsr FROM Table1 GROUP BY Table1.id; Success

Combo3.RowSourceType = "Table/Query" cmbBox1.RowSource = "SELECT name FROM table" or Combo3.RowSourceType = "Value List" Combo3.RowSource = "1;2;3;4" Success

This is much better. Thank you.

That seems to be the only solution. I will use Split function whith "." as delimiter. Do you know something else better to chop the last chars.?

You can open the file, read the file first in a string var and then txtBox.Value = stringVarFrom File You can access the file using FileSystemObject. Success.

Nope. Is not working. type mismatch -> error

I have a time format like : hh:mm:ss.ms where ms are milliseconds. I wand to run a DateAdd(IntervalType, Number, FirstDate) where first date is like : mm/dd/yy hh:mm:ss.ms and I receive type mismatch error. How to convert time into hh:mm:ss, so no milliseconds to make this work. All it is a VBA...

You can try something like this: Private Sub Command6_Click() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentData ' Search for open AccessObject objects in AllTables 'collection. For Each obj In dbs.AllTables ' Print name of obj...