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...
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...
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
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...
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...
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
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...
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
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...
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...
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...
I have a client who has a database with large numbers, up to 100 billion - and desires reports rounded to the nearest million. <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...
I am working with a table consisting of 164 fields. The client improperly defined the fields (numeric) as double, single, etc. I have attempted to redfine them as currency as they are all dollar fields upon which arithmetic operations are performed. After having...
There are occassions when it is desireable to summarize common records into a summary table. Everytime I try it the fields that are summarized are renamed in the summary table as "SUMOF <FIELD NAME>. Anyone have any answers or work arounds. I have several but am...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.