Search results for query: *

I have a form in Access 2000 with an unbound field that I want set to the current date any time specific fields in this form get modified (not if any part of the form is modified, only if those fields are). I created a macro that is tied to the "After Update" events of these fields. The macro...

Thanks, Geoff - that certainly does work. I can match up "Pivot Table 8" by looking at all pivot tables and finding the one that matches that name. I am disappointed there isn't an easier way. I was hoping for a reference to the sheet tab name and a range of data - which is what I see when I use...

Since I am not a programmer, I have no idea what this code will do - other than a message box is supposed to display with info in it. I copied & pasted it into the VBA window, but nothing seems to happen. Can you explain this so I am using it correctly? Thanks!

Yes - I know - but how do I find out which pivot table is the source for the chart? There are 80 sheets and all the charts are together and all the pivot tables are together and all the source data is together. I can't assume by location that a chart is "next to" the pivot table it's based on.

I have inherited a workbook with pivot tables & charts. I can find the data source for the tables with no problem but how do I find out the source for the pivot charts? There is no way to run the wizard and go backwards as with the pivot table. The only time I ever saw reference to a pivot...

Never mind - I figured it out. THANK YOU!!!! It's working - YES!!!

I can feel the answer getting close. I am missing something though - what is the "Self_Related_Compound::c_CurrectRecID" in the field options for the Flag Duplicates field??? I created all the fields (except the phase and project) just as you had them - copied and pasted exactly what you had -...

Tried to connect to the http://mostarnet.com/temp/tallbarb_dups.zip site. No success. I was thinking the "warning" method would actually be best anyway. I'd like to give it a try....

Will duplicating a record be possible if the first suggestion is used where it prevents entry of duplicates rather than warns? In our current situation, we use an existing record to create a new record of the same type (in a registration database where we set up classes - same class, different...

I'm still not sure I have explained this correctly. Here's an example: Project Number Phase Number Duplicate? END001 01 NO END002 01 NO END001 02 NO END002 02...

I am a new FM user. What I want to do is prevent duplicates in two fields in a registration table. The two fields are: PhaseNo and ProjectNo. What I don't want to have happen is the same ProjectNo along with its corresponding PhaseNo to be duplicated for any record. Currently, there is nothing...

I found out how to add custom buttons for VB: To add the VB code to a button on a toolbar, select Tools, Customize - click on the Commands tab. Select Macros from the Categories window. Select Custom Button from the Commands window and drag it into your toolbar. Click on the Modify Selection...

Once the macros are pasted into the new .xla file and that file is attached as an Add-In, how are the macros run? I'd love to have a toolbar button to do this.

Someone asked me: "How can I save a macro on a network drive, so that all my cube mates can use it on all excel spreadsheets?" What would be the best approach if: 1. Excel is NOT a networked application 2. Excel IS a networked application

First, I'm an Access user trying to work in a FileMaker database & I know I shouldn't have expectations - but I do! Anyway - in Access, I can create a parameter (prompting) query so, whenever it's run, it stops and asks what I want. In FileMaker, I would like to accomplish the same thing. I've...

Yep - Insert, Movies and Sounds, Sound From File - select your .mp3 file - that's it.....

I am unable to see schedules in the Group Schedules dialog (not even my OWN). However, if I create a new appointment and click on the Schedule tab and enter the same people as are in the group schedule, I can see their schedules in that window. Shouldn't I be able to see scheduled times in BOTH...

If I apply the @@@-@@-@@@@ format to the field in the training table, the SSN then displays with the dashes after it's selected from the COMBO box. BUT - the COMBO box STILL does not display the dashes. I've tried everything that's been suggested (and thanks so much for your tips) with no...

You've probably looked at the samples Brio gives in its HELP screens - it appears you can only specify one break column. I know - that wasn't exactly helpful!

Just installed 6.6.4 update (Win 2k) and have been experiencing a lot of program errors (have to shut down and restart). Annoying. Especially since I'm an instructor and the students don't particularly enjoy that part of the class! Would like to know if others have been having problems as well.