Search results

Some very good points stated very well. If you study history, one of the first things you discover is that it is very difficult to go from bad to good. It is very easy to go from bad to worse.

My favourite was while playing in a pub quiz game many years ago. The question for the other team was "How many time zones are there in the world". Their guesses were 8 and 16. The QM threw it open and I got it right away. A day is the Earth revolving once. There are 24 hours in a day...

Access Security .mdw When you set up security in Access, the security settings (User IDs, User Groups, Passwords and Permissions) are saved by default in a file called System.mdw System.mdw normally resides in the Windows/System folder on your computer. System.mdw also contains your...

Based on the same standard, George W. Bush set a goal of invading Afganistan and Iraq and the American people embraced his dream. Does this make Mr. Bush your second favourite President? :D

The best president was probably George Washington. He was aware he was the prototype and tried very hard to leave a legacy suitable for the position. Most historians agree that James Buchanan (the one who preceded Lincoln) was the worst. His refusal and/or inability to act on the subject of...

The normal procedure would be to split your database into a front end and a back end. You should find plenty of advice on how to do this by using the search function. and there is a wizard to assist you. When the database is split, the front end - which contains your forms, queries reports...

The simple response is...you have answered your own question. Close the main form, then re-open it. Create a macro to run from your address form. It contains: Close - Form - address form Close - Form - main form OpenForm - main form Place a command button on your address form to run the macro.

I don't think I have ever heard of Access being used for such a purpose, so you are unique. Well done. I would approach this in the following manner: Table: I would start with an autonumbering field which would number each joke or bit. I would then categorize each entry (Family, Sex...

The short answer is yes you can. However, by doing this you are opening yourself up to a world of problems. I would create a query with option of selecting the director you wish to print.

There are certain industries where standards are an absolute must to ensure safety or because technical requirements make them essential. Even so, televisions do not have one standard world wide. As a result, a North American TV doesn't work in Europe or Asia, a European TV doesn't work in...

Are you sure you're talking about Dell? Sounds like the standard Microsoft rant. :D

But how many every day consumers or Purchasing Directors look at power cords or know the difference between good and bad components? Priority 1: Will it run the software? Priority 2: What's the price?

To the best of my knowledge (though I haven't broken the barrier into Access 2010 yet) the runtime version allows you to operate an Access database. You can run any pre-prgrammed application in your database. It will not allow you to make any prgramming changes. Runtime is designed to allow...

When they first opened a Best Buy in my area, I dropped in to take a look. First salesperson: My name is Steve. Do you know we're not on commission? Second salesperson: My name is Brian. Do you know we're not on commission? Third salesperson: My name is Marie. Do you know we're not on...

What I do in these situations is: I create a special report to just print one record The report is run from a query which only runs the report The criteria of the query is set to run the specific record on the form Forms!FormName!FieldName The FieldName should be set to a unique identifier...

The simplest solutions are usually the best. I changed the structure of tblDraft to add an autoID field and removed the no duplicates from DraftName. I then created a delete subquery which removed the duplicate with the higher number per the link you supplied. I added that query to the end of...

Luckily, the hockey season doesn't start til October. I will give it a try and let you know.

I really am treading in uncharted waters (for me) and I have lost my way. The first thing I do in this process is delete all the records from tblDraft as there may be trades and a certain drafted player is no longer a part of the pool. The macro then runs 10 append queries which appends the 10...

It's one of those things I've been meaning to do for a long time but just never got around to. Now I have to deal with it. If I'm going to do it, I may as well make a proper job of it. I've been using Access for pools in a number of sports for a while, but this is the only one where...

Using Access 07. I have a database I have been using for a few years to do our office hockey pool. In a nutshell, each participant may "draft" a team of 10 players from a list of 100 players split up into groups of 10 based on last seasons stats (you may draft 1 player from each group). This...