Replies

I’m not sure what you have in mind with your “Dragbox” concept, but I did have a quick look at your sample database. I noticed several text boxes for your search parameters, along with references to each text box in ‘squery’, a query that serves as the recordsource for your subform.

First, you will want to rid your existing code of all compile-time errors. Your main form has references to two controls, cbxName and cbxFilter, which are not present. On my machine, this resulted in 13 “Enter Parameter” prompts before the form opened with all records displayed in the subform. You will not see this effect if you have the VBA Editor settings for Compile On Demand checked (the default). This is a global setting that does not ‘travel’ with your database, so you may not want others to experience this if they open your application.

I also recommend that you set the VBA option to Require Variable Declaration in all new modules. This will give you the very important Option Explicit for newly created modules. You can find these options by opening the VBA Editor, and then clicking on Tools | Options… The Require Variable Declaration option is on the Editor tab, and the two Compile On Demand options (Background Compile and Compile On Demand) are found on the General tab. My advice: Enable (check) Require Variable Declaration, and disable (uncheck) both Background Compile and Compile On Demand. I also recommend deselecting the “Auto Syntax Check” option, on the Editor tab. I have a different name for this option: The carpel tunnel option, since it simply results in a modal error message, that you generally have to click your mouse to dismiss. Errors in VBA code are generally obvious, as they are shown in red font by default. Also, add the very important Option Explicit as the second line of code to the top of any existing modules, since the Require Variable Declaration option checked only kicks in for newly created modules.

I have two QBF (Query By Form) samples posted on the Seattle Access web site:
http://www.seattleaccess.org/downloads.htm

Look for the January 8 and February 12, 2008 downloads. The first one, for 1/8/2008, is much easier to implement but not quite as versatile.

If you are using Outlook as your email client, you are welcome to incorporate a procedure I wrote several years ago. Have a look at page 20 in a Word document I call “Access Links”. You can download a zipped copy from here: http://www.accessmvp.com/TWickerath/downloads/accesslinks.zip.

You’ll also need a way of feeding this function a semicolon delimited list of email addresses, but that part is fairly easy. Post back if you need help doing that part.

Hi 79shultz,

You might want to have a look at these two subquery help topics, written by former Access MVP Allen Browne:

Subquery basics
http://allenbrowne.com/subquery-01.html

Surviving Subqueries
http://allenbrowne.com/subquery-02.html

Allen’s site is a fantastic site for learning about Microsoft Access.
http://allenbrowne.com/tips.html

Ruirib,

I tried your SQL statement, after creating the two tables and entering some test data, but I received an error message that reads:

“You tried to execute a query that does not include the specified expression ‘ProductID’ as part of an aggregrate function.”

I thought you were close, so I tried a slight variation of your suggested SQL statement. This seems to return the desired result, with the very limited test data at hand:

Code:

SELECT P.ProductID, 
     Sum([T.UnitsInStock]*[P.QtyPerBox]) AS InStock, 
     T.StockDate, Max(T.StockDate) AS MaxOfStockDate

FROM tblProducts AS P INNER JOIN tblStockTake AS T ON P.ProductID = T.ProductID

WHERE T.StockDate=
      (SELECT Max(StockDate) FROM tblStockTake T2 WHERE T2.ProductID = P.ProductID)

GROUP BY P.ProductID, T.StockDate;

Industry data says 85% of TV viewers use cable. Probably a large percentage connect to cable via if HDMI if they have it. I wonder how many have two HDMI ports? I have a fairly recent Sony with only one HDMI port so I can’t use Chromecast. To bad the ads and articles don’t mention that one should check this first.

Hi Heritage,
While you may not have been planning on a small extra expense, you can purchase an HDMI switcher for not much money. Google that term–you will find lots of hits. Here is just one such hit: http://sewelldirect.com/3×1-HDMI-Switch-with-Remote-13b-Compliant.asp

I bought a Chromecast and after talking to Google’s tech support I returned it. Not only was I using XP (which worked exactly ONCE with the device), I also was using the newer 5.0 GHZ spectrum and found info on their website that they are not supporting that either. I wasted about 2 days trying to sign in a second time without success. I will wait for a later version or skip it entirely. I also use an Audioengine W1 to send sound from my PC to my stereo receiver wirelessly, and the Chromecast interferred with that. The Chromecast window reverted to my PC speakers after a reboot. Altogether it was a major disappointment. At least through Amazon, I quickly got a full refund.

The 2.4 GHz spectrum tends to suffer from co-channel, adjacent-channel, and non 802.11 interferences a *lot* more than the 5.0 GHz spectrum. A common source of non 802.11 interference is microwave ovens. If you live in a single family residence, then the S/N level of neighboring WAPs (Wireless Access Points) is probably too weak to present much co and/or adjacent channel interference. However, if you live in an apartment complex, the 2.4 GHz spectrum is truly crowded. I know, as I’ve measured this with my Fluke Aircheck.

I found video quality on the TV relatively poor and audio rarely synched properly. I tried to watch a feature film from a password-protected Vimeo feed. After about six minutes, I gave up. I plugged the laptop directly into the HDTV, grabbed a wireless mouse, and enjoyed the movie.

Just curious….is Chromecast using the 2.4 GHz spectrum, or the newer 5.0 GHz spectrum?

Check out these links:

http://allenbrowne.com/ser-63.html

http://allenbrowne.com/bug-18.html

http://allenbrowne.com/QueryPerfIssue.html
In this last article, see the section titled “FIRST versus GROUP BY”. Note that you are free to change the default aliasing, by entering something unique, separated by a colon. The field alias must be unique, and cannot be the name of another field available to the query.

Hi Sanora,

However, client printer(s) and printer here in the office are not the same.

You can install the printer driver for your client’s exact model of printer, without actually having the printer. Just don’t attempt to print a test page. After installing the print driver, temporarily set this phantom printer as your default. Then compare your reports in the two copies.

Also, to help determine if there are other differences, you can use the undocumented SaveAsText method. Open the Immediate Window (). Then enter a command similar to that shown below:

Application.SaveAsText acReport, “ReportName“, “C:TempReportName_Copy1.txt”

where ReportName is the name of the report in question. In copy 2, perform a similar export, again using the Immediate Window:

Application.SaveAsText acReport, “ReportName“, “C:TempReportName_Copy2.txt”

Of course, you need to have a folder named “Temp” off of your C: drive, and you need to have write privileges to this folder. If not, make the appropriate substitutions to a different folder on your system. When finished exporting the two reports to text files, try opening them in NotePad to compare them. Or, if you have a file comparison tool, such as Beyond Compare, you can use that as well. Look for any differences in the report definitions.

I’d like to suggest an additional tip for Fred Langa’s top story article titled “Proven techniques to secure your Wi-Fi network”: If not needed, disable the ability for a wireless client to communicate with another wireless client connected to the same network. The Cisco Linksys router administration utility on my older router refers to this setting as “AP Isolation”, which is disabled by default. If you enable this setting, then all wireless clients and wireless devices on your network are isolated from each other; they will be able to communicate with the router, but not with each other. Of course, this setting will not work for you if you use a wireless printer.

What about file transfer/file copy speeds from one computer to another on a home network? I don’t see any data for that in the charts at SmallNetBuilder; the charts are all about internet speeds and wireless transmission of internet. I’m more interested in how fast large files can be transferred from computer A to computer B through wired ethernet connections on the router. For example, our inexpensive wireless router gives us download speeds at least as fast as what we pay for (Comcast 25Mbps down./5Mbps up.). But, when we copy, say, a 2GB HD video file from one PC to another PC the transfer speed is between 5.5MB/sec. and 6.2MB/sec. The same happens with other groups of medium and smaller size files. The router claims to have Gigabit 10/100/1000 LAN. Both PCs have Gigabit LAN (one Marvell the other Intel), and the transferred files reside on Sandisk SSDs in both PCs. So, why is the file transfer speed so slow? If I multiply MBps by 8 to convert to Mbps the speed is still rather low when you consider that even a slow hard drive can read and write large files at better than 30MB/sec. Do any reasonably priced routers have significantly better file transfer/copy speeds?

Have you tried using some new patch cords? You could have a defective patch cord, with NEXT (Near-End Crosstalk) or some other problem. You might want to have a look at this FlukeNetworks video: “The Truths about Twisted Pair Patch Cables.”

Also, check for a Duplex Mismatch error.

I have a friend in Jerusalem who is running Norton Internet Security (NIS) with Malwarebytes (I recently gave him a paid subscription to the Pro version of Malwarebytes). Everything is running fine on his Windows XP system, that is about 7 years old, and currently has 1 GB of RAM (maximum upgradable to 2 GB RAM). Malwarebytes did catch one piece of malware that slipped through NIS.

On my ~6 year old laptop (Windows 7 Ultimate), Malwarebytes detected and removed a browser hijack malware that slipped past the guard of my TrendMicro AV software.

Generally good article, but I would appreciate a more through explaination of the statement “Stop using Windows XP.” To me, this sounds like it toes the Micro$oft line about the reason to upgrade. Yes, there was mention of UAC (User Access Control) built into Windows 7, but there was also a statement that indicated the typical Pavlovian dog response: “Most people just click Okay and continue”. So, they are not gettng the benefit of UAC. What about running any operating system under restricted privledges for browsing, such that no software can be installed? Is Windows XP still in need of updating in that scenerio?

How are you building your queries? Are you using query design view or SQL view, building them in VBA code, etc.?
Are you able to post a small generic sample (no confidential data) that demonstrates this error?

You might want to try a custom function, written by Graham Seach and Doug Steele:

A More Complete DateDiff Function
http://www.accessmvp.com/djsteele/Diff2Dates.html

I have attached a sample database, in Access 2000 file format, that includes two queries that call the “Diff2Dates” function.
32447-CalculateAges

Note: If you are running Access 2007 or 2010, make sure to trust the folder first, since this sample includes Visual Basic for Applications (VBA) code:

Dealing with the Trust Center
http://www.accessmvp.com/TWickerath/articles/trust.htm

The first query, “qryCalculateAges”, includes the original data from your spreadsheet, along with age calculations for November 5 (the date you started this thread), and the current system date on your computer as today’s date. The two calculated ages are presented in “ymd” (Year-Month-Day) format. The data is sorted by birth month and birth day (1/25, 2/15, 3/1, etc.).

In the second query, “”qryCalculateAgesWithNestedIIFStatements, I used a rather ugly series of nested IIF statements to show age in:

[*]Years only if they are 16 or older
[*]Years and months, if they are between 13 months to 15 years of age and
[*]Years, months and days, if they are 12 months or younger