Search results for query: *

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

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

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

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

Hi~ I am creating a database for our Client Services department. Currently all calculations are done manually and updated into excel - the reports were then emailed to the client in excel. Each client is assigned a "CSA" number and each tab in the spreadsheet would be titled according to the...

Hi~ I have created a form that will be used on the first week every month, the data entered is based on the previous month. I have currently set the date field to default to =Format(Now(),"mm/""01""/yy") what I would like the field to do is to give me the previous month as "04/01/04". Hope...

Hi~ I have a database that is located on the network sever. The database is used by myself and two other representatives. The database is not split (although it will be). I can use spell check in the same database as well as another use. One individual can not - she gets an error message that...