Search results

Exactly!!! thank you...:)

My database is for service coupons that can be presented for multiple reasons and can have multiple coupons awarded on one. so it looks like CouponNumber CouponDate Approved (true/false) Associate PimssHelp (true/false) CustomerAdvocate (true/false) CustomerCompliment (true/false)...

Does it only truncate upon export or does it happen when you just run the query?

I have my call length set to Hours Minute seconds that we data enter as 00:06:59 for six minutes 59 seconds in my report I would like to show the average of this for certain criteria but it returns an odd number =Avg([CallLength]) as 800.40 for example so I thought if I coudl tell it how to...

Grouping would be great....however I have over 20 categories and as far as I can tell you can only group a limited number(4 is a reports limit), so how would you suggest grouping 20+ :confused: or is it different if I do not use the wizard?

The subject line is simple the detail is not:eek: I am working on improving my database (the first one I created a year ago while teaching myself access) I fully expect the problem may be in my design, but I am hoping to overcome it. The database is to track and evaluate call center...

You rock... thank you. I was trying to put the [Accurate/Complete (30 pts)]<30 first... :banghead:

I need some logic help, I am trying to sum fields if a another field (Accurate/Complete (30 pts)) is less than 30 Right now it works to provide my total if the yes/no button for a certain field has been clicked. =Sum(IIf([Procedure Error],1,0)) now I want it to only total the numbers if...

Another question: I was able to use the second DoCmd line (the one for text) DoCmd.OpenForm "Incentive ReportF detail to test links", , , "Associate = '" & Me.Associate & "'" to bring up all data for a specific associate when I click on that field...problem I want to overcome is it brings up...

thank you, This was exactly what I was looking for... I do have a question though.... I used the top DoCmd line which allows me to click on the evaluation number and bring up my new form... Now I woudl like to see if I can set something like this up on a report that shows an associate and...

thank you, I was thinking the same thing...sleeping dogs my be better left that way...:cool: as this was my first database, I will adapt and my next database will be better... as we dont have a huge flow of employees we may have the rare occasion of the same name, in which case we will...

Ok, so we will continue this with OOPS...:banghead: I did set the Employee name to Primary Key. I can add an employee number at the time I work on adding the term date but now I need to know the pitfalls.. first on the term date. You mentioned having a related table of hire/term dates so...

I have an active database that is used to evaluate employee call performance. When building the database (my first full attempt) I did not include a way to sort out employees who are no longer active. I know I dont want to delete them. I have three thoughts to fix this but would like opinions...

thank you, I made the copy and set up the dependencies...I was able to see what I needed. the copy was 1 meg larger than the original... for now I am keeping this copy in the backround for reference. If I continued to use it would that continue to get larger or does that just depend on the...

I have a database where track changes is turned off. When I click Object Dependencies Access wants me to turn track changes on. I have no problem with this provided it does not cause any issues. My understanding was that track changes can increase your database design as well as slow it down...

This may or may not be helpful but I too was having an issue exporting a memo filed to Excel. From the research I did online it sounds like it was a know issue with Access that was addressed in later version. I am using an Embeded Macro "On Click", under the Event tab in properties, to Export...

My table has the primary key set to autonumber incremental index (no duplicates) do I need my form where all the data entry happens to have record locks in the properties? right now set to no locks the other options are all records or edited records. would having it set to no locks lead...

If I do decide to push a copy out to each person's desktop how do I ensure they do not have a "personal copy" of the database? In the past we have had issues with Access databases being copied to the desktop and from that point on it was a stand alone copy with their own set of evaluation...

We just had the issue again... I think I may have had a problem in my save button it had extra syntax in there... but that beign said I also looked at the Data field on the form filter on load is set at no---should this be set to yes (is there anything else that would need to change with that?)...

I have a database that I have set up the evaluations form with an Email button that pulls the data based off the evaluation ID and puts it into a report format. it is set an event on click RunMenuCommand command SaveRecord EMailDatabaseObject Object Type Report Object Name Evaluation Output...