12,425 Topics
 | |
| | Hello I am upsizing a MS Access database to SQL. I am keeping the MS Access 2003 frontend and using a SQL Server for the Backend. All the MS Access VBA code seems to be working fine except for the code below. I have the same code using different tables … |
 | I make two table in ms access. both of two table has like 'student name' column. when I enter a name it save in table1. Now I want this name will save in table2 automatically. I mean I don't enter this name in table2, but it will store this name … |
| | Here's the scenario. I have a web server running with IIS 6 and website running written in ASP. The site and code has been working perfectly up until about 2 days ago when for no reason whatsoever the ASP has decided to partly work. and by this i mean as … |
| | i am trying to develop a program that would automatically translate languages. currently, i am using systran6 and google translate. but i still have to execute the translation manually. i am using vb6 and sql 2005. please help me on this. :-) |
| | in my application, i have created a data environment. Then i have connected a data grid to that data environment. Now my problem is when i add or delete one or more records, then the database updates itself...but the datagrid doesnt....it doesnt update until i run the application again... :( … |
| | I need to read the advance properties of audio file. E.g. Artist genre album etc. I am using VC++ 6.0 for application developement. Please let me know how to do this in vc++. |
| | hello to all programmers.. i want my datagrid to be saved in my database i am using excel as my database..i want to input my data in datagrid and i want to save it automatically in excel, plz help what's the exact code? and also when i input data in … |
| | hi everyone, can you please help me how the rigth syntax in filtering group, example I want to print 1st year 1st sem grades in the datareport.... any reply is my pleasure thnkz.... |
| | Can anyone tell me.How should i update. i am trying to to a new record if the Supplier_id Doesn't exist, Then i need to do a Select Statement.if that Supplier_id is in the database already,then i want to update method.i havewritten a code .Here is the code what i have …  |
| | how can i get the first name, the middle name and the last name in my textbox? what i mean is i have 1 textbox to input his full name the format is this sample: Nash, Steve B. then i have 3 label, the first label is Your first name … |
| | hello what is the exact code in saving visual basic using ms excel as database? i want to save my data in the form of visual basic into excel as database..what is the exact code in my cmdSave command button? thanks in advance... |
| | Hi All, I want to use the data grid as input interface. Can any one help how to start. i need 3 columns date, name, location the location field is drop down field user can select from the list only. the values entered by user should update in the database. … |
 | HI, I am Using VB 6, how do I sent data over the internet to an SQL DataBase |
| | Hi, I have a VB6 program that uses several ADO Recordsets to connect to an Access database. In one part of my program I have code for adding a new meeting (uses the meetingRst recordset). When the new meeting is added I requery the meetingRst and populate a ListBox detailing … |
| | 1. I work with a database project. Now I want to show all data (from a table like 'student name' column) in a combo box. how can I do this. I connect the database by system DSN and adodc control. plese any body help me. 2. If I select a …  |
| | I am looking for simple example to handle registry key like add new key,edit available key, delete availadle kay,search for key....... i search for examples but they are complicated to understand...... even simple functions also welcome (without full code) |
| | Hey guys please help me for VB proj([U]Topic[/U]=[B]Telephone Directory[/B])... my doubt When i select some area i want the particular pincode to be displayed in pincode textbox [U]note:[/U] the table name is area_name in which i hav 2 fields one is areas and another pincode. so please help me ...!! |
| | this code is used to insert one record....how do i insert multiple records?? [code] Set connect = CreateObject ("ADODB.Connection") connect.open "DSN=OPTUMETL;Driver= Oracle in OraHome92;Server=urnts1.uhc.com;UID=OPTUMETL;PWD=OPTUMETL" Reporter.ReportEvent 0, "Database connection", "Successfully connected to URNTS1" Set objRecordset = CreateObject("ADODB.Recordset") ' Stmt to execute the code query="INSERT INTO STG_CARE.ASSESSMENTANSWER(ANSWERID, ANSWERGROUPID, ANSWERTEXT, DISPLAYSEQUENCE, ISEXCLUSIVENO, ISEXCLUSIVEYES, … |
| | Hello there, I have some codes with me to plot my graph that looks like [URL="http://www.vanth.org/vibes/images/normalECG2.PNG"]this[/URL], but I can't really understand what is going on in the codes below that is used to calculate the Y-coordinate in order to plot out the graph: [CODE]Function findY(ByVal index As Integer) As Long … |
| | I have a thesis project in Visual Basic 6 using Bar Code Reader. This project is a convenient store that reads the bar code from the items or products in store. The cashier will point the bar code reader to the bar code of the items, then the barcode number … |
| | I need to delete the row in access database through vb6.0... I am using the search button to search the records,and then i need to delete those from the database,using the delete button. In the same way i need to upadate/edit the info in vb form and update it to … |
| | it is possible? may i know the code please? |
| | Dear reader (s), In my AccessDB, JanuaryDay(Table) having two columns JanDate & JanShift. JanDate contains all the dates of each month and JanShift contains text value for each date. Its like: Id JanDate JanShift 1 1/1/09 SM 2 1/2/09 M ……………………… ……………………… 31 1/31/09 M I Can retrieve the recordset … |
| | Hello , thank you all for reading my post i really appreciate your DaniWeb it helped me alot before and hope you guys and girls can help me again : i have a program that genrates a powerpoint slide file -it is name is "presentaion1"- now instead of go to … |
| | access events of form in UserControl i have 1)User control with one MSFlexGrid on it 2)Form to place user control 3)Some form's own control i dont know how many controls are there under form i have to place them in grid columns (eg. combobox in grid to provide its service) … |
| | hi, i've created a Form1 which contains a long running process. But i want an feature that will help the user to stop the running process in between, when i click a Button or some other control. How is it possible? |
| | sir i want to able learn,save and update in a visual basic 2005.pls help me in this project |
| | I have created a Microsoft Tabbed Dialog Control (SSTAB) with 5 tabs using VB6 When I run my program and click on Tabs 0, 1, 3 & 4 the entire tab control is shown and correct, however, if I click on tab 2, the width of the control is automatically … |
| | Hello all... working on a queuing project for about 10 users, which is pretty simple in theory. I have the tables and forms done (or close) but am not sure exactly how I'm going to get the data from an FTP server into my table. The table was set up … |
| | Can anyone tell me why this codes are not working. here is the code What i have written.Simple i want to modify listview data using modify button.Kindly find the attachment also. [code] Private Sub Command2_Click() Dim con As ADODB.Connection Set con = New ADODB.Connection con.Open ("Provider=Mirosoft.Jet.OLEDB.4.0;Persist Security Info=False; Datasource=\\asfserver\itp$\product_tabletest.mdb") Set … |
| | In my AccessDB the column monthDate having data type: “date”. In VB6.0 label.caption is the value which I need to save in monthDate. Like: Label1.caption= 2/24/09. Problem is how will I convert the label.caption as date value so that i can save it in monthDate column. I don’t want to … |
| | Hi, I am generating the reports using vb 6 as front end and ms-access as DB and i am using data report to generate the reports everything is working fine but when i click export and save in word doc, everything will go and save in that doc, but unfortunately … |
| | good day to everyone! I just want to know regarding on how to connect to quickbooks using vb6.Ive worked on a company that uses quickbooks but i want to integrate vb to quickbooks. Please help Does anybody know.> God bless on this mother earth. |
| | Hi...I came here because I had problems posting at the C# Corner. Hopefully this forum will actually post my question instead of deleting it once I hit post.... I'm working on homework. Yes, I have given it quite some effort, from experimenting to researching. I've even looked everywhere for a … |
| | Hello, I want to write a program using VBA that can make a new data sheet from an old one with specific columns in the new data sheet. After making this new data sheet i want to convert it to .csv. Any ideas how i can go about this. Thanks. |
 | I'm working on designing a game, the problem now is that while I have a code for randomizing a number, its the same series every time. This isn't good for random, to know what you're going to roll before you hit the button sucks. Is there anything to help with … |
| | Hi, I am generating the reports using vb 6 as front end and ms-access as DB and i am using data report to generate the reports everything is working fine but when i click export and save in word doc, everything will go and save in that doc, but unfortunately … |
| | im using textmatrix in my mshflexgrid my problem everytime e delete all the record the table did not update. . please help. . |
| | Hi! Please help me .. urgent How do i using a Query in crystal report?... I tried using the select expert but I dont know how to go abt it... from srao |
| | hi all, new here and doing my best with a bit of FTP code but have got stuck so would appreciate some help, thanks in advance... I have the following bit of code [ICODE] '------------------------------------------ 'Command format : [PUTFILES] = <local directory> ; <remote directory> 'Example : [PUTFILES] = C:\TEMP\ …  |
| | Can anybody tell me why i am getting error in the bold line. Application uses a value of the wrong type for the current Operation .? [Code] Private Sub Command2_Click() If (CheckInput) Then End If Y = MsgBox("do you add this record", vbYesNo + vbQuestion, "message") If Y = vbYes … |
| | Hi, I am developing an Inventory Management System using VB 6.0, and MS Access Database. I am getting an error: "data type mismatch in criteria expression" which sounds like a variable type mismatch. But i have checked and double checked my datatypes and they seem to match up. Here is … |
| | help how can i know if the user is not an admin i have combo box in my combo box have a user or admin additem if he choose admin then all i want is to validate if the username and password is for admin user this is my code … |
| | hi can anyone help me i have a billing system, how can i save the data to another table? using sql? may 1 table name is transac and all i want is if what the record have been save to my transac then it will save to another table name … |
| | Hi, I have problem to change table design in access. I have imported data and table is like: Product; Name1; Name2; Name3...etc And i should change it be like: Product; Name; qty ..and all data.. Any good ideas how i will change this ir right shape..? |
| | Ok, Ive got a program that Im working on, where it is supposed to calculate some formulas that I have based on some user inputted data and display the data in the form of a table on the same screen, and then optionally show a graph of the data plotted … |
| | Hello friends,i want a know who to rename the start in windows through the Application developed by VB 6.0.If u know means pls help...... |
| | how can i update my table please help. . [code] MSHFlexGrid1.Clear MSHFlexGrid1.Rows = 2 MSHFlexGrid1.FormatString = "|Product Description | Unit | Price Per Unit | Quantity" Set rs = New ADODB.Recordset rs.Open "select * from temp", cn, 3, 3 Counter = 1 Do While Not rs.EOF MSHFlexGrid1.TextMatrix(Counter, 1) = rs!pcode … |
| | Can any one please help me?? Using VB 6.0 and Access DB. [code] ssql2 = "INSERT INTO JanuaryDay (JanRm_id) SELECT rmd_id FROM RmIdIndex WHERE rm_id= " & CLng(txtrostermid.Text) rsName.Open ssql2, conName, adOpenDynamic, adLockOptimistic rsmnth.Open "select * from JanuaryDay", conName, adOpenDynamic, adLockOptimistic rsmnth.MoveFirst Do While Not rsmnth.EOF ‘here is the problem. …  |
| | We have a Visual Basic script that communicates with an application through com. We like to translate it to Python and use win32com.client instead. We have everything working, except for the use of "Nothing" in the VB script for a couple of its function calls. What is the replacement of … |
The End.