Search results

Whatever section the OLE photo is in, click on the section bar and then, the Event Tab. There is an OnFormat property there where you can assign a function or macro to run as the section is formatted. In this case, you would assign a macro with a Condition that if the title is "master" then...

Setting the Access issues aside for a moment... In plain English, how do *you* know which subform items go with any particular item in the main form? What is the logical connector between a main record and the subform record(s)? There must be some "connector" even for the human eye to match...

I hope I'm understanding you correctly... when I do this kind of thing, I base the subform contents on an underlying query with criteria from the main form, or in your case, the first subform. I would assign a code to each of the Sections you mention in the first form, and then using the same...

I am building a "rolling slideshow" to be displayed on a big screen television. The show includes a number of graphs, freshened systemically at a timed interval and exported as GIF's. The GIFs are displayed via an unbound graphic object on the "stage" form, fed by a table of records containing...

My application sends "Route For Review" emails using the SendObject command in a macro. The macro works just fine, and the SendObject works as expected, except... for the text plugged into the body of the email, which is fed from an UNBOUND field in the database: Message: ="Rationale: "&...

Two other points: Use the same macro to go ahead and call the report after the queries have finished. Second, as a matter of housekeeping, you might finish the macro by including a DeleteObject call that wipes out the temporary table used by the report. This step is not absolutely necessary...

Sure, if I understand what you're asking, this is not difficult. Build your macro with OpenQuery statements, first calling the one that does the MakeTable task, then each of the append queries in proper turn. In effect, the macro just does what you already know how to do manually, but much...

Wow... Awesome! I'll give it a whirl today! Many thanks for taking the time to reply SLH

RE: Animated GIF's On Forms I was kinda afraid that would be the case. Thanks for your reply. Anybody know where the "wish list" is at Microsoft for future enhancements???? Slh

Didn't see this one when I browsed the existing threads... Is there a way to include animated GIF files in an MS-Access form? I've used tons of static images on forms in the past, but never tried an animated image until now. Hopefully it's obvious and I am just having a mental moment! Many...

RE: Redirect Table Target/Editing MSSysObject No, no ideas from the board, and I had to move on to other projects but will be revisiting this sometime soon. If I learn the answer, I'll post it for you and others. -SLH

I have an application that works with our SQL-based collections package. In the SQL tables is a personal history table for each individual user that logs each account looked up w/date and time, etc. In my Access app, I want each user to be linked to his own personal table so that the app can...

About Apprentice Timed Events Utility Jim, I have done a quick-and-dirty page on how my utility works. Hope it helps. Attachment is in .pdf format.

Re: Does This Help? Unfortuantely, no. This link looks to me to focus on Microsoft Excel and the Chart Wizard in Excel. I am using the wizard in MS-Access (MS-Graph), so cell ranges and named ranges, et al wouldn't apply. Where I run into trouble is when the wizard asks me to name the fields...

I am working on a graph on a form that requires 10 plot points (Bar Graph). This morning I was surprised to learn that MS-Graph has a limit of six plot points????? Sheesh! Am I missing something, or is this limitation for real? Any suggestions on how to get around such a limit? Thanks, shuff

Micro$oft Charges The charge was $245 US. Pricey, but they bent over backwards with followup calls, a second session with the rep, et al.

The Answer! I broke down and paid for an incident at Micro$oft. The solution was to convert the macro to Visusal Basic, then call it from an Event Procedure. For whatever reason, Access Runtime would not accept the setvalue from an ordinary macro, but it worked just fine as an Event Procedure...

I have a macro that fires from the OnActivate property of a form. The first line "initializes" a checkbox by doing a SetValue=0 before making a series of tests to turn it back on if applicable. I should add that the checkbox is unbound - it's simply used for decisioning on the form while it's...

What a perfect example of not seeing the forest for the trees! I'll try this this afternoon but I'll bet it works just fine. Many thanks, SLH

Could you be a bit more specific about context? Does the range of dates somehow interact with whatever member number(s) get entered, e.g. showing records for these members between these dates? Practically speaking, how many member numbers would typically get entered? Would they get entered at...