Search results for query: *

Hi all im trying to find the first friday in specified year / month . The code below adds 6 days on but i think im interperating the DateInterval.day wrong. [code] Date_CurrentFriday1 = Format(DateAdd(DateInterval.Day, FirstDayOfWeek.Friday, DateSerial(RDyear, RDmonth, 1)), ShortFormat) [\code]

Hi all I know its friday and I have a question on searching I have inherited a large DB , and want to find any tables that have the value '161941' in any of the cells , is this possible to do (relitively) simply Many thanks C

Hi all , relitivly new to SQL and i have made this so far .... select a.project , a.department , count(a.department) from atsproject as a join acrclient as b on b.municipal = 'Y' and b.client = a.client where a.project = 'ECP12674' group by a.project , a.department order...

Hi all , This is the first time i have ever tried to add into a menu option in a microsoft application. I want to add an option in outlook 2003 , when you right click on a resolved name, in a email. Two things i would like to know how to do 1) I want to be able to return their first and...

Hi all I have never really come across Digital Signatures before , but I have recently modified a modules in excel and need to re-add a digital signature to it , I have been given two files LC2006.spc mykey-2006.pvk and a pass phrase for one / both ?! I am assuming that I need to add a...

Hi all I have a workbook and a custom menu with two buttons on it , Works great , but when i open on a different machine the bar is there but no buttons . How do i get the buttons to say ? Many thanks in advance. Chris

Hi All I have a function that ftps a file from a to b , the issue im getting is when the file path is larger / has spaces I think as an example "C:\Program Files\File Program\Upload" - Errors because of spaces I think "C:\Upload" Works fine. My Question is how can get the Longer string...

Hey all I have a recordset and want to know how many columns are in the returned query. This is what I have already 'connection String to ALPHA server cst = "Driver={SQL Native Client};Server=ALPHA;Database=HPR;UID=Admin;PWD=wooyay;" 'Set connection as ADODB Set cn =...

Hey all I have a 'int' that i want to parse to the 'ThisDocument' vba area of a word doc. Private Sub Document_Open() ActiveDocument.MailMerge.DataSource.ActiveRecord = {myInt} End Sub Please can anyone help in opening the document via vb6 and parse the var and how can i represent...

Dear all I want to export a table (SQL 2005) to Excel (2003) I have tried to use the code below insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;', 'SELECT * FROM [sheet1$]') select * from dbo.test_table but get this error Msg 7399, Level 16, State...

I have a program that creates lots of data and I want to have a automatic clearing function. I want to look for specific folder say the root is "c:\program files\MyProgram\" Then I want to delete any folders (and their contents) within this directory with the word "Output" at the start EG...

Hi all I have this code Im trying to open the path "C:\Program Files\File Capture\Outbox-" (then a named folder say 'John') and open it in a windows explorer. the Code below bombs with a run time error "Method 'Run' of Object IwshShell3 field" HLink = "C:\Program Files\File...

I have the statement . . . select member_key ,pre97vfm ,dqsf ,pre97incind ,pre97penatnrd from tid order by member_key which returns 16.0 NULL 1974-07-01 NULL NULL 20.0 318.798 1983-07-11 NULL NULL 23.0 8304.88 1971-08-26 NULL NULL 30.0 2487.11 1980-09-15 NULL NULL 38.0...

Hi all I am trying to convert a Access Query into SQL 2000 (using Query analyzer) . In my old query i use dateserial(yearvar,monthvar,dayvar) I have recreated the variables but now need some function to get them together as a date. Is there anytype of function i can use. Much thanks in...

Hi all I am trying to convert an access JetSQL query into a shiny SQL one. I am having trouble with if statements This is the access version (to compare two days) IIf(Left(doc,2)=Left(djs,2),True,False) AS sD I want to compare @dCalc_date = dDJS and output on the end of the grid so far...

I am merging addresses to a label printing sheets. (4 labels per sheet) I have the name and address merged for the first label. How can i make the next label the next record ? it is the same as the 1st at the mo ? Thanks in advance Chris

I would like some help in making a file listing on a ftp folder, i want to run this type of thing (below), but from my pc and run it on the ftp folder on the remote computer. dir = c:\ do while fil = "" ' Stuff dir = fil loop

Hi all i wish to connect a PC to a LCD tv , is there a pysical limit to the length of a VGA cable ? I would need about 10 metres ? and where would the cheapest place to get one ?

Hi all I have this query SELECT a.MEMBER_KEY, a.CONTS, a.DST, a.DEND FROM CH AS a ORDER BY a.MEMBER_KEY, a.DST; I want to add a autonumber to it in the query stage , is this possible ? Thanks in advance C

Hi All I have a EXE file which users can use from home , via terminal services , Which works every other time you connect to it via Remote Desktop Connection. The message you get when it doesnt work is as such : The system cannot fint the path specified This initial program cannot be started...