Search results for query: *

Hey there all! I own both VB6 and VB.Net, but have a VB 5 project in which i need to modify the SQL table name that it writes to as this was, god knows why, hard coded into the form. I can happily change the code in the project using a text editor if needed but need to re-compile it into an...

Hi all, Sorry if this is in the wrong area but i could not find a SQL Server systems specific forum. I have just recently upgraded to SQL Server 2005 x64 bit system from SQL 2000 x32. I cannot figure out how to install the client tools (from the x64 CD's) onto my Windows XP (x32) desktop...

Hi all, I have been using the YTD() and PeriodsToDate() functions in MDX to create rolling Year-to-Date calculated members. My problem arises while trying to use the item(0).lag(1) code to try and get the same YTD() period for a year ago. The problem with using either the lag function...

Hi all, We have a site up and running which collects data from our technicians that are working 'on site' and was wondering whether i can run sql from my location to pull out/update the results. I can log into the website my techies set up to browse the data but am trying to set up an active...

Hey all,[wavey] I apologise if this question has already be asked. Im creating a pseudo add-in for excel which looks at the currently opened workbook and then pulls out most of the details such as sheet names, data ranges, headings, ... On my hunt for code to interact with excel i have found...

Hi All Im not sure if there is a previous post as am not sure what to search for. In my search i have not found anything of use so i apologise if i am repating someone elses question. [noevil] I am Linking/Importing (have tried both) to a text file source that i have tidied the formatting of...

Hi All! Wondering if you can help me get my head round the code for a calculated member that is a percentage of a fixed level within my dimension. What i would like to be able to do is work out the %age of the current level vs that of level 1 for it, but only if it has gone past level 1 (not...

Hiya all! [soapbox]**WARNING: ESSAY COMING UP **[soapbox] Ive been asked to add a 'Print All' button to one of my Excel workbooks and seem to be having some difficulties with the amount of pages/prints that i need to do. The workbook contains 18 sheets, 9 raw data sheets 8 charts and the...

Hey all! [wavey] I wonder if anyone out there could help me with some code for a voice mail system im developing for myself. I have an app which monitors the phone line and picks up when the call is left un answered for 1 min. It then starts to record to a wave file till the other end hangs...

Hiya all! [wiggle] I wonder if anyone could help me a problem i am having[curse]. I am trying to create a database which will sort through all the tables in it and give me a list of all the Linked tables and the database that they originate from. Is this possible? I am using a form with...

Hiya All [peace] I wonder if you can help possibly? I am trying to run a dos control then copy the created file to a new directory. I have the shell code, and the file copy within my code but cannot seem to get the filecopy to wait for the shelled window to close. Is the a wait function for...

[wavey] Hiya! I have been coding an automated system of creating Pivot tables and colouring certain lines on the report in VBA. I have managed to Create a document with accurate pivot tables and coloured the required lines. The problem i am getting is that when the data is refreshed on the...

[afro] Hiya all Im trying to write some code which will tell me how many products are within a selected range which is defined by the user. I can easily loop through all the records in a sheet to find out whether they match my criteria but am struggling with pulling out just a certain range...

Hiya all In my database i am linking to tables from external databases for criteria set up on a form editied by the user. My code can successfully link the tables but if it cannot find the requested table it crashes. I tried putting in the following error trap which seems to work for the first...

Hi all I just recently bough a p3 1ghz from ebay. I have installed it into my pc and attempted to turn it on but nothing happens. The pc comes on, The lights come on the hard drive clicks over but nothing from the bios no system reviews from bios or anything. Is this a bios problem? (it was a...

[wavey]Hiya all im using the vb function, open "c:\Example.txt" for input as #1 write #1, "Example" close #1 but if c:\example does not exsist it just crashes [cry]. how do i get it to create the file if it isnt there, this way i can write to variable filenames[licklips]...

Hiya All, Ive been playing with code in VB6 and have been using exactly the same code multiple times to accomplish exactly the same time and i feel it is just taking up space in my program. Is there anyway i can manipulate the Alphabet as a variable such as a number? E.g. 1 + 1 = 2 [Wink] a +...

Hiya All Is there anyway to list all the tables that exsist in an Access 97 database? E.g. Database: Weeks Tables : 26/03/02 25/04/01 ... and append each of these tables into a list box on a Form. Thanks in advance [wink] [pc3] Adam [glasses]

Hiya all, Would anyone know how to set up and use an array in VB? What i am trying to do is set up a 'phone pad' style Coding System. E.g. the Array would assign Letters to a Number: A,B,C ->2 D,E,F ->3 G,H,I ->4 etc. then to code an input string as numbers: Adam -> 2326 Thanks in advance...

hiya, Is there anyway i can change the default folder that outlook goes to when you go to add an attatchement to an e-mail. When i attempt to attach a file the open dialog box goes to c:\My Documents\ and i would like it to go to s:\shared. Is this possible? i have searched all ini files...