Replies

Hi kweaver,
I’m not sure if the following will meet your client’s need, but I’ve sometimes copied from the Word source document and pasted into a text editor that does not recognize or preserve formatting (e.g., Notepad), copied from that text editor and pasted into a master Word document, and then applied Word macros to format that pasted matter to my taste.

Dave

I just did a speed test from this site
http://www.speedtest.net/

and had a download speed of 43.5 mbps. So that certainly should not be the problem?

Then I went to get back onto this forum site via Firefox, and I saw down in the bottom left hand corner of the screen (just above the start button) a running collection of notices that data was being transferred from a whole multitude of sites, including facebook etc,…and that slowed up my connection to this forum. What the heck is that??

Hi beiland,
It sounds as though the webpage you are attempting to display is loading content or running scripts that are associated with those other websites. You can check this by viewing the initial downloaded html, which in the version of Firefox I use is accomplished by clicking “View” and then “Page Source”.

If you are not running the NoScript addon in Firefox, downloading it and installing it might preclude some of the third-party content or scripts and thereby enable the webpage to take less time to load.

If viewing the page source of the webpage you are trying to load does not reveal any references to the third-party stuff that’s trying to load, then perhaps the third-party stuff is from the previous webpage that you visited. In that case, perhaps it would help, prior to accessing a new webpage, to manually stop the former webpage from loading.

If you’ve been doing all of the above and still have the issue, then I have no idea. :confused:

Dave

Hi Brian,
As an alternative to “blanking the display,” might it be feasible to display an image of the event logo or an image that has only a background color?

Dave

Hi Jim,
You might try using the Count function to obtain the number of rows returned by a query. Assume we’ve defined the variables current_month and previous_month. Then, a joiner would be an employee where (1) selecting by the employee and current_month yielded a count of 1, and (2) selecting by the employee and previous_month yielded a count of 0. Applying the Count function to the list of employees returned by this joiner query would yield the number of joiners.

The logic for determining number of leavers would be analogous.

The above is sketchy but might help you get started. A more detailed answer might or might not have applied to the database software and version you are using.

Dave

Speaking of Lenovo…

http://www.geekculture.com/joyoftech/joyarchives/2108.html

Dave

Hi sheltieMom,
Here’s one way to handle the data elements that appear in more than one table. I’ll use patient_name as an example. Create a table (let’s call it “PNameTmp”) that has only patient_ID and patient_name. Then populate it with all distinct combinations of [patient_id, patient_name] from the three original tables, sorted by patient_id. The resulting rows might resemble the following:

1 | Ann Aardvark
1 | Annie Aardvark
2 | Bonnie Beetle
3 | Charles Centipede
3 | Charlie Centipede
3 | Chuck Centipede
etc.

Now, you would need to manually inspect this table for any patient_id that appears more than once, and delete all but one row for a given patient_id. This might result in the following:

1 | Ann Aardvark
2 | Bonnie Beetle
3 | Charles Centipede
etc.

These steps (starting with creating an additional “tmp” table) would be repeated for each field that appears in at least two tables.

The nice part is that when the above has been accomplished, you will need to visit only one table for the values of any given field. For example, the values for patient_name could come strictly from the PNameTmp table.

For any field that appears in only one of the original three tables, you would obtain its values from that one original table.

Hope this helps,
Dave

Hi,
The article at http://www.opengatesw.net/ms-access-tutorials/Access-Articles/MSAccess-Deployment-Best-Practices.htm seems to address some aspects of your question.

Hope this helps,
Dave

Hi Don,
I see that you treat the concept Property as the parent of the concepts Owner and Tree. But severing an owner from a property does not necessarily make the owner vanish. For example, an owner might have two or more properties. Similarly, a tree might have existed before its lot were developed, and continue to exist even if a property line were to be redrawn.

Your database design could reflect the above if instead of having PropertyID embedded in Tree and Owner, there were separate tables depicting these relationships: Tree-Property (which would at minimum contain TreeID and PropertyID) and Owner-Property (which would at minimum contain OwnerID and PropertyID).

This design might also make it easier to enter data about a particular tree or owner without having to establish its relationship to a property. For example, if a new family purchased a home but the closing date had yet to be reached, you could nonetheless enter the family’s information into Owner.

Hope this helps,
Dave

Hi Seba,
My immediate impression is that position number is too fluid to be a viable primary key. Instead, the primary key for position should probably be an immutable position_ID that the user might not ordinarily need to see. Whenever a given position_ID would be assigned a different position number, a tuple consisting (at minimum) of position_ID, position_number, and effective_timestamp could be entered into a Position Number History table. Analogously, there could be a table consisting of (at minimum) position_ID, employee_ID, and effective_timestamp, to which a row would be inserted whenever an employee were assigned a different position (but not if the change were merely to the position_number associated with the employee’s present position_ID).

Presenting the data as if they were keyed by position_number rather than position_ID would require creating “views” (or whatever they’re called in Access) that would join tables by position_ID and involve other criteria (such as the most recent row in Position Number History for the given position_number).

Hope this helps,
Dave

Hi caveman,
According to http://docs.oracle.com/cd/B28359_01/server.111/b28286/queries004.htm, Union excludes duplicate results, whereas Union All does not.

Dave

Hi Gavin,
I think that the preferred database design would also depend on the extent to which the agency is anticipating its data model to change over the time that your database would be in service.

For example, imagine that the agency were to add a product line that does not share all of the formerly “common” attributes. If all of a product line’s attributes were only in a corresponding product-line-specific table, then you would need to add a table for the new product line but the other product-line-specific tables might be unaffected.

In contrast, if the schema had a distinct table for the “common” attributes, then to maintain the database’s conceptual integrity would entail removing the no-longer-common attributes from the common-attribute table and inserting them into the appropriate product-line-specific tables. This would presumably cascade to queries, views, etc. It is feasible but can become a nightmare and does not seem a sensible undertaking for someone who’s inexperienced in database design and management.

Hope this helps,
Dave

I’ve been clicking on the window close X of the prompt box in case either option led to anything nasty.

Another method for closing a prompt box (or the active window generally) is to press Alt-F4, which avoids having to ascertain whether the “X” is a true close button or a code-launch button in disguise.

Dave

Lanshark!

I just bumped into this old post of yours. I’m having the exact same issue on my mother’s computer that was recently upgraded from XP to Win7 x64. Did you ever resolve the issue? If so, please tell me how!

(Before Mom drives me nutz, please???)

Thanks!

Hi,
Could you advise as to which web browser(s) you’ve used that exhibit this behavior.

Dave

Hey chuckiebaby,
Welcome to the forum.

Could you provide more information, such as the steps you have tried and the result (e.g., the system ignores what you’ve typed or clicked on, or a window appears that displays an error message).

Dave

Hi Carl,
In the following thread, the original poster (whom I’ll call “Cliff Lewis,” being that that’s his user name) reports a problem that seems at least similar to yours and discusses his solution in Comment 10.

https://bugzilla.mozilla.org/show_bug.cgi?id=926467

Hope this helps,
Dave