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!

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

Recent content by JWJ

  1. JWJ

    MS VB6 Step by Step - Page 284

    Michael Halvorson, on page 284 of the referenced text, gives the following example of a procedure in a standard module to hold a function declaration. To wit: Function Rate (Hits, Attempts) As String Percent = Hits / Attempts Rate = Format(Percent, "0.0%") End Function On the...
  2. JWJ

    Access keys and changing default data drive and folder.

    Two questions from a Advanced Access guy who is now a VB6 beginner. Subject: Menu Editor I have created a menu and attempted to use the & to underscore access keys (i.e. &Clock and two submenu items &Date and &Time. When I run the program the &Clock works sometimes and sometimes not - the...
  3. JWJ

    Option caption does not appear on form.

    Thank you - I had to widen the option button.
  4. JWJ

    Option caption does not appear on form.

    I have an array of option buttons but the captions appear blank on the form although they appear in the properties window of the individual options. Why don't the appropriate captions appear next to the options button? Any help would be appreciated. I'm new to VB6 JWJ
  5. JWJ

    MS OFFICE 2000, XP, AND COMPAQ PRESARIO MODEL 5010US

    Help, I recently purchased MicroSoft Office 2000 Professional and cannot get it to install on my computer - a Compaq Presario Model 5010US running Microsoft Windows XP Home Edition. It will only go so far and then hangs up. Although I had severe problems running Windows ME on this computer, I...
  6. JWJ

    Missing olemsg.dll

    I have tried to reinstall my Office 97 Professional software. Each time I try to reinstall I receive the following message: "olemsg.dll was unable to register itself in the system registry". Anyone know what the problem is? Your assistance and comments would be sincerely...
  7. JWJ

    Repeated accessing a: drive (diskette)

    Does anyone have any idea why my operating system continually accessing the a:\ drive? The only way I can get it to stop is to place a diskette in it. I am running a new Compaq with WINME? James W. Jozwiak jamesjozwiak@hotmail.com
  8. JWJ

    ANY LIMITATIONS TO EXCEL LOOKUP TABLES?

    I presently have a spreadsheet application where data is downloaded from an Access application. The downloaded table is two (2) columns wide and 307 lines in length. I am using a basic lookup formula as follows...
  9. JWJ

    ACCESS AND WINDOWS ME COMPATABILITY

    Hi, Has anyone experienced any difficulty running Access '97 under Windows ME? Thinking about moving to Windows ME but want to continue to develop applications under Access. JWJ
  10. JWJ

    IIF STATEMENTS IN REPORTS

    I HAVE AN APPLICATION THAT REQUIRES THE USE OF 7 DIFFERENT CATEGORIES OF RECORDS - I WOULD LIKE TO SUMMARIZE THE 7 CATEGORIES ON THE BOTTOM OF THE REPORT. WOULD AN IFF STATEMENT SIMULAR TO THE FOLLOWING DO THE JOB? IF NOT, IS THERE ANY WAY I CAN ACCOMPLISH THIS? ALL SUGGESTIONS WOULD BE...
  11. JWJ

    APPENDING DATA TO ANOTHER TABLE

    I am puzzled. I created table(table 1), copied it to another table (table 2), and then added several fields to table 2. I then used a query to delete the records in table 2, and attempted to append table 1 to table 2 (an append query). I keep getting a "Microsoft Access was unable to...
  12. JWJ

    Changing Data Type When Making a New Table.

    How does one change data types when making a new table?. It would seem that their is/should be a function that would permit changing a data type from integer, double, or single to currency, or vice-versa. Any and all suggestions, recommendations, and/or work arounds would be sincerely...
  13. JWJ

    Dividing at Print Time - How do you do it!

    I have a client who has a database with large numbers, up to 100 billion - and desires reports rounded to the nearest million.&nbsp;&nbsp;<br><br>This report is sorted by agents and datafields are listed in the detail section of the report in billions - where they want to round by millions...
  14. JWJ

    REDEFINING FIELD TYPES

    I am working with a table consisting of 164 fields.&nbsp;&nbsp;The client improperly defined the fields (numeric) as double, single, etc.&nbsp;&nbsp;I have attempted to redfine them as currency as they are all dollar fields upon which arithmetic operations are performed.&nbsp;&nbsp;After having...
  15. JWJ

    How do you summarize a table without creating new field names?

    There are occassions when it is desireable to summarize common records into a summary table.&nbsp;&nbsp;Everytime I try it the fields that are summarized are renamed in the summary table as &quot;SUMOF &lt;FIELD NAME&gt;. Anyone have any answers or work arounds.&nbsp;&nbsp;I have several but am...
See more

Part and Inventory Search

Back
Top