Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel variable usage??
I have no idea why but by asigning the complete .sql array string to the variable I can do whaterver I want so here is the solution...I can up with... sqlString = "SELECT " + datacat + ".`Part Number`, " + datacat + ".Description, " + datacat + ".`Qty on...- hd65
- Post #6
- Forum: Microsoft: Office
-
Excel variable usage??
SkipVought, using the * causes no errors but does not display any data?? here's another look at what I’m trying. maybe this will help... Private Sub query() SearchText = "'" + searchBoxtext.Value + "%'" If ActiveSheet.QueryTables.Count = "0" Then With...- hd65
- Post #4
- Forum: Microsoft: Office
-
Excel variable usage??
Here's what I have.. SearchText = searchBoxtext.Value With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DefaultDir=C:\newsystest;Driver={Microsoft Text Driver (*.txt; *.csv)};DriverId=27;Extensions=txt,csv,tab,asc;FIL=text;MaxBuffe" _ ), Array(...- hd65
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Excel macro Query questions
First..I'm new to VB and macros. And I'm just looking for some help to get started in the right direction. Here's what I'm trying to do. I have some CSV files that I want to query based on a user input in a textbox and I want the query results to be displayed in a combobox. I need this to happen...- hd65
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Listing excel sheet names
Hasit, Here is how I did it....May not be the best way or a way to share... but it works. Sub OK_Click() Dim sht() File = FilenameBox.Value + ".xls" Workbooks.Open FileName:=File ActiveWindow.WindowState = xlMinimized Workbooks(File).Activate i = 0 For Each wks In Worksheets ReDim...- hd65
- Post #4
- Forum: Microsoft: Office
-
-
Listing excel sheet names
I have a spread sheet with several sheets. I want to --From another excel file-- get all the sheet names and list them in a combo box via a macro. Is this possible?- hd65
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
-
Tk module geometry window size question
Hi, Here is waht I have: use strict; use Tk; my $mw = MainWindow->new; my $width = "1024"; my $height = "768"; $mw->geometry("$widthx$height+0+0"); $mw->title("WOProj"); MainLoop; The geometry line should make the window width=1024 height=768. but I... -
Printing the canvas--What am I doing wrong?
my bad... I was trying too may things..Here is a simple example of what I'm trying to do... use strict; use Tk; use Tk::Menubutton; use Tk::Canvas; my $mw = MainWindow->new; my $canvas = $mw->Canvas(-width=>200,-height=>110... -
Printing the canvas--What am I doing wrong?
Hi, here is what Tk::Canvas doc says; $canvas-gtpostscript(?option, value, option, value, ...?) here is what I have; use strict; use Tk; use Tk::Menubutton; use Tk::Canvas; my $wow = MainWindow->new; $wow->title("Printing"); my $wocanvas = $wow->Canvas(-width=>200,-height=>110... -
-
Help with hash/database
Hi, I don't have any problems using hashes... the problems start when I try to tie the hash to a dbm file and add, edit and read from the file using MLDBM. I've read the MLDBM doc over and over yet still can't get it. thanks paul -
Help with hash/database
tsdragon, First, thanks for the ideas. Second, "not too large"??? it may be rather large but it may not be changed very often. All the values will be user inputs, basicly the database will be built by the user.Can that be done with the *.pl file method? I have other items to work on... -
Help with hash/database
HI, I can’t figure out how to do this: I need to build a database like this, key = colors=> color1 => red color2 =>blue color3 => black ect… key = shapes=> shape1 => oval shape2 => square shape3 => circle ect… ect... I need to search on key and return each item separately when... -
Cookies
Ok I spent a little more time checking this time I've removed the getCookie function and changed the ckCookie function. here it is //Start of cookie data expireDate = new Date expireDate.setYear(expireDate.getYear()+1) function setCookie(n , v){ var cookieStr = n + "="+ v...- hd65
- Post #6
- Forum: Javascript
-
Cookies
first if you want the cookie values to display when the page is loaded use <body onLoad=ckCookie()> so with that in mind here's what I changed. <html> <head> <title>Untitled</title> <script language=JavaScript> //Start of cookie data // Add from here------------------------- function...- hd65
- Post #4
- Forum: Javascript
-
Cookies
here's how I would do it. <script language=JavaScript> //Start of cookie data expireDate = new Date expireDate.setYear(expireDate.getYear()+1) function setCookie(n , v){ var cookieStr = n + "="+ v document.cookie = cookieStr+";expires=" + expireDate.toGMTString() }...- hd65
- Post #2
- Forum: Javascript
-
Can I use a loop?
No........ but if you think of anything just let me know if not thats ok too. paul- hd65
- Post #9
- Forum: Javascript
-
Can I use a loop?
Thanks I'll have to look at the other scripts to see if I can find a way to set somenumber. thanks again. paul- hd65
- Post #7
- Forum: Javascript
