Search results

Hi Pat, Thank you for the information re: this. The reason the Sup changes the ID is because the "Contract"ed employees are acting Customer Service Agents who move Temp-to-Perm if they meet certain criteria and are approved during their probationary period for permanent hire. Once they are...

Access '97 - Database is used to accumulate performance data on Employees. Some are Contract (temporary) and others Permanent. If a Contract employee is hired, they receive a different and permanent EmpID. There is a form that allows a supervisor to change the ID number and update the...

I have a db with scores (various performance characteristics of job functions)that are collected several times per month and then summed or averaged based on our needs. I would like to compare the data side-by-side and month-to-month to measure changes over time. I have queries that pull the...

Jack - Thank you for the excellent resource recommendtion.

I have Excel Spreadsheets loaded into 2 Access '97 db's. The Spreadsheets contain a field marked "Customer Name". One SS has the Customer Name loaded as FName MI LName. The other has the Customer Name loaded as LName, FName MI. Both SS's have the Name in one cell regardless of the...

Got it! Took off the acDialogue and it works fine! Thanks for getting me over this hurdle!

This worked great! Thanks! I have one issue that I am working to overcome, and your advise again would be appreciated. When the form "FrmComplaintData" opens, it is in datasheet view not form view. I keep trying to correct, but get the same datasheet view every time when it opens.

I am having difficulty with a form that is capturing info on correspondence received from customers. I want to have a seperate form pop-up when the "Correspondence Type" field is populated with the term "Complaint" from a drop-down list in a combo box. The form "pops" but it pops regardless of...

I have read through many of the questions related to this, but am not clear on how to achieve a "Comment" of "Exceptional (98-100)", "Satisfactory (95-98)", and "Needs Improvement" based on the value of a field "Total Score" which adds the various points in categories on a form. The "Total" box...

Thank you Pat - I decided to take a different strategy that made my life a lot easier. I am using a form with command buttons to call separate queries via macros. This is "cleaner" than what I was attempting to achieve via a "do-all" query set up. Thanks for the education, however. I am...

I am confused by the apparent limitations on search criteria for multiple fields using "between_and_". I have a table with 10 fields. Standard fields with customer information, DATE, Amount, Carrier, Zip Code,etc. I am able to query successfully when I use DATE criteria Month[Enter Month as...

Pat - Thank you for your help with this.

Jack - Thank you for your prompt and useful response. I appreciate the guidance and will read these pages through. Looks like what I needed.

I am unable to locate information on converting time for display in forms or reporting that converts gross numbers of seconds into Hrs:Mins:Secs. I receive raw data for phone activity that only reports in seconds. I have to convert into decimals of averages of minutes, hours, etc in the query...

Re: an Excel spreadsheet linked to a query in my database - I have no difficulty in opening it from my desktop. However, when I send the link to another user in another facility they are unable to access the spreadsheet. The message returned is the topic title of this inquiry. The excel is...

I have a form that displays data from different tables (for example, attendance records and phone monitoring scores). The parameter boxes are set to request the "Month as Digit" and "Employee ID". The problem I am encountering (in this and other forms/queries) is that the criteria is being...

Thank you, Pat. I have a table of refund data that needs to be available to a customer service group to respond to customer inquiries about status. What I need is the data sequenced from newest to oldest, top to bottom of the Excel spreadsheet. The Table in Access, when exported to Excel is...

Thank you for your help with this. This looks like exactly what I need.

I am interested in finding out if a form can be used as the source of linked data to an Excel spreadsheet. The appearance and layout of the data appears differently than if I use a Table as the source via Cut and Paste Special Links method. The form, however, does not allow the linking option...

Please advise if there is a way to automatically store records deleted from a table in another table. Users have accidentally deleted a record they thought was unnecessary and then realized they actually did not want to delete the record. This process would allow a deletion to be archived for...