Search results

Hello, i'd very much appreciate it if someone can tell me how to write an error handling line that will rerun the current public sub or function from the start upon error... thanks!!

Hi, I've got a basic question... On a report i'm building i want to refer to a particular cell in a query, Let's say the query name is qry1 and I want to refer to the 3rd column and 2nd row. What should the code look like? I'm also coding the same stuff in VBA, i found this 'Dlookup' function...

Hi, does anyone know what is the Access version of excel function PV and Rate functions? In excel the PV function has the following syntax: PV( interest_rate, number_payments, payment, FV, Type ) and here's the syntax for Rate function: Rate( number_payments, payment, PV, FV, Type, Estimate )...

Hello, I've asked this question in anther thread but here's it again since I'm still confused. What's the proper command to modify control source of textboxes in existing reports? I'm will be running a loop modifying these textbox control sources in existing reports so i will be assigning...

Hello, Itd be much appreciated if someone could let me know what is the proper way to create report based an existing template, rename it and then save it. I'm also looking for ways to replace the source in the generated report to another name using VBA.... is it possible? Thanks so much!

I've been using this Chr(34) to replace quotations in my quotes and they've been working well in VBA for excel. Now i've migrated the same code to VBA in Access and it's giving me complie error with this message: Can't find object or library. :mad: Do I have to add any additional reference when...

I'm trying to compile the below code, however something seems wrong and I can't tell what... can some one tell me whats wrong? The error I'm receiving is "end of statement error". Update: sqlqry points to a sql code here, which is copied from an Access query and the code itself runs fine in...

I would really appreciate it if anyone could help me with the below task. I have some experience in VBA but very little with Access. The challenge I face right now is to use an index of names (in excel field) to repeatedly create reports and queries with each of these names. The reports and...