11,868 Topics
![]() | |
I want to upload a text file to a access database, but the string does not work. I guess the problem is with the quote marks or something of the sort. The string is as follows: rs.Open "SELECT * FROM [" & Me.Text1.Text & "] ", objConnection, adOpenStatic, adLockOptimistic, adCmdText … | |
[CODE]Private Sub Command1_Click() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New ADODB.Connection Set rs = New ADODB.Recordset On Error GoTo myerror cn.Provider = "Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Main.mdb;Persist Security Info=true;Password=123456789" cn.CursorLocation = adUseClient cn.Open rs.Open "SELECT * FROM BA_Data", cn, adOpenKeyset, adLockOptimistic, 0 MsgBox "Total … | |
First of all I know this has been asked several times before but I cannot get mine to work. Anyway, on the developer computer I have created a Class Library that contains COM classes. I have also created an Excel 2003 Addin that references the .tlb file that is created … | |
how can i use notepad as my database and how can i search a list of data, compute numbers inside the notepad and how can i align some list of data in the textbox??? | |
[B] I use vb with Access. I have 2 tables table1 & table2 i create a data report showing the data from table1. My aim is to display the data from table2 on the same report in its next page(s). any kind of help, suggestions will be highly appreciated. with … | |
Hello, I have been trying to migrate some code I have written so I can use the advantages of Collection items in several forms I programmed in Access 2002. I was using an array list to collect information from a machine part and its resulting defect, then display a small … | |
i have developed simple system with ADODB connectivity n with some of components inserted like MS MaskedEdit control, or Crystal report control n then after installation of Windows 7 i tried to run some of my Program then my all other program run well with all components added but in … | |
I am using w2k, vb6, VBOLock and access 2000. I created a program that at first ran OK in VB and the compiled EXE. Now when I compile and run the EXE, I get a run-time error '53' file not found. I have checked and rechecked the code for accuracy … | |
Can anyone help me with this program? Example: I have 100 images in one folder named "Photos". All the files are sequentially named. I have subfolders under the "Photos" folder. Can a program be written wherein I am prompted to enter the file names, (for e.g. 01.jpg, 02.jpg, 03.jpg....) and … | |
Hello plz any 1 tell me how to use ListView Control n how to set/work it to user side (as its respective file also needed there at same location) n how it can reflect after making program setup exe file n to insert it in my program ? | |
Can VB be of any use in game development. I have a VB software and have been trying to know how to use it better I know someone knows better.Advice pliz.. | |
![]() | Hello everyone My request is the following: Do anyone know about a collapsible panel that can be used on a windows forms project? Thanks for any answer ![]() |
I am new to programming but when I took my class on Visual Basic it seemed so easy and I learned it so fast. It seemed like a giant puzzle. Now I am taking a introduction course to C++ and I cannot seem to grasp the material at all. When … | |
NEED HELP !! Is it possible to run a DTS package( which has been saved as VB file) on a remote computer which does not have the SQL server installed? If yes, could u pls tell me in detail? I have searched a lot of inofrmation on internet like registering … | |
Is it possible to rewrite the following VB.NET code in VB6? [CODE]Dim Names(,) As String = New String(,) {{"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, … | |
I am updating an Access 97 DB w/ VBA code to Access 2007. The VBA code uses DAO objects that Access 2007 references when I converted the db files (first from 97 to 2002, then to 2007). My problem specifically is with the two references: "Microsoft DAO 3.6 Object Library" … | |
Hi, I am writing a program in Excel Macro, where I need to create an array and then have to check wheather an element exists or not in that array. I have created the array as follows - Dim tmpArr(1 to 10) as Integer tmpArr = Array(2,4,6,8,10) Now, i can't … | |
hi can you please help me with my project??? it is all about on making a map of the realty houses...and i dont have an idea to do it.. my teacher said..the concept is when you search the person his/her house will zoom in..please help me... | |
is there a way to take data from msflexgrid and put it into a ready made excel file(meaning some boxes in excel is already filled)? And it is put into some specific place in the Excel template. Data from MSFlexGrid-->Excel Template. Thank you. | |
Hiiiiii. this is asweta here . can you suggest me topic for my project on VB . i am 3rd sem IT engg student | |
at a current project I was ask to provide a native access using Visual Basic and the Btrieve API. Since there isnt any actual sample at the website availabel ([url]www.pervasive.com[/url]) I thought posting it might help some of you. You can find sample code but almost all of them using … | |
I am using a Data Environment to create a data report. The code is working fine in one app, but after I copy-pasted it to another app, it's giving problem. Both apps are similar and have same references and in same sequence This works fine (in App # 1) [code] … | |
Hi I am Tarun Gulati. I have lunch a new SMS Social Networking Site.I need some help every people.so please guide me.How can improve in my site feature.Please give me your suggestion. Thanks Tarun Gulati | |
You can found Source code, tips and trick vb6, tutorial vb6, control activex, library. Please visit to [url]http://vb6stuff.blogspot.com/[/url] | |
So, I've been getting some help from the community on some issues (mainly G_Waddle, thanks again!). I'm a VB6 rookie, and it's been a while since I even did coding with that. So, basically here is my VB6 snippet. It's very straight forward and easy to code in VB6, but … | |
I'm trying to convert a simple program fron vb6. IT's only draggin several pictures with the mouse and drop them into anothet picture (trashbin). If the object picture dropped is a match then the trashbin.image changes to another image But: First, I don't know how to allow drag controls!!! | |
Hi All, I am new to this particular forum because I will like to start working with ASP.NET (it's required in my job) but I haven't the faintest idea anything pertaining ASP.NET. I hear things like Configuring IIS and Visual Studio...I was told that this is for a web-based application...could … | |
Hello, I need help in VB6 : Here is the requirements: a) Browse for new images. Minimum of JPG, BMP and GIF image files shall be supported b) Select images for a new group c) Assign name to a group and save a group in a file or database d) … | |
i was trying to make a [URL="http://devvicky.com/"]free microsoft word[/URL] plugin in vb.net. It automatically fills a web form. The main problem with the plugin is that it uses web browser control and once it has filled a form it will need to navigate another form. The form can only be … | |
Help me! I just can't seem to get this right. I'm trying to open an Excel file(Template) and put data from msflexgrid into a specific place in the excel file but i just can't seem to get it right. Can anyone help me with this coding? Much appreciated. Thank you … |
The End.