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 bkrike 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: MrMeric
  • Content: Threads
  • Order by date
  1. MrMeric

    Persistent Powerpoint Problem

    I have a user who gets the following message when he opens PowerPoint: "This add-in is designed to work with powerpoint 2002 only." It seems like I've tried everything to get this message to go away, but it still persists. I even uninstalled/reinstalled Office, but it's still there! I don't...
  2. MrMeric

    Modeling single/multiple/indefinite dates for appointments

    How would I go about representing appointment dates that could either occur once, multiple times, or indefinitely? For example, I'd like to know how an application like Microsoft Outlook stores its appointment/meeting date information. Thanks!
  3. MrMeric

    Book Recommendations

    I’ve been working with OOP for a while (C#, VB.NET), and I’m just starting to get into design patterns. Lately I’ve been hearing a lot about AOP (Aspect-Oriented Programming) and was wondering what it was. After some investigation, this concept seems quite interesting. My question is this...
  4. MrMeric

    Emailing Sensitive Customer Information

    The corporation I work for is in the process of implementing encryption for emailing sensitive customer information, but they have given me the task of finding a temporary solution until the encryption is in place. They insist that I create a program that splits these sensitive files in two...
  5. MrMeric

    Bordering States Function

    Does anyone know if there exists a function that will determine if a state is a neighbor/bordering state? For example, a user would pass in two states and the function would determine if they are neighbors: BorderingState(StateOne, StateTwo). Examples: BorderingState(WI,IL) would return True...
  6. MrMeric

    Excel Cell Formatting Question

    Do you know if there is a way when keying in numbers using 10 key that you can set up a spread sheet to automatically insert the decimal point? Example I key 12345 and want it to enter as $123.45. I tried to format the sheet using 2 decimal points but it enters it as $12,345.00 vs. $123.45.
  7. MrMeric

    Saving Attachements to Folders

    I have a whole bunch of emails from different people with attachments. Is there any possible way I can make Notes create a folder with the name of the person and extract the attachments into that folder?
  8. MrMeric

    Report/Subreport in Form?

    Can one place a report/subreport in a form? If not, what are some alternatives? Thanks!
  9. MrMeric

    Searching for the impossible?

    I'm looking for a simple, centrally located (web-based or otherwise) workflow flowchart application with a drag-n-drop interface. In general, I would like to flowchart/document an organizations workflow, so one can obtain a birds-eye view of all processes, or be able to zoom down into one single...
  10. MrMeric

    Visio Database Question

    I have two questions: 1. Can the layout of a Visio diagram (specifically a flowchart) be saved to a database and be accessed from multiple computers? 2. Please bear with me on this question, I know nothing about shapes. Is it possible to have a drop-down box in a shape? If so, is it possible...
  11. MrMeric

    Stumped! Multiple Report Print Jobs Taking Forever!

    Good day to all -- I'm stumped! My database consists of 4 reports; for ease of use I will call them Report1, Report2, Report3 and Report4. Each one of these reports is more or less a legal form. The user would like to have the reports collated for each record that is printed, so the reports...
  12. MrMeric

    Combine/Join Two Arrays

    I must be thinking too hard because I can't get this to work for the life of me. How would I combine two arrays into one? i.e. ---------------- aOne(0) = "zero" aOne(1) = "one" aTwo(0) = "two" aTwo(1) = "three" aTwo(2) = "four" ---------------- I would like to somehow combine these two, and...
  13. MrMeric

    Passing Array

    I'm trying to pass an array to an object, but I continually get errors such as: "Can't assign to array" Here is a snippet of my code: Function mytester() Dim myArray(2) As String Dim mObj As cSimil Set mObj = New cSimil myArray(0) = "one" myArray(1) = "two" myArray(2) =...
  14. MrMeric

    Array of Arrays?

    Hello! Is it possible to create an array of arrays? I need to store an unknown amount and varying length of byte arrays. Essentially, I would like something like this: myArray(23,45,12,25,22,12) myArray(12,24,25) myArray(34,56,74,13,95,14,12,65,12) myArray(12,34,17,73,24) myArray(12,14,45)...
  15. MrMeric

    Need Assistance Optimizing Code

    Good day! Background: 1. Using VB6 (VBA) within Microsoft Access 2. Utilizing 3 functions within the main SimilSearch() routine. These are: a. Simil() i. Simil is a "smart string comparison" algorithm. It takes two strings, compares them, then spits out a percentage of likeness. b...
  16. MrMeric

    Alternate Subreports?

    Good day! I have a report that has the following layout: +----------------------+ | subreport1 | |-----[Page Break]-----| | subreport2 | |-----[Page Break]-----| | subreport3 | |-----[Page Break]-----| | subreport4 | +----------------------+ Is it...
  17. MrMeric

    Multiple Reports

    Good day! In the past, I have been tasked with printing multiple reports for each record within the database. In essence, I needed to collate the documents. To accomplish this I would use DAO/ADO and loop a "WHERE" statement to each report I wanted to print. The code would then move to the next...
  18. MrMeric

    Add Field To Query Result

    Good day! How would I go about adding a "YES/NO" field to my query results? I would like this to be the first field. Here is my SQL SELECT Lease.VIN, Lease.LeaseNumber, Customer.Name, Customer.Address, Vehicle.Make, Vehicle.Model, Vehicle.Year FROM ((Vehicle INNER JOIN Tax ON Vehicle.VIN =...
  19. MrMeric

    Expand Form

    Good day! I would like to accomplish this: When a user clicks on a button, the form will expand and a subform will appear in the expanded area. I've tried to implement this function with no avail. I currently have the subform position set to 0,0,0,0. I have a button that contains: Form.Width...
  20. MrMeric

    Notes Desktop Calendar

    Hello all! This may be a dumb question, but is there a tool that will allow me to have my Lotus Notes calendar on my desktop as an "active desktop" item? Thanks!

Part and Inventory Search

Back
Top