Search results for query: *

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 =...

Just as I got the mail I got the code working - by which I mean not working IE getting the same behaviour as you. I have been working for the last 9 hours without a break so the mind is not totally focussed I will get back to you a bit later if I have any luck If at first you don't succeed...

More dumb questions - but this is far from a simple fix question is it? When it fails what is BUFFER_SIZE? What is iWritten? What happens when you step through the code? It should fail with an error message ie GETLASTERROR - but what does it do? With the open file, can you - close it? get file...

So it is failing to write the file to the server - well the chunk of the file. The logic of your function appears valid and sound (as you say) which would suggest that something is not as it should be, by which I mean a variable. Is Getfile returning a valid result? What have you tried doing...

It doesnt have to be the server just one machine that has distiller installed that is always on, with the database always running. If you think it will help play about with the concept. There maybe a way of piping the result but I have not seen or used one. If at first you don't succeed, try...

Why not force the file to save as a certain filename - open it using the excel object, hide teh columns, save it again and then leave it open for the user. You could even have cell A1 contain the filepath of the file so the user knows where the file is. 99% of my exports are generated into...