Recent content by captnk

Good. Glad to hear u resolved it.

Its a couple of years since I moved from Office 2007 to 2010,but I know when I did running some text import Macros that I had used since office 2003 became problematic in Access 2010. There are a number of articles on the net with problems running some macros in Access2010. In the end I moved...

The problem could be in "Windows " itself with the security settings I have had a similar problem before Go to : Control Panel /Action center /Change user Accounts Control settings and pull the slider down to the the bottom "Never Notify" Hope that helps Captn K

Ok no responses,but after a lot of research finally located the problem with 2010. The solution was: Go to Excel options/Advanced. Scan down to "General" Untick "Ask to update Automatic Links" Save For whatever reason it wasnt necessary for that to be "Unticked" in the 2007 version.

I have been evaluating a move from Excel 2007 to 2010. (32bit) When I run a macro in 2010 I keep getting the message "This workbook contains links to other data sources, Update/Dont update/Help" I have ticked "enable all macros" in the macro section of the "Trust Centre" I have ticked "enable...

I use the command line version of 7za (7za.exe),to extract some data via macros into Msaccess. Currently in Windows 7 32bit I have 7za.exe in the windows system32 folder so that it is simply called in the macro by just using "7za.exe e...etc" Im about to move to the 64 bit version.(Windows 7 pro...

I receive some data in LZH format (No choice on format) which has worked satisfactorily for years using .LHA or LHARK in a batch file. eg:d:\Directoryname\RBLHA\lhark e c:\download\Filename -o d"\Directoryname\RBLHA Ultimately the extracted file gets imported into MSACCESS This works fine in XP...

Many thanks guys I appear to have resolved the problem by changing the format "General Number" to "Standard" Decimal places was left on "Auto" And a very "fractional" increase in column width to fit in the fourth number Captnk

I have been running Office Xp for years. In one (Access) application/form I have a small field that only shows the the first 4 numerals such as 26.46 Of say 26.46789 Decimal places is just set as Auto but the field is only wide enough to display the first 4 numerals No prob However in trying...

Running SP2.

I have been experimenting with Access 2007 using Windows 7 It takes a long while to close the current existing screen and open the new one (Some macros/script run on exit) In Office XP/Windows XP the close/open was almost instantaneous but in 2007 it takes ages to run the existing data before...

Many thanks for the help guys. I have it working now. (Now to press on with the next bit) Regards

Is there a way to find the DATE of the FIRST SUNDAY in OCTOBER in a query. (Australian daylight saving commences on the first sunday of October in any year so it is a variable) Sure the PC time calculates ok with the various MS updates,but I need it to apply to existing data in an access table...

Tks chergh ! I have been a way a few days and just back,so I will have a look at yr idea regards

Incidentally I should probably explain thats its in that format,"data1","","","data2" etc,because I actually mostly buy the source data,and its in that format. So all my developement has been based on using the commercial data. All Im trying to do is build up an alternative source for getting...