Recent content by Prodriguez

Thank you very much for the response. I managed to sort this out following your advice. Regards, Pablo

Hi all, I was working on a form (Capture 1), and after selecting the Property Sheet of one of the fields, I got a very weird view of the Property Sheet, which I cannot change now (Capture 2). I cannot see all the rows and columns. I appreciate your help. With regards, Pablo

Dear Eugene-LS, Thank you for the two responses submitted under this thread. The code provided has become very useful to my current project. Thanks for quick turn around. With regards PAR

Dear JHB, Thank you for this prompt response it is exactly what I was looking for. It was very helpful PAR

Thanks JHB for your prompt reply but I was looking to find a solution using VBA, if possible. With regards PAR

Dear all, I have attached an example of a database that has an invoice form linked to a invoice line sub-form. Once the amount is updated in the invoice line the tax amount is calculated by multiplying the amount with the tax rate in the combo box of the parent form. So this works very well...

Dear arnelgp, Thanks for your prompt response. This is exactly what I was looking for. Thank you

Hi, The attached database example has two tables (tbl_Documents and tbl_RepPeriod) and a form that is being used to populate this information. The form (TestForm) has a combo box that lists "Active" reporting periods that the user can select from to assign to each of the records from the...

Hi sxschech, Thanks for your reply. These are the steps I need to perform in the VBA: 1) Select one or several files from one location A and copy them to a location B. 2) Save location B into a table as a hyperlink that can be clicked when required. 3) The files are of different formats. 4)...

Dear sxschech, the description of your code capabilities describes exactly what i need to with my form. Would you be able to share that code? Thanks

Hi all, I am using a macro to import an Excel spreadsheet into a temporary table. When I run the macro it asks me the location of the file and in which table I want to load the data. How can I configure the arguments in the macro set up to establish the location of the file and the table by...