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 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 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));
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.
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...
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.