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

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

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

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

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

When dividing one item (bien) by another (budget) - which has a zero value - I get #INF in the computed results. Anyone know how I can show something other than that? I've tried an if...else but it didn't work - might have been user error, though. if(bien/budget<0){0}else{bien/budget} Thanks!

I have one user whose Outlook Today looks different than all my other users. It is NOT an option in Customize Outlook Today because I've tried them all. The black banner at the top is gone - the fonts are different for the links (they are all blue, underlined hyperlinks). I have tried...

I was recently asked what my "dream classroom" would look like. I thought I'd pose that same question to users of this forum. It will be interesting to see what other instructors think would constitutes a state-of-the-art facility. Thanks!

How do I set the criteria to find records based on an exact match of the CASE - e.g., find SMITH but not smith or Smith?

What are the advantages, disadvantages of using an AutoNumber rather creating a multi-field primary key when there is no obvious field which, by itself, uniquely identifies a record?

I was keying in an invalid date (14/8/2005) on an Access table and, when I pressed <Tab>, Access changed the date to 8/14/2005. I was tyring to show someone the error message you get with an invalid date - well, I didn't expect it to swap the month/day! Why does it do that and how can I stop it...

When displaying a report where a bound control is doing a "sum", I see #Error - because there's nothing to add up. I've tried this: =IIf(IsError(Sum([FMLA Hours])),0,Sum([FMLA Hours])) The field being summed is FMLA Hours. I would like to display a zero instead of "#Error". I found this in the...

I have an employee table with a phone number field. I have another table called leave requests with a phone number field that looks up the phone numbers from the employee table. In the resulting comb box in the leave requests table, the phone number input mask doesn't display - the numbers...

Very odd - when open a form and try to UPDATE the value in a combo box control, it won't allow it. However, if I go into design view for the form and then back into form view, it will. Any idea what the heck is going on here???

I've set up a database with user-level permissions and now the boss wants to exclude employees from seeing anything but their own records. I haven't a clue how to do this. Your help, as usual, would be very much appreciated!

A user set up a database with all logical data types for a variety of questions. For instance, he has a table called &quot;Was the Training Useful&quot; with the following logical fields: Not at all A little Somewhat Mostly Very Now, I want to create a column chart in Access XP showing a count...

User has a database with a &quot;one&quot; table (Projects) joined to a &quot;many&quot; table (Comments) by two fields: Project Number and Phase. The Project Number and Phase together are the primary key. She created a query using both tables, included in the grid the Project Number and Phase...

I would like to prevent the display of toolbars for charts and drawing objects when they are clicked on. I'm sure this calls for some VBA - and I'm not VBA-savvy. Many thanks to those of you who are - you have answered lots of my questions in the past.....

Win '98. Just installed a LITEON CD-ReWriter, ATAPI-EIDE Interface. Installed as a slave device on the primary IDE and it's working fine. Did NOT hook up its audio cable. Already had a CD drive for playing CDs/DVDs and it is set as the default Drive to use for such things. After rebooting, no...