On GameSpot: Wii Fit tells 10-year-old she's fat
4 Resources for

dim strsql

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Somebody pls help!!!!!! MS Access/VB6.0 query problem
Can someone help me pls. I'm developing an application for my small travels and tours agency that will handle the personal information and reservation requests of customers. I want a situation where when I click the view reservations button from within the customer page, the "Reservation form" will load and...
Tags: Programming languages, Scripting languages, Databases, Microsoft Corp., deyshele@..., reservation, Dim strSQL, cusIdNum, customer id, CusIDval
Discussion threads 2007-09-16
Adding items to the subitems in a listview in VB 2005
Hi thereBelow is some of my code in VB6 that use to add items to a listviewwith subitems:The listview is called lstvCustomers that gets data from a Access DBI know how to access data from access and I know how to add the datain the 1st columnmy problem is adding...
Tags: Microsoft development tools, Programming languages, rieda@..., SubItems, listview, Dim strSQL, VB 2005, Microsoft Visual Basic
Discussion threads 2007-05-10
Upload .xls file to SQL Server table w ASP.NET app
Here's what I have to do: 1. Allow user to locate a .xls file on their machine 2. Upload this .xls data into an existing table on a remote SQL Server I can pull the file from my local machine to another directory on the local machien, but...
Tags: chip@..., database, Dim strSQL, Label2.Text, local machine, Microsoft ASP.NET, Microsoft SQL Server, programming, server, software
Discussion threads 2005-08-09
how do i use rs!field in vb.net
is there anyway i can use rs!field (ex: rs!customer_id) in vb.net.when i code it in VB.netdim str as stringset rs = new adodb.recordsetdim x as singlestr = "select customer_id from person"rs.open str, dbconn, 3,2x = rs!customer_id ''' this is error it says to many arguments..how do i solve it in...
Tags: Console.Write, DataReader, Dataset, Dim strConn, Dim strSQL, Microsoft ADO.NET, OLEDBCommand, OleDbConnection, plr007, programming, ToString
Q&A 2005-05-04

Additional Resources

Acess VBASQL UPDATE STATEMENT ERROR
I am trying to update a table in acess 2000 n I keep getting a syntax error. Can someone please help. I have been looking at this for daysnot kidding. The only thing that I notice is that the compiler keeps changing some of my field names although they are...
Tags: acessvbasqlnewbie, strSQL, Me!
Discussion threads 2007-04-17
Excel UPDATE to MS SQL having Run-time error
Hello All,I am very new to excel, VBA, and SQL although I have had programming experience, it has been a long time ago.I have created a form in excel to be an invoice. I have a MS SQL database that contains the customer info. I have completed the portion...
Tags: Sales strategy, Sales force management, sales, rtfentem@..., Microsoft Excel, strSQL, Sales Invoice, Worksheets
Discussion threads 2007-09-21
MSAccess Refresh Active record
Hello all. I would like to ask if anyone knows how i can refresh my form without the focus being changed to the first record, essentially refreshing the form and subform while keeping my cirrent record as the active record.I am entering data into a form, I have a command...
Tags: jim@..., Dim Buckets
Discussion threads 2007-07-17
Displaying file properties from within VB6
over my headI liked the concept, but the description was far too deep into geekspeak for it to be usable for me. I don't do heavy programming in VB6, just complex macro work in XL. Would've needed to hold my hand, explaining each piece of the coding, for this to...
Tags: annmarie.cross@..., CStr, file properties, fMask, Long strSQL, lpVerb & vbCr, Microsoft Visual Basic 6.0, nShow, programming, ShellExecuteEx shInfo strSQL, String, String strSQL, strSQL, vb6
Discussion threads 2005-08-19
Problem with MS Access 97 SQL query.
Can someone help me pls. I'm developing an application for my small travels and tours agency that will handle the personal information and reservation requests of customers. I want a situation where when I click the view reservations button from within the customer page, the "Reservation form" will load and...
Tags: Databases, Microsoft Corp., deyshele@..., Microsoft Access, reservation, customer id, cusIdNum
Discussion threads 2007-09-12
About sql server 2k trigger/procedure
When a table is modified, I want a trigger to export the data of table to a file,such as *.txt or other. I have tried to realize that by using following codes, but failed. create trigger tr_ActionLog on ActionLog for update,insert, delete AS SET NOCOUNT ON --declare @strSql varchar(255) exec dbo.ExportData2Csv 'liulzh',...
Tags: Databases, @strSql, ActionLog
Q&A 2005-06-01
Error 1026 Using SHFileOperation
I am using SHFileOperation to copy some files from an Install CD to the Target folder. The program works fine on W2K and XP, but under W98, I get a File System Error (1026).I know that this Function needs to have the Null characters added properly, & I have done...
Tags: Error 1026 Using SHFileOperation, Long Dim, icscomputersaz@..., programming, SHFileOperation, String, String Dim
Discussion threads 2005-01-26
strSQL = "Insert into ActivityTest Select * FROM OPENROWSET"
can u explain this,plz
Tags: mail2aashutosh@...
Discussion threads 2007-04-01
VBA Expert..urgent help
****** Following code giving run time error 438 *** how to fix that error..pls help..its urgent'Dim Cell As RangeDim myWord As ObjectDim PathDocu As String Set myWord = CreateObject("word.application") 'Set myWord = GetObject(,
Tags: fanku@..., myWord.ActiveDocument.Bookmarks, programming, software, VBA
Discussion threads 2006-11-03
VBA Expert..urgent help
****** Following code giving run time error 438 *** how to fix that error..pls help..its urgent'Dim Cell As RangeDim myWord As ObjectDim PathDocu As String Set myWord = CreateObject("word.application") 'Set myWord = GetObject(,
Tags: fanku@..., myWord.ActiveDocument.Bookmarks, programming, software, VBA
Discussion threads 2006-11-03
My autologon script won't when scheduled to run at startup.
I am using the following script to auto logon about 20 stand alone xp workstations not attached to a server which all have deep freeze installed on them. I need to be able to auto logon to the workstations so I can run applications. Does anyone know a way I...
Tags: bigdog4579@..., RegLocAutoLogon, REG_SZ
Discussion threads 2007-06-28
Dim the variables
In VBA under Access (A2K) when IDim myStr AsString------------^- no space as you did in your code listing - it throws a error. Same for your second variable
Tags: Scripting languages, ray.learmond@...
Discussion threads 2007-05-18
monitor is dim
I have a HP ZV5000 pavilion laptop. When the a/c adapter was plugged in, the screen was bright and if I worked directly off the battery the screen would be dim. Now from out of nowhere, when the a/c adapter is plugged in, the screen is very dim...
Tags: dlwojo@..., monitor, A/C adapter, A/C, adapter
Discussion threads 2007-08-29
urgent help from VBA Expert
'Dim Cell As RangeDim myWord As ObjectDim PathDocu As String Set myWord = CreateObject("word.application") 'Set myWord = GetObject(, "Word.Application") Set myWord = GetObject("g:globalmaheshoffer letter.doc") myW
Tags: fanku@..., myWord.ActiveDocument.Bookmarks, programming, software, VBA
Discussion threads 2006-11-03
Commondialog in VB6
how do i use commondialog in VB6 for the openfiledialog function?I tried to program it as below, but didnt work.Dim openFile As New Commondialogcommondialog.showopenbut I do not get commondialog class from IDE and get a syntax error at the Dim openfile.... line-TIAMparamDIM var as New typevar.methodas inDim MyLabel as New...
Tags: Label
Q&A 2005-11-03
How can I schedule a autologon script to run at a specific time and date
I have the following script that I need to run at a specific time and date. Can anyone help me with this? Here is the script.Option Explicit'''Declarations'''Dim objShellDim RegLocAutoLogonDim keyDefaultDomainNameDim valDefaultDomainNameDim keyDefaultUserNameDim valDefaultUserNameDim keyDisableCADDim valDisableCADDim keyAutoAdminLogonDim valAutoAdminLogonDim keyForceAutoLogonDim valForceAutoLogonDim keyDefaultPasswordDim valDefaultPassword''''Define keys and values''''RegLocAutoLogon = "HKLMSoftwareMicrosoft" & _"Windows NTCurrentVersionWinlogon"keyDefaultDomainName =...
Tags: bigdog4579@..., RegLocAutoLogon, REG_SZ
Discussion threads 2007-06-28
  • << Previous
  • page 1 of 1
  • Next >>


Windows XP vs. Mac OS X
This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...
Buy Now
Quick Guide: Windows Group Policy
One way for help desk technicians and network administrators to reduce help desk calls and protect their networks is to limit the damage curious users ...
Buy Now

The PC Cracked Open