Recent content by GummowN

Tried contexts and it doesnt work either :( 2 of the N tables are just Dimensions - and 2 are a mix of dimensions and measures. When I have returned 2 of the N tables - when I select one field from a table - the others from the other N table appear in italics and are kind of greyed out. Are...

Our universe consists of 1 header table and 4 joined tables (with 1-N relationships to header). When I try to validate the universe - in terms of being sufficiently user friendly for non-technical staff - I find there are problems in adding columns from 2 of the N tables. It is possible if I...

Or in other words a left outer join! I have a table where I want the count of the records and another where I want the sum. However not all records in table 1 have records in table 2. The universe has an outer join set-up. But when I create the report the count results are as a inner join...

Thanks - I had to use that method in the end!! If at first you don't succeed, try www.tek-tips.com for the answer.

I am using Access 2003 References VBA Access 11 OLE Automation DAO 3.6 ADO 2.1 Background I have a form from which I kick off another form - which then requeries the original form. I want to store the bookmark and then return to it when the kicked form closes So when the form opens I store...

Sorry: 1) VBScript running as part of DTS package on SQL Server 2) This is not the original code - all the Msgboxs have been added to figure out WTF is going on. Thanks If at first you don't succeed, try www.tek-tips.com for the answer.

See the below code The Msboxes do kick up 3709 and the usual error description Set mcnn = CreateObject("ADODB.Connection") Set pkg = DTSGlobalVariables.Parent Set tsk = pkg.Tasks("DTSTask_DTSExecuteSQLTask_11").CustomTask Set fso = CreateObject("Scripting.FileSystemObject") Set wsh =...

That will do the trick then!! If at first you don't succeed, try www.tek-tips.com for the answer.

I know next to nothing about JS but would love a bit of help to overcome a small problem Currently mailto:thursday_footy@footylist.info?subject=Footy: Thursday dd-mmm-yyyy&body=Update dd-mmm-yyyy above and send this with a short message, if you wish. Note: if you're not already...

Thanks for that. I have managed to go 9 years without ever having to use Sel.... functions. And until I am sure I could have gone another 9!!! A bit tidier then my Copy/Paste hack I wrote! If at first you don't succeed, try www.tek-tips.com for the answer.

I want to know whether it is possible to pass a highlighted part of a text box as a variable eg This is a textbox with some text in it. Lets say "textbox with" is highlighted, you right click and select "Custom Action" a Msgbox popups with "textbox with" Any suggestions outside of using the...

I tried the (0) thing and it didnt seem to work my end. I ran out of time to look any further yesterday If at first you don't succeed, try www.tek-tips.com for the answer.

OK - this is interesting - with the filehandle I try getting a filesize - and get back -1. I am going try some stuff tomorrow with file handles that are set to read - see if I can read from a file AND also get file properties from the handle. I even tried passing a fixed piece of text much...

I have made progress of sorts. If I upload a file to the ftp server manually containing data - then run the code - reopen the file - it is blank - so the process is opening a new file even when one exists. I have found suggestions that InternetWriteFile always returns 0 but no definitive...

My idea is a table like this: Report; User; Time; Ran When the user prints a report - from a custom button in the database - it inserts the report name, user, time into the table. Every 10min the form clicks into a timer event - it opens a recordset for all records in the table where Ran =...