NewVBguy

[QUOTE=sweety***]Hi, Front end Vb6, back end.. access... connection.. ODADB... can someone please help me with the code for login and password.[/QUOTE] Hi, just to give some inputs: in your form you need to have 2 txt field: 1. txtlogin 2: txtpwd then: [CODE] Private Sub txtpwd_KeyPress(KeyAscii As Integer) If KeyAscii …

Hi, Try this one if it works: Form1.Picture = LoadPicture(App.Path & "\096.jpg") hope it work. Newvbguy

Hello There, Is it possible to put a datepicker within a datagrid?. Can somebody show me the code pls. Thanks again Newvbguy

Hi There, I am trying to open a txt file with no header using vb6. my problem is that it's converting the first record as header. how can I solve this problem so that my first record will stay. Below is my code: [code]Private Sub ccommand1_Click() Dim cnn As New …

Hi There, i am using the shell function to execute a program that will zip 10 big data files. so my code is something like this: for n = 1 to 10 t=shell(zip data(n)) 'not the real code ' somewhere here, i need a code to test if the data(n) …

Hi VB6 Community, The whole idea is i want to import a txt file into access2003 using vb6 sql command. i want to use the insert into ado.command rather than using the ado.recordset because of speed. What i have in mind is to open 2 connections, one for the txt …

Hi, If this problem is still not solve you can try this::: This is your code: Private Sub cmdUpdate_Click() Dim ar As ADODB.Recordset Set ar = New ADODB.Recordset ar.Open "SELECT * FROM co_authors WHERE ID = " & cmbID.Text If ar.EOF Then ar.AddNew Else: ar.Update End If ar!author_Name = txtName.Text …

Hi there, I'm a newbie in .net. Can somebody show me a complete working code on how to make this getschema work. I am planning to use it in getting all the tablenames/querries inside an MS Access database and put them in a combo box. thnx in advance.... Newvbguy

Hi there, I am very new to .net and I am starting to learn things. Can somebody share me a working code that will put the schema/structure of a table into a combobox. Pls. consider the ff: 1. file is mdbdata.mdb table is mdbtable combo is combobox 2. file is …

Hi, Try this: listbox.additem str(adodc1.recordset("idnumber")) or listbox.additem format(integer,"nnnnnnnnn") hope it work. Newvbguy

Hi there, I am trying to import a dbase file into an access database. Is there a way of doing this at a command level? I can do it using recordset but it's extremely slow. Pls help. thanks in advance. Please I need a code. Newvbguy

Hi there, I am using a listview control. After populating the listview, I want my cursor to jump to the last row and make it visible. how can i do that using vb code. thanks in advance newvbguy

Hi there, Can anybody share me a coding that will search and replace a char or word in a datagrid using vb6. thnx. in advance.. newvbguy

Hi there, I'm new to this sqlserver package. Is VB6 can able to work with this package like connectivity issues?. Can somebody advice me about this because my previous experience is purely on ms access database as backend front end vb6. thnx in advance.. newvbguy

Hello there, I am trying to connect to an Oracle database that contains 210,799 records with 50 columns. My plan here is to compare the speed between MS Access database and Oracle. Ms Access took me less than a minute to open the database and display the first row while …

Hi there, I am a newbie to asp.net and i am using asp 2005. Now i am trying to create a webservice site. My plan to to create a webservice function that will reaturn a oledatareader and beleow is my code: <%@ WebService Language="VB" Debug="true" Class="WebService" %> Imports System.Web Imports …

Hi there, My plan is just to display the parent and chile page name/id on my wep pages. So what I am trying to do is to put a label control in each page to handle the display. Is there a control that handle this thing. Or how can i …

Hi Everyone, Please help me to solve this problem. I have an adodb.recordset that open eitheir an excel, dbf, mdb, or text file. What I want to do is to export this recordset into an acess table. Can vb6 do this. Please show me the how.... Thanks in advance Newvbguy

Hi Marlon, I am not very sure but i think i've done before. Please verify the syntax but the logic is somewhat like this: for each control in form.controls if typename(control.name ) = "textbox" then control ="" end if next Hope it help kabayan.. newvbguy

Hi, A newbie to vb.net and I am trying to learn this datagrid. Here are my questions: 1. How can I populate a datagrid with selected column of a table without using a query. 2. How can I put a variable column width 3. Can someone show me a code …

Hi There, Can anybody help me with the following: 1. I am trying to open an excel file using adodb connection but i got a run time error on the rs. open. Here is my code Dim cnn As New ADODB.Connection, rs As New ADODB.Recordset cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\XLS.XLS;Extended Properties=Excel 8.0;" …

Hi Everyone, This is probably simple but I don't know how. Can someone show me a code the test if the child form is currently active or currently the one open in front of my screen. Thanks in advance. newvbguy

Hi Everyone, In DAO there is an tabledef object where you have the ability to find out all the names of all tables inside an MDB file. Can anybody show me a code on how to do that in ADO. Thanks in advance. Newvbguy

Hi bkelly, Can you use a combination of a form and a progress bar. I think you can do it in this way. Newvbguy

Hi there, Can anybody show me how to export a recordset into a txt delimited and exporting recordset into a dbf format. thanks in advance. Newvbguy

Hi there, How can I extract a ps file (eg. sample.ps) and put it into recordset. Thanks. Newvbguy

Hi there Can somebody teach me how to add records from one recordset to another recordset. rs.clone style is ok but this method will just replace whatever I have. Is there any way to do this beside rs.addnew? Take note that 2 rs are opened at the same time. Please …

Hi everybody, Can anybody teach me how this work? thnx. private sub command1_click dim vcombo1 as combobox,vcombo2 as combobox call populate(vcombo1) 'there's an error here vcombo2=vcombo1 'another error here end sub private sub populate(oCombo as combobox) oCombo.clear ocombo.additem "One" ocombo.additem "Two" ocombo.additem "Three" end sub 'Basically what i want is …

Hi Everyone, I am really new to cf and I am trying to understand this software. I am trying to setup my dsn. now when i try to go to cf administrator and select data source option, it pops up an error message that there is no java virtual machine …

wow!!! Too much headache... but.. congratulation....for all those solutions... newvbguy

Hi Guys, This might be simple and It might not include a programming job. What I wish to do is to access my files in my office at home. Can anybody teach me how to make this wish come into reality?. I want to know the things I need to …

Hi, I don't know exactly what you want to do here. Do you want to create a database or table using vb? If thats the case, I think you can make are reference first to ms access 8.0 if your using access97 then create an object... It's really hard to …

[QUOTE=mattcplusplus]Im using an ADO data control to connect to an Access database .mdb I can set the ConnectionString property correctly, but when I set the RecordSource to an SQL statement such as an INSERT statement in this format INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....) it doesnt work when …

Hi there, I'm just thinking if DVD decryptor program is possible using VB6. If it is, can anybody give me some points to consider before going into this project. Thanks in advance. Newvbguy

[QUOTE=Turiya]"Invalid procedure call or argument" As I try to remove an item from a listbox call List1 I try this code... If List1.List(i) = List1.List(i + 1) Then List1.RemoveItem (i) if the list contents are identical, remove one of them but it doesn't work![/QUOTE] Hi, Can you try this one …

Hi, I want to know the date when is a file was created plus the size of the file. Can somebody show me a vb code that handle this things. Thanks in advance. Newvbguy

Hi, you can do this way. Private Sub Form_KeyPress(KeyAscii As Integer) if keyascii = 13 then 'enter key msgbox "press enter key" endif End Sub you can substitute 13 with caps lock key number hope it help Newvbguy

Hi, I'm trying to make a backup program but suddenly i got stock with this problem. I want to search all the .txt file in my drive c: and make a zip file on their respective folders. Can somebody share a code for this one? Thanks in advance. Newvbguy

Hi, if your problem is to open the access mdb file you can use the provider... 4.0 instead of 3.51. hope it help.

If i were you, since you are starting to learn prog. why not give a try to vb.net. But it's all depend to you. For me I can't talk much about .net. newvbguy

Hi there, I'm trying to print an ms word file using vb. Before it will go to printer, I want the document file to be viewable but not editable. Can anyone help me. Thanks, Note: I was able to view the doc file but it is editable. I am using …

Hi, Can you try this one... Module Module1 Public Sub Main() Dim About As New Help_AboutForm About.Show vbmodal Dim main As New Form1 main.Show vbmodal End Sub End Module hope it works. newvbguy

[QUOTE=bennyp]My program is currently 980mb is there any way i can make this smaller?[/QUOTE] Hi, In addition to all suggestions, If you can avoid using memo fields, alpha, pictures objects and just use numeric fields. Hope it help. NewVBguy

Hi there, I want to center the caption of a form and make the caption bold. Can anyone show me how to do this... Many thanks.... Newvbguy

Hi, i don't know if this what you need. Assuming you have text1 you can do like this: Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) text1=adodc1.recordset("name") End Sub What this do is it will populate the text1 everytime you change your row. hope it will help. NewVBguy...