Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Melee
  • Content: Threads
  • Order by date
  1. Melee

    Semi-monthly date calculations for Excel time sheet

    I am attempting to upgrade the semi-monthly time sheet to Excel 2007 for my small office. The time periods are 1st - 15th and 16-end of month. Currently the formula that is set up for the sheet confuses the users. I would like to be able to input the start and end dates and have the individual...
  2. Melee

    Notes Calendar icon missing from tool bar

    How do I replace the missing icon on the Notes tool bar? The calendar does exist, but the icon is not on the bookmark tool bar. I need to access the calendar from the bookmark tool bar.
  3. Melee

    XP & Notes 6.5 issue with shortcut icon attachments

    Since I upgraded my system to XP (I use the term upgrade loosely), there has been a problem attaching documents to the email -- Notes 6.5. Typically, I have shortcuts on my desktop to the most frequently utilized folders and utilize those shortcuts to access documents within the folders to...
  4. Melee

    Opened Mail Vanishes

    Admin is on vacation! The amazing Kreskin has been at work. Pathetic supervisor is attempting to resolve problem. On Friday, the world was good. Everything functioned as it should. On Monday, the user opened his email, clicked on a newly received mail to read it, went on to the next item, and...
  5. Melee

    Word/Excel automatically shut down immediately after opening

    MS Word and Excel shut down automatically immediately after opening. It can be a new document or an existing document that is being opened. The application goes through the virus check, etc. displays the document and within 5 seconds closes. I have tried uninstalling and reinstalling word and...
  6. Melee

    Corrupted folder - can't receive mail

    Application: Lotus Notes R5 Problem: A user opened a virus from "postmaster". He immediately closed it, but can no longer receive mail or move items to/from folders. (He can still send email) Attempted resolutions: The application and machine have been shut down and rebooted. The...
  7. Melee

    Transpose vertical format to horizontal from text document??????

    The format at the end of this explanation is a sample layout of one segment of the document I would like to convert. The problem: I have a large amount of data in restricted proprietary Lotus based databases. The databases are not accessible through conventional means. I have been able to...
  8. Melee

    Access of hidden databases?

    I am not a notes developer, but am resonably cognizant of the processes. Problem: We have a Lotus database that was created by a VAB to IBM. The supplier no longer supports theis database. I am trying to retrieve the data in a usable format. So far nothing has worked well. Even getting the...
  9. Melee

    Text to Excel format problem

    I have extracted data from a Lotus application to a word file. There are 19 fields that I want to pull out and put into an Access database. The information is structured as follows: FirstName: 1x Mid_Init: y...
  10. Melee

    convert table to Access/Excel; Col 1 = header, Col 2 = data

    I have extracted data from a Lotus application to a word file. There are 19 fields that I want to pull out and put into an Access database. The information is structured as follows: FirstName: 1x Mid_Init: y Address1:mmmmm Address2: kkkkkkk City: Chicago State: IL Zip: 33333 Alt_Address1...
  11. Melee

    set up agent to automatically forward specific email

    I am a strong Notes user (I do access development) and am trying to set up an agent to forward specific email (based on the sender) to others in our group. So far, I have managed only to forward a message manually. Do I need to have permissions changed? If so, to what? My set up is: -On...
  12. Melee

    Create Error Message when adding new record

    I have a macro for the menu bar that opens a form to add a new record. The record name property allows No Duplicates. I need an error message to appear if the new record entered has the same name as an existing one. Currently, the form appears to accept data changes, but does not. This needs...
  13. Melee

    Count number of clicks on an unbound form

    I have an unbound form that is used to write a series of SQL statement to a temporary table. The purpose is to use the data from the check boxes and option selections to run a report based on the occurances of the Company in the temporary table. This database has more than 500 check boxes and...
  14. Melee

    Null Date Query Results Inconsistent --

    I thought this would be a piece of cake, but it has turned into a royal pain. Goal: Open the Project Close frm showing only those record with no date in the ClosedDate field. Enter a date and be able to retrieve the record later if necessary to reopen the project. I created a simple query...
  15. Melee

    Cannot find library on some work stations, other function fine

    Background: The application is on the server both backend and front end. It is in Access 2000. There are seven users. The users are using NT. On two of the pcs selecting items from the menu bar generate an error which is basically "VB error. Cannot find library. The function is fine on...
  16. Melee

    SQL statements in Visual Basic

    Using the 'DoCmd.RunSQL' in a Private Sub Command_Click(), I can not replicate the results when the same singular statement was ran as a query. To clarify, I have a basic SQl query generated in Access. I am trying to use this fuctional query to create a table at the click of a button. My...
  17. Melee

    Report where check box displayed only when true

    Database has a bunch of check boxes -- I want a report that displays the list of only those that are true for a given record. Say there are twenty-five check boxes. Of those thirteen have a value of true. The report should not display those that are false and should have a nice compact list...
  18. Melee

    How do I Send object (report or form) from Access via GroupWise?

    The "send object" method appears to not to work with the GroupWise e-mail program.  Is there a trick to this?  I would like to be able to e-mail a form and/or report.  The wizard prompts me to set up a new account. I need to use the existing e-mail account.
  19. Melee

    Multi-level/field query -- Any suggestions?

    I have a db with several hundred check boxes in multiple tables.  The boxes encompass 1.Areas of the World, ie Pacific Rim; 2.Countries in those Areas, ie Belize; 3.Product Categories, ie Dried Fruit; and 4.Specific products, ie Dried Plums.  I need to be able to respond to...

Part and Inventory Search

Back
Top