10,987 Topics

Member Avatar for
Member Avatar for old_mustang888

Hi, Plz help me... My project is Sales system using DAO I need the code for: Password code System (to generate the Item code) Item Entry code, Item Inquiry by description, Item Inquiry by quantity on hand Item Inquiry by unit of measure Item Inquiry by unit price Custumer Entry …

Member Avatar for technogeek_42
0
184
Member Avatar for VisActualyBasic

Hi everybody, I have following code: [ICODE]Public Class Form1 Private Sub btn1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn1.Click Dim dayChange As Date = dtp2.Value Dim answer As Date answer = dayChange.AddDays(1) dtp2.Value = answer End Sub End Class[/ICODE] Working : each time I click btn1 datetimepicker changes …

Member Avatar for VisActualyBasic
0
203
Member Avatar for rajeshkhanna_in

HI all, I have on the form an ADO data control and an OLE object. ADO is connected to a MSAccess Database (With a table having an OLE field). The class of OLE field is "Word.Document.8". Now when I try to connect the datasource property of OLE object, it says …

0
54
Member Avatar for rajeshkhanna_in

Hi all Does anyone know about any software which will help me in making a question bank for my students? Also I want the software to help me in making a question paper for the students from the question bank that I create. Thanks in advance any help will be …

Member Avatar for mrhard2004
0
98
Member Avatar for leedsy7

Can anyone provide me with code on how to Delete a row from a list box?? lstReorder.RemoveItem (index) I believe is the right code. However this does not actually do anything by itself. How do i tell the program what the index refers to? ie what the index is? for …

Member Avatar for Henry Schubel
0
1K
Member Avatar for zeiken
Member Avatar for pranavdv

please help that how to add data of one field of database to the combo box. i attached one rar file with this. check that

Member Avatar for Jx_Man
0
133
Member Avatar for bornok15

I'm having problems filtering the date for my reports with access and older versions of mysql i can do this my using this query format: Select * from transactions where xdate =#"& txtdate.text &"# or Select * from transactions where xdate =#"& format(txtdate.text,"mm/dd/yyyy") &"# but now that i'm using wamp …

Member Avatar for Jx_Man
0
91
Member Avatar for addi

hello... i' m doing registration license system... i need source code that can search due date by their month... and i want to list their date with companies name.. how to combine two table in database?? because i want use the combine to search and display the data..

Member Avatar for Jx_Man
0
260
Member Avatar for swapna7999
Member Avatar for swapna7999
0
74
Member Avatar for glfnfvr

I am trying to write a code that asks for a date in a user form text box and then takes that date and looks for it in a range. Once it finds that date I want to enter the data from the second text box in a cell on …

Member Avatar for glfnfvr
0
124
Member Avatar for bornok15

I'm currently designing a report using VB6 and crystal reports using mysql as backend but everytime i open the report in VB i always have the error "Access Denied". I never had such error in the old version of MYSQL. I using WAMP server with MYSQL 5. Anyone who has …

0
68
Member Avatar for rustyboy

I'm new in MYSQL is there anybody who is expert in MSQL as backend and VB6 as front end please i'll be willing to study espcially on the connection. How and what are the procedures? Thanks a lot in advance...hope to share also my little ideas soon...

Member Avatar for rustyboy
0
74
Member Avatar for lostandfound

Hi again, In my previous thread regarding Combo box at runtime I had not forseen the problems I would experience introducing a variable to the code. [CODE]Private Sub Form_Load() Set myconn = New ADODB.Connection myconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Documents and Settings\Gareth Powell\Desktop\db2.mdb" myconn.Open Set mycomm = New ADODB.Command Set …

Member Avatar for lostandfound
0
194
Member Avatar for lostandfound

Hi all, What I need to do is populate a combo box at runtime according to specific inputs from other forms.The code listed below is a seperate trial and works OK. I would like to know if I am overdoing the code thing for what I am achieving. [CODE]Private Sub …

Member Avatar for lostandfound
0
326
Member Avatar for Broxy

Hi There In an Excel Macro. I am trying to install a manual Page break in an IF Statement, if it results in a 'Yes'. What I am missing? Please help. Best regards, Broxy. Sub PM3() ' ' PM3 Macro ' ActiveCell.FormulaR1C1 = "=IF(RC[1]=""yes"", ActiveCell.ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell)" End Sub

0
60
Member Avatar for bpb-p

I have a form with several list boxex. The form feeds an Excel spread sheet. I need to move thed data from the list box to the spread sheet. Some times it works, and some times it doesn't. I have varified that the list indexes are correct, and have even …

0
49
Member Avatar for woseng

I am trying to create an alert in Vb.6 code that tells the user to make purchase since he has riched limit of the product

Member Avatar for steve585
0
66
Member Avatar for Yogesh Sharma

steps i Follow- 1) Go to Control panel-->Admintrative Tools-->Double -click Data sources(ODBC)-->click Add button-->I choose SQL server(last option), Is it right or wrong option for connecting to SQL 2000.Then a new screen appears Create a New dataSource-->in name textbox,we can write anyname--Right or wrong. suppose i enter sonia, & my …

Member Avatar for choudhuryshouvi
0
913
Member Avatar for wrichardson530

Hi all. I'm having difficulty making a log-in screen. i am using an adoc contorl called adoClerk, which contains only two fields and ClerkId and Password. The ClerkId is a autonum and password is text. I Have two text boxes that need to be read from this screen txtClerId and …

Member Avatar for choudhuryshouvi
0
208
Member Avatar for muguus
Member Avatar for Jx_Man
0
78
Member Avatar for Scott Marchione

Hello all, I have a VB Script that creates a phone list for my company, and I have been asked to alphabetize the names listed under the department headings....I am so new to VB that this is the first time I have used it.....ever I've done a great deal of …

Member Avatar for Scott Marchione
0
153
Member Avatar for swapna7999

hi thanks for ur suggessions now i got mysql connection with vb but i need to use the mysql Queries in this application hope i wil get solution thank u very much

Member Avatar for swapna7999
0
837
Member Avatar for swapna7999

hi there thanks guys now im able to connect to the mysql database and know how to use select statement to access the the data in the database but what to do to view the data retrieved by the select statement

Member Avatar for swapna7999
0
76
Member Avatar for mrhard2004

Hi... I am developing a software where I need to enter both [B]text as well as some Mathematic equation or some BMP picture [/B]inline with the text. Is it possible to enter this as input to any one variable. If so what type of the variable should be used? Please …

Member Avatar for ROBBOHORT
0
82
Member Avatar for drpaur

Hi, I have made a DataProject in VB6 with Access as back-end. Using Jet OLEDB 4 as provider. Programme is running well on my Computer. When I Installed the project on another Computer where VB6 is no installed on Hard disc, Error comes. When I try to show Report in …

Member Avatar for wrichardson530
0
147
Member Avatar for Mr.Wobbles

The Title says it all - I don't really need the exact code, but a point in the right direction would be appreciated.

0
87
Member Avatar for nemag

after i put earch code in my project : Private Sub cmdSearch_Click() Dim search search = InputBox("please enter card no", , "") Data1.RecordSource = "SELECT * FROM waqf WHERE cardno LIKE (""" & "*" & search & "*" & """)" Data1.Refresh End Sub ------------- the search working but appear problem …

Member Avatar for choudhuryshouvi
0
130
Member Avatar for hasmiza

i'm using adodc. i want to empty all the text box when form load i already use to reset all that but it cannot work private sub form_load txtname.Text = " " txtIc.Text = " " cboroom.Text = "<choose room type>" cbocheckin.Text = "<choose>" cbocheckout.Text = "<choose>" cbomonth.Text = "<choose>" …

Member Avatar for choudhuryshouvi
0
101
Member Avatar for leedsy7

hey Really strugling with Access today so i could do with some help :) I'm attempting to add items to a list box. The Sources are 2 text boxes which have been fed to from a querey. So first I tried... lstReorder.AddItem (ITEM_NUMBER.Text) lstReorder.AddItem (ITEM_DESCRIPTION_1.Text) Which brought up the error …

Member Avatar for leedsy7
0
248

The End.