Recent content by ccma

Hi~ I have a database (97) that is used by our Quality Assurance department that tracks our collection reps productivity. The QA reps have to enter the time a rep spends on a call. A rep would normally spend less than 20 minutes. My problem is I set up the field as a short time field and one...

Well I won't be able to get to my bosses PC until tomorrow but I will re-post- with a result. Thank you so much for your reply!

Today I got a message from one of my bosses that he is unable to obtian/print several reports. The SQL statement below is the underlying statement for all reports. This report has been available for about 3 days now and I am able to preview/print the report without any problems - as well as...

I should add that when I try to repair the database the same error message appears.

I'm receiving a strange error message when a database initially opens: ' isn't an index in this table. Look in the Indexes collection of the Table Def Object to determine the valid index names. The switchboard will come up and am able to enter into the forms and view the data... but when I go...

Well it worked --- the individual did not get the previous error message -- she did receive a new error message only because she had to many applications up and there was not enough free memory- once she closed the larger apps she was able to preview the reports. Thanks for your patience and...

Gotcha I will try this out and re-post with a result (hopefully). Thanks for your suggestion. Cherly

Like I said I'm a beginner --- but I am 100% sure that it is on the OnPrint event in the detail section of the report - and because that is the only macro or VB that I created on the report. The database is on the network and is not split so everyone is working on the same database and the db...

Hi~ I have a report that displays productivity figures for individual reps along with a chart. The page breaks whenever there is a new rep. At one point the department manager would have a chart that did not match the data assigned to the individual rep but would be someone elses data. When...

Is this the first time you have used the switchboard manager to create a main switchboard?

Hi~ Ahmun thanks for posting this question... I'm also in the process of building a database for our Human Resource department. I've had experience with access for about a year now and am definetly concerned about security within this new database. Everything that I have seen requires a lot of...

(formerly ccolon) I failed to mention that in my table I did have the data type set to date and the format set to short date (if that has anything to do with it). This makes me nervous, due to the fact that we are slowly in the process of upgrading everyone to XP. I am always creating new...

I know that this post is old but I am having the same problem. The data gets inputed into a table and the data type for the Date field is set to Date. When I run the data on my PC the dates after being "crosstabed" remain as imputed 06/01/04 but on 2 other PCs they show 06/01/2004. When I...

What happens is the following--- CSA# Pmt Accts 345 1429.77 7 P 346 1800.89 52 347 41333.80 121 The field spacing is not consistent -- I need all numbers under Accts and if the number is a one digit number it does not set three spaces before starting...

Hi~ Is there a way in which you can force a data type with VBA? I have a table that is imported into a database(97)from an application called Monarch. One of the fields has a letter before a number - Monarch extracts the letter and changes the field to text before importing. (Monarch will not...