Search results

  1. V

    Zip/Unzip via VBA

    I agree that Winzip has this argument. But I dont want to install it in all my remote machines which are operating at different far-off sites. That's why I chose this DLL. In WinXP, if you select some files and right-click, you will see Send To - Compressed Folder. After the Compr.folder is...
  2. V

    Zip/Unzip via VBA

    Hi everyone, I have XZIP.DLL which is registered in my machine. I use this to compress & extract files into a specific folder. It's working fine. But I am not able to add a Password to the Zip file. This is the code I am using presently: Dim cp As XZip.Zip '** Archive files Set cp =...
  3. V

    Attaching files of different types to table field thru VBA

    Hi Everyone, I have a PO table. Each PO has 3 documents of multiple types (one may be Word, other may be Excel, Acrobat). When I display the PO, the attachments should be shown as Icons, which when double-clicked, will open in its own Application. I have a pop-up screen where I enter new PO...
  4. V

    Attaching files of different types to table field thru VBA

    Hi Everyone, I have a PO table. Each PO has 3 documents of multiple types (one may be Word, other may be Excel, Acrobat). When I display the PO, the attachments should be shown as Icons, which when double-clicked, will open in its own Application. I have a pop-up screen where I enter new PO...
  5. V

    Hijri Date Problem Again?

    :confused: I had posted this in an earlier Thread, but since the response did not solve my problem, I am posting this as a new thread. Here is my actual scenario: I have a DB with some tables. One of them is "Documents" in which I have the following fields: Doccode, Docnum, isdt_g, exdt_g...
  6. V

    Convert Date to Hijri (ArabicCalendar)

    How to convert it vice versa? If I have an Arabic Date and I want to convert it to Gregorian, this function doesn't work. Any suggestions???
  7. V

    Convert Date to Hijri (ArabicCalendar)

    Does anyone have any function to convert a date to Hijri (Arabic Calendar)? I don't want to enable the Tools-Options-Use Hijri Calendar checkbox because all dates would thenceforth become Arabic. I don't want that. I have a date Textbox "mdate" which I would convert to Hijri...
  8. V

    Sub-Form pointer problem

    I have 2 tables: EMPMAST (3 fields: empid, empname, emppost) & PAYTRX (3 fields: empid, benfcode, amnt) I made a Mainfrm in which I display all records from EMPMAST (irrespective of whether they have any record in PAYTRX or not). In the subFrm, I display all records from PAYTRX and have linked...
  9. V

    How to Load a Form into Memory without showing it?

    Some more help Opening the Form creates some problems. Because I have some script written in the Form_Open() Event which gives error when opened. I have some Main Forms and some Forms for Data Entry. For eg., frmmain1, & frmmain1_entry, frmmain2 & frmmain2_entry. The "_entry" forms are called...
  10. V

    How to Load a Form into Memory without showing it?

    How can I Load a Form into Memory without showing it? I have a DB with some Forms. None of them are open. I want to check some properties of each form without actually opening them. How can I do this. Probably by loading it. Can anybody tell me how to use the LOAD command to load the Form?:o
  11. V

    Chek Properties of Closed Forms

    What if the Form isn't loaded? Thanks mhartman. But my question was different. I need to check the properties of Forms (in a totally different DB) that are not open at all - which means I have to Load them 1st, isn't it???:(
  12. V

    Chek Properties of Closed Forms

    I have a remote DB with some Forms. Some forms have commandButtons in them, and some don't. I have a Table called "test" in my current DB. I need to look for command buttons in each Form, and populate their names into my "test" table. Is it possible???
  13. V

    How to find the author of a TXT File?

    I have a TXT file in a folder (C:\temp\tfile.txt) I have the file's Title property set to 'Log file' and Author property as 'John' How can I get these property values into my variables var1 & var2
  14. V

    Add new field to Recordset

    I have a Suppliers table with 3 fields (code,name,addr). I have a Form where I need to list all records in this table + a checkbox against each record on which the user will tick for only some suppliers he wishes to select. How can I do this without this?? I dont want to create a table just...
  15. V

    Can Anybody Help Me Out ???

    Open a Form and go to its properties - "Other" - You will find the Tag property. Caps off !!
  16. V

    Can Anybody Help Me Out ???

    Populating Listbox THANKS PAT. TO GO JUST A BIT FURTHER, WHAT SHOULD I DO IF I NEED THE "TAG" PROPERTY (NOT THE NAMES) OF THESE FORMS TO BE POPULATED INTO THE LISTBOX? IS THERE A WAY OUT??:o
  17. V

    Can Anybody Help Me Out ???

    I HAVE A DB WITH SOME FORMS. I WANT TO POPULATE A COMBOBOX WITH THE NAMES OF THESE FORMS. HOW CAN I DO IT??:confused:
  18. V

    How to check Property of a Closed Form

    I have a DB with 20 forms. All of the forms are closed. I opened a new form and added a button. I would like to do the following when the button is clicked: Check the "Tag" property of each form and count whichever is not null. Can anybody help me out??::o
  19. V

    Selecting limited rows

    Thanks a bunch, Jeroen. It works perfect.
  20. V

    Selecting limited rows

    I have a table containing items and their prices. I need to run a SELECT Query which can return the last 5 prices for each item. My Query is: SELECT item, podate, price FROM PurchaseOrders GROUP BY item, podate, price ORDER BY item, podate DESC, price Let's say my Item A001 returned 12...
Top Bottom