Search results

Microsoft has abused Foxpro users horribly. At a government agency, they had several replicated FoxPro databases to run the Air for the Environmental compliance. I had integrated it with MS Access connected to SQL Server. One weekend, secretly and undocumented, Microsoft added the death of the...

The answer is "it depends" 1. If one Excel Workbook has buttons that open up the other 3 workbooks, then automation code could be used that opens the other workbooks and keeps a pointer (an object variable) to each open workbook - this could be used to remotely manage data or other objects on...

Just too busy to get back, thanks for posting your solution! For your vlookup instead of hardcoding the workbook and tab (worksheet) names - this might give you an idea for assigning them to a variable. Great work on your part! Range("E3:E27").FormulaR1C1 = "=VLOOKUP(RC[-4],'" & WbkNameVar &...

Small improvement if needed: =IF(ISBLANK(C3),"Missing Time",C3+D3) Where C3 is Date and D3 is time This can be used to prevent the return of 1/0/1900 0:00 when the cells are blank. A second IsBlank could be used as a Nested If if only date but no time was submitted. For an empty cell, just use...

From Downunder: The best April Fools prank in my memory was our local (South Australian) Australian Broadcasting (then) Commission current affairs program This Day Tonight (TDT). At the time Australia was in the throws of converting to the metric system and the brains trust at TDT came up with...

Added below the Best 2016 April Fool Jokes http://www.chicagobusiness.com/article/20160401/NEWS07/160409989/could-this-news-fool-you What's your plan or story? In 1965, during the Cold War, a high school shop class got some oil barrels wielded together to make a long cylinder. They added...

I have some heavy GIS integration in Land Management for the entire mid-west. Out here we use Lots, Quarter/ Quarter, Section, TownShip, and Range Its supported with Lat/Long centroids Just wondering what kind of Legal Description do they use in WV?

Yes... it IS about time indeed. Welcome If you are an Excel vba programmer, be sure and find the Excel forum. Some of us create powerful excel outputs from VBA code in MS Access. All of your Excel VBA will be 100% useful. Look forward to your questions.

Be sure to also post question in the Excel forum. Many of us use Excel from MS Access to create reports in Excel. Naturally, this includes programming formula creation in Excel to make it very useful. An instance of Excel is created remotely from MS Access to fit the data brought in from MS...

Let me throw a few quick and simple examples of the Vlookup that I use from MS Access to create formulas in a remote Excel object. The objXL. variable in my code is just a reference to Excel.Application. From within Excel, it can be omitted when writing code. Set WKB1 = ActiveWorkbook...

As usual, you are spot on. Totally agree with that assessment. In most cases where we DBA want to understand exactly what is changing, I would probably tend to say it is the best way to proceed. The method in my top post warned me of that in the other table and seemed to take care of it. While...

The command parsed correctly, but errors and didn't change anything. Of course... there is always something else When one of the fields hit this from my method, it actually helped modify the other field that had access. I would agree it should work in other situations. use MyTestDatabase go...

I totally agree with SQL_Hell In my world of Regulatory madness it sometimes involves that box thinking outside thing. So at the risk of being clever, let me describe a project coming hot off the press. (The hot press of the old news papers is now replaced by the pressing of Hot keys, and why is...

That is a great point I didn't mention. On smaller lookup tables, I have coded to drop and rebuilt. This wan't that big of a table, maybe 80,000 records. The result deleted all the data, ... but my setting was changed. Lucky me... there is a [dbname]T (for test) to try out different things...

That is a good point. A script could have added a new field with the Allow nulls. An update query could move the data over to the new field. Then, the old field could be renamed. And, the new field renamed to the old field. That would take care of tables that had the Table's Change Tracking set...

The opinion of other Access designers using a SQL Server back end is requested. Was this the best option for the situation? Is it a risky option? This could be of interest to anyone that migrates an Access Database into SQL Server. In SQL Server, while in a Table Design view, a field was...

Trying to improve SQL Server Skills: Let me recommend this: http://www.access-programmers.co.uk/forums/showthread.php?t=270202&highlight=migration It is all free. SQL Server Migration Wizard for Access (SSMA) Plus SQL Server Native Client (used for ODBC and is standard for Microsoft AZURE) If...

This came to my email, wish I could schedule it. Wondering if any one else knew about it? :) NATIONAL SEMINAR Tuesday 17th May 2016 To be held at Beaumont House, Burfield Road, Old Windsor, Berkshire, SL4 2JJ in the Kensington Conference Room AUG_NatSeminarAgenda17thMay2016.pdf at...

went through the entire site, looks nice. Saw the Access run-time engine. Great concept overall. when you get enough posts to PM, drop me a line. I am in the Denver Tech Center area but have worked in the Springs area same time frame. We should have a cup of coffee and discuss the SW...

Will look at that from home in a couple of hours, thanks!