Search results

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!

I worked as a government employee, a Federally funded State employee and then jumped the fence. Officially, I must say "It was a wonderful experience". My hat's off to you. My advice is: don't worry if nothing actually ever gets completely fixed. If you can make it much less worse, you have...

what is your area of business expertise and where are you located? Are Venus or Saturn the home office?

That is absolutely fantastic. A Users Manual - you may have to explain what that means as it is so rare. Seriously, that is wonderful to have a robust application with that kind of professional reputation. I would like to see your product offering just for the sake of appreciation, and knowing...