Search results

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 =...

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

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

: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...

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

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

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

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???

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

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

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:

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

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

Hi, I am having some problems with the following script: DoCmd.OutputTo acOutputReport, "PUR_PURCHASEORDER", _ acFormatSNP, "ttt1.snp", False When I execute this, the SNP file gets created but my Access gives error “MS Access has encountered a problem and needs to close” and closes. I am...