Can the formulas be put in with the table - ie does the table come from you as a template? I tend to look for solutions without macros - one way is to point all the formulas in the "report" workbook to the "data" workbook. If all the data workbooks have consistent naming format that just changes the month ie dataJUL08 dataJun08, then build the set of formulas with then pointing to Jun08
Based on the IP config you posted? Yes. As are *all* the clients, so it seems. Especially if it is a Linksys, go ahead and replace it. With a single NIC SBS (no ISA) you should definitely consider a good firewall device. Just try to get into a business class device. Avoid the consumer stuff you'd find on a shelf at best buy. -Cliff "SOLONY" <SOLONY@discussions.microsoft.com
Hi Ctreate a form with your dropdown list. Use the afterupdate event of the combo to open the query Open the query in design view and in the ID column (criteria row) use the build wizard to point to the combo box you have just created. This will filter the query and then open it -- Wayne Manchester, England. "Muzzy" wrote: I have created some simple databases before
Cobb oks $72 million for prison, 911 center, toilet upgrades by TOM OPDYKE Atlanta, GA, USA The bulk of the money, about $71 million, is for expansion of the county prison, approved earlier this year. About $1.2 million will go to ... <http://www.ajc.com/metro/content/metro/cobb/stories/2007/11/27/cobbprojects_1128.html> See all stories on this topic: Prison Operator Touts New Management
Roger, You wrote... That took care of my initial question, very simple indeed. I do have unique data in each record, it's the person's name. Even though your names are unique now, they may not be in the future, and I would strongly recommend you reconsider your table design. Create a new empty table, with the same fields as your original table... but... add and EmpID autonumber
