Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- ACCESS-VBA dim as databsae
- I have a module that I am trying to create. I am trying to use a table to hold some varibles. It says that I need to dim a varible as Database. The Database option is not availible on my system. I am using Office XP Pro. Do I need...
- Tags: access, DAO, database, GW0001, Microsoft Access, software
- Discussion threads 2005-07-14
- Using Access 2000 and VB 6
- I am writting a program using Visual Basic 6. I am trying to read data from an Access 2000 database. I have created a blank form, added the data tool, set the connect property to access, set the DataBase name to point to the database. When I try to set...
- Tags: DAO 3.51, database, DHamblet, Microsoft Access, Microsoft Visual Basic, Microsoft Visual Basic 6.0, programming
- Q&A 2004-11-17
- DAO Advanced Programming
- Data Access Objects, or DAO, is a powerful programming model for database services. DAO is implemented as a hierarchy of objects and collections. Each of the object types is represented within this hierarchy. DAO allows you to create new objects, and modify existing ones.
- Tags: Hierarchy, Programming, DAO, Development Tools, Storage, Databases, Software Development, Software/Web Development, Hardware, Enterprise Software, Software, Data Management
- White papers
- Edit an Access Database from Excel using DAO
- Can anyone help me edit the following code so that I can use an excel row to edit an access database. The code is to be put in a Macro and used via command button on excel worksheet.Dim dbMyDB As DatabaseSet dbMyDB = OpenDatabase("C:Pro.mdb")Dim rsMyRS As RecordsetSet rsMyRS = dbMyDB.OpenRecordset("Customers",...
- Tags: Access Database, database, DAO, Range, Feild, ninedemo@..., programming, Microsoft Access, Microsoft Excel
- Q&A 2006-08-12
- 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
- Error installing C++5.0 DAO Components
- I am trying to install C++5.0 on a Dell laptop computer running XP Home SP2. The installation seems to run fine until attempting to install DAO components. The error message simply reads that there was an error and that I should try to install DAO from the DAO...
- Tags: C++5.0 DAO, DAO, Dell Computer Corp., Error, lissey70@..., software
- Q&A 2005-05-01
- Linking VB with SQL Server
- Im trying to link VB to an SQL database.Any code samples will be welcomedownload the code from vbcodes.com or codeguru.comTake a look athttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_dataaccess.aspHi,To connect VB with SQL You just need few lines of codes..i'll give you hints,,1)first define connection with passing necessary parameters2)Then define a command or you can use...
- Tags: chikukwa@..., Microsoft SQL Server, Microsoft Visual Basic, programming, server
- Q&A 2005-02-08
- Sql Quriery in Visual Basic
- Software DeveloperADODBYou need to use ADO DB ActiveX Data Objects components to use sqle.g.Dim con as new ADODB.ConnectionDim cmd as new ADODB.CommandDim recs as new ADODB.RecordsetSet con=Open "connection string"cmd.ActiveConnection = concmd.CommandText="Select * from MyTable"Set recs = cmd.Execute
- Tags: Programming languages, amolsuryansh@..., SQL, Microsoft Visual Basic
- Discussion threads 2007-10-03
- Find Similiar MS Access Records
- When I try to execute the following VB I get a complie error:Invalid use of key word meCan any help?ThanksPrivate Sub cmdProcess_Click On Error GoTo err_end Dim conn As ADODB.Connection Set conn = CurrentProject.Connection Dim ssq1 As String Dim ssq2 As String Dim ssq3 As String Dim rs As New...
- Tags: access, find duplicates, Firstname, InStr, LastName, me, programming, rs.Fields, rs2.Fields, shieldsco@..., similiar records, software, vb
- Discussion threads 2007-01-11
- Visual Basic: Connect to a teradata database from VB
- Hi all!!!I am quite new in Visual-Basic and i am trying to establish a connection with a Database Teradata using an ODBC connection, my code es the following:---------------------------------------------Dim qdfTemp As QueryDefDim rstTemp As RecordsetDim dbs_cls_tbug As DatabaseSet dbs_cls_tbug = OpenDatabase("dwht1", False, False, "ODBC;DSN=dwht1;PWD=ex0n3") Set qdfTemp = dbs_cls_tbug.CreateQueryDef("")qdfTemp.sql =...
- Tags: 472955@..., database, Microsoft Visual Basic, ODBC, ODBC Driver, programming, teradata connection, visual basic
- Discussion threads 2006-10-23
- visual basic challenge
- hi, i am developing a application in which i want to give a area in which user can draw a image and sava it to database with its id.please solve my prblem as soon as possilble.use the doodle example that comes with VB and study up on ADODB. here...
- Tags: Doctor List, String Dim, sudeep_395@..., programming, String
- Q&A 2005-03-19
- having problems when logging on
- i am getting a "method connetion of object_ current project failed" on the following liners.Open str_sel, CurrentProject.Connection, adOpenKeyset, adLockOptimistic when i want to logon to an Acces database. this is happening on some XP and Access 2003 and running on other machines. HAve installed Mdac2.8 but its not working.Below is...
- Tags: panx@..., Payroll Logon, MsgBox, payroll
- Discussion threads 2007-04-17
- 10+ mistakes to avoid when using VBA Recordset objects
- The Recordset object is an essential component in Access development, but it often trips up even experienced developers. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and avoid. by Susan Harkins
- Tags: Method, Property, Microsoft VBA, Library, Data Access, Record, Error, Susan Harkins, ActiveX Data Objects, EOF, RecordCount, MoveNext
- Blog posts 2008-06-25
- Access reports through VB6
- I am wanting to create dynamic reports by passing a SQL string from VB6 to an access query and then calling a MS Access report from VB6 that is linked to the query I have just passed through. Is this possible and if so can someone please provide me...
- Tags: Dim objConn, matthewdeas@..., Microsoft Access, Microsoft Visual Basic 6.0, programming, Value at Risk
- Q&A 2004-10-18
- 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
- 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
- Access database update
- I want to update just one field in one record in an access database. I work in asp.Thanksuse recordset with updatedefine a recordset object by quoting a select statement from SQL. Update the recordset with the new value.
- Tags: Databases, Storage, raudet@..., database, Microsoft Access
- Discussion threads 2007-08-23
- MS Access
- I had to create a db with a 1:many relationship of date:on call personnel. short date formatI used a wizard to create the form that is to be published for use throughout the building. On Open, the date is always 1/1/2005; I want the form to consistently open to today's...
- Tags: cp03246@..., Microsoft Access, Microsoft Corp., MyDate, software
- Q&A 2005-03-24
- Access Database
- How do i connect to an access database from VB6?There are several ways (ODBC, DAO, etc). The problem is that it depends on the Access version and VB6 service pack. Which Access do you need to connect to?It will be an access 2000 database i want to connect to. I...
- Tags: Databases, database, Microsoft Visual Basic 6.0, Microsoft Access
- Q&A 2005-06-09
- << Previous
- page 1 of 1
- Next >>
