Search results

Hi Pantera, I'm not familiar with the video you mention, but I believe it could be incorrect depending upon how the information was presented. We actually made a late change to the product in this specific area of data macros during the Beta phases. It's very possible that Lynda was using an...

Hi, See this page on my site: http://accessjunkie.com/faq2010_05.aspx -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office Access 2007 Inside Out Access...

Hi, Thanks for the version number, that's very helpful. If you're using Access 2010, designing macros in the new Logic Designer is way easier than previous versions. As you've already commented, you can use the new If/Else/Else If constructs right inside the macro logic. This is very helpful...

Hi, Could you please let us know which version of Access you are using? That will definitely help people replying to your question. To answer your original question, yes you can certainly display a Yes/No message box from a macro and then take different action on what button is clicked. In...

Hi, Sure, you can easily do that in Access 2007. Add this one line of VBA code to the control's On Got Focus event: DoCmd.RunCommand acCmdShowDatePicker When you tab into or click into the control, the built-in date picker will display. -------------------- Jeff Conrad - Access Junkie - MVP...

Hi Chuck, Thanks for the additional information. If you're using Access 2010, which it sounds like you are, instead of using the non trusted SetValue macro action, use the trusted SetProperty macro action instead. You won't have to worry about running this in an untrusted environment. In...

Hi Chuck, Unfortunately, I don't think this is possible. Whenever you come into the macro design surface, the Show All Actions button won't be selected. Let me ask a follow-up question. Which "unsafe" macro actions are you typically using? Perhaps understanding your scenarios will help us to...

Hi Chuck, Thanks for the information. The repro steps I provide will reproduce the issue 100% of the time so that's definitely something other people might fall into. I've created a new FAQ page on my site to help people that come across this issue: http://accessjunkie.com/faq2010_73.aspx I'm...

Hi Chuck, Thanks for checking back. While waiting, I asked around the team and did some testing. I can repro your issue now and I understand the cause and fix. The issue is most likely you are using a MDB file and you had the following option disabled in the Options dialog: Allow Built-In...

Hi Chuck, This is very odd indeed. Is there any chance you could attach a copy of this database that repros the issue? You could probably just make a copy of the ACCDB and delete all objects except maybe one macro to protect any proprietary data/objects. I'd like to see if I can see the same...

Great, I'm glad you have it working now. Thanks for posting back; good luck with your project. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office Access 2007...

Could you provide a little more clarification on "it did not work"? What exactly happened? Did you get an error message? If so, what was the message? If you used the temporary variable as the default value of the control, what do you see? Your ID number, #Ref!, #Error?, something else? Does it...

Hi, I have a FAQ page on my site that has lots of information concerning Access 2010. It won't answer all questions of course, but it should prove useful in your study of Access 2010. You can find my page here: http://www.AccessJunkie.com/faq2010.aspx Back to your question. Temporary variables...

That's great Emily, I'm glad to hear your issue is resolved. Good luck with your study of Access 2010. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office...

Hi, If you're using unbound forms, you'll have to use named data macros to "push" new records into tables. If you're using bound forms, you can just assign the temporary variable to a control on the form that is bound to one of your fields. You won't have to create a named data macro then. A...

Hi Emily, If your existing database is a .mdb file with the 2000 or 2002-2003 format, you cannot create data macros on those tables. You can only create data macros on your tables if the database is using the .accdb file format. MDB files cannot understand data macros so those options are...

Hi Emily, Is this a local Access table or a linked Access table? If it's a linked table, that's why the options are grayed out. You can only create data macros on local tables. To create them on the linked tables, you'll need to open the source database file that contains the actual tables...

Hi, You're correct that you cannot reference/use TempVars in the data macro context. You can add a parameter to the named data macro and then pass in the value of the TempVar to the named data macro when you call the RunDataMacro UI macro action. You can then use that parameter value (which...

Hi Stacy, The Documenter doesn't have a built-in way to do this. You might give my free CSD Tools Add-in a try for this. For most of the reports, you can just click the Word button to output the database reports to Word. You can then modify to your heart's content. You can find my add-in...

Hi Carey, Thanks for pointing this issue out. The article is indeed missing the End Function line in the sample. I discussed this with our Help content people and they have already corrected the issue. The new article will be published soon. Thanks for the feedback. -------------------- Jeff...