1 Resources for

long strsql

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

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

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

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
strSQL = "Insert into ActivityTest Select * FROM OPENROWSET": can u explain this,plz; Tags: mail2aashutosh@...; Discussion threads 2007-04-01
Problem with SQL Query in Visual Basic: The following query works if I remove the "tblLocations.PrimaryFlag=-1" from the WHERE statement. I wanted to see if anyone could tell me what I am doing wrong. I have also tried "tblLocations.[PrimaryFlag]='-1'" and "(((tblLocations.PrimaryFlag)=-1))". I need to be able to filter for records with a -1 result for...; Tags: Microsoft Visual Basic, programming, SELECT tblCustomers.CustomerID, strSQL, tblLocations.PrimaryFlag, tblLocations.PrimaryFlag=-1, twhite@...; Q&A 2005-09-14
Save time by using WordPad or Notepad for big SQL edits in Access 97: If you or your users use SQL to query Access 97 tables, Peter Nelson has a tip that's guaranteed to help save you time and trouble.Access developers aren’t born; they have to learn by paying their dues. One time-saving tip that I like to teach students who are on the...; Tags: Databases, Programming languages, Microsoft Office, Peter Nelson, strSQL, strDate, SQL, Microsoft Access, Microsoft Access 97; Technical articles 1999-11-23
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
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
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
Combo Box Trouble: Hi guys,Here is code I am using to populate a combo box from the table. Set cnnConnection = CurrentProject.Connection Set rstRecordset = New ADODB.Recordset strSQL = "SELECT * FROM Country ORDER BY Country" rstRecordset.Open strSQL, cnnConnection, adOpenDynamic, adLockOptimistic...; Tags: carterlangley@..., id; Discussion threads 2007-04-02
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
TWO LONG in Oracle: Hello,For Oracle 8i it is true that One can not use two LONG column in a table.Is it true for all new versions of Oracle or any new version provides such facility ?Anyway, Is any other way to use two LONG column in a single table ?Please, Answer my doubt.Switch...; Tags: Divyesh, LONG, Oracle Corp., programming; Q&A 2005-04-13
VB.NET Access DB DataSet problem: I'm developing a VB.NET 2005 application with an MS Access backend. The Queries for the most part are "LIKE" queries, and they will not return rows in the application when querying in Access I return rows. When I run a "=" query I return rows from the application...; Tags: Microsoft Office, Databases, Programming languages, .NET, culbysl@..., Microsoft Access, Microsoft Visual Basic.Net; Discussion threads 2007-09-01
Build a data-bound grid with C# and ADO.NET: Data access is the basis of any application. In thisarticle, I will show you how to access SQL Server-based data using C# andADO.NET, as well as how to display the data in a data-bound grid control. I usea simple C# application as an example.ADO.NET architectureADO.NET allows you to work without...; Tags: C#, data access, data source, grid, Irina Medvinskaya, Microsoft ADO.NET, Microsoft SQL Server, namespace, server; Technical articles 2006-08-30
A simple solution for tracking changes to Access data: This article is also available as a PDF download.Your data is important. In fact, it's critical to yourbusiness. Entering, storing, and maintaining valid data is the most importantjob of any database. When you're the only one using the database, you can limitmistakes. However, when multiple users are changing data, a...; Tags: Microsoft Access, Susan Harkins, audit; Technical articles 2007-03-13
How do I... Dynamically fill Microsoft Word fields using Access data?: This blog post is also available in PDF form as a TechRepublic download. The download includes a sample Access database and Word form.Each Microsoft Office application specializes in a specific job. Word lets you create and edit documents and Excel analyzes your data. Storing data is Access' claim to fame....; Tags: Microsoft Word, Microsoft Access, Data, Field, Microsoft Corp., Form, Susan Harkins; Blog posts 2007-08-23
VB code office 97: I am new to a company and they have a program written in office 97 and we want to change the code so it is written in office 2003. It crashes if the end user does not have office 97. I am networking guy so I am not sure how...; Tags: Fax, Microsoft Visual Basic, bsl@..., F24, F23, F17, File1.path, F18, F19, StatusList.AddItem InputFile, FileFromCommerce.Text, StatusList.AddItem, F22, Input #1; Discussion threads 2007-07-25

<< Previous
page 1 of 1
Next >>

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now

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