Search results

Dear All, I fond the below VBA on the internet and this is perfect to control the date range by using the form (textbox) to generate the report. My question is: 1. How can I use this to export the Query or Table by using this VBA? 2. This VBA only lookup for two textbox for the date...

Dear All, I am the new in VBA. Below VBA use to filter the Query or Table by using the FORM with the combobox, it's fine until I changed to open (Append Query), the below error message coming up. ( Then action or method is invalid because the form or report isn't bound to a table or...

Dear All, Please help ! Form A Form Main Manual Report A Form A (field "seal no") or Table A (field "seal no") I want to crate the the button in (Form Main manual) to : 1. If folder name (using the data by "Seal no") not exist, Create it. 2. Save the "Report A" into the...

I need help to crate the vba as below: query name : qrycost field in query : sccd report name: 1. rptcosthkg_a / 2. rptcosthkg_b / 3. rptcostszp_a / 4. rptcostszp_b if sccd like "HKG" then open report 1. rptcosthkg_a else open report 2. rptosthkg_b if sccd like "SZP" then...

Der all, Need help for the query return the grouped data and append to another table. we need to prevent the user import more then one times. Query around 15 field, so it's no way to use the Primery or Index to prevent record duplication. Beside the group data return it's also have no...

Dear all, I did the excel file import to access table. one of the field contain the symbol like "/", import is ok but when I use query to filter in this field and found, system can not recognize it. when I clear it and retype on it, system can be recognize it. so what is the problem on...

Dear all, Field "A" is the drop list to select data like (Yes, No) Field "B" is inactive but turn it to active when the field "A" is select to "Yes". Please help with thanks. Regards Tom

Dears File import with special heading ABC. or 123. First time the file import, system will ignor the "full stop" into the table. but next time when I try to import to update the table, system error can not identify the heading. Anyone can help? Regards Tom

Hi, I am the junior of the ms access. I try to convert the below text to date (03/08/2015 19:42) (31/07/2015 12:20) CDate([XXXX]) reture 3/8/2015 7:42:00 PM (should be 03Aug2015) reture 7/31/2015 12:20:00 PM (should be 31Jul2015) anyone can help, please. Tom