Search results

Thanks, that does the trick... Here's another problem, is there a way that i can automatically click on the "End" bottom when the debugger message pops up??

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

worked it out using another query and a subreport... Thanks anyways! :)

Oh ok, for now i'm testing it in VBA. so my code looks like this: Dim Strg1 as String Strg1 = DLookup("[Column1]", "qry1", "[Column0]=10") and I check variable Strg1's value so I know if this Dlookup is working. Ultimately, I'm trying to display this date in the query on a report... Thanks...

Got an error of '2001' and "You canceled the previous operation" message... =(

Coming back to the basics, what if I just want pass on the date value from Column1 on to a report, how would I do that?

Thanks for the detailed explanation, I'm probably not quite familiar enough with access.... After multiple failed attempts, i'm posting the a screen shot of the query here. This is what i'm trying and still failed.... DLookup("[Column1]", "[Queries]![qry1]", "[Column0]=10") What would the...

Thanks for the link, what would I use as "Criteria = n" in this case? If I want the 1st row, 2nd column cell value? The query name is [qry1].. thank you Edit: Just saw the 2nd reply, I'll give it a try and post back. 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...

Gotcha, works just as I wanted!

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

Thanks so much, here's the solution, the 1st line should be DoCmd.OpenReport rptName acViewDesign Then everything works! :D

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

Edit: problem solved, need to add docmd.close acreport..... So here's the new problem, how do I edit the property of a textbox in the report? Such that I need to edit the recordsource of the textbox in the report..... Here's another question, I've seen many places online where the code looks...

That's a helpful link, thanks. :) Yes, basically replicating an existing report with different names. What is the proper vba commands in access for this to happen?

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 agree, I have checked references in both vba in excel and in access and they carry the same references..... I'll be sure to look into it and report back when I get to the bottom of this. :)

Thanks I actually found a solution, not sure what caused it but I swapped out chr(34) with """" (4 quotation marks) and it worked. thanks anyways! :D

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 see what you mean here. I'm interested in getting & " True, "M", "") as the result, I saw somewhere online that the quotation symbol should be replaced with & chr(34) & ?