mclueless
Last Activity: Mar 13 '08, 11:05 AM
Joined: Jan 18 '08
Location:
-
There is simply a calender component i have placed on my form. i am working with VB6 and access and i want to be able to set reminders using the calender componet. is it possible?? -
Strange Problem
I am working with VB6 and Access. I started my project without establishing primary key foreign key relationships and things were working well. but now i hav established that realtionship and my project i giving a lot of errors. even the Insert statements that were working before now give syntax error. why is establishing realtionship affecting the project so much??? What should i do??? Please suggest something....I will really be thankful..... -
Back up
I am using vb6 and access and making an accounting software. How to code for back up...Pleae give me some idea -
txtCustCode_Change()
[CODE=vb]Private Sub txtCustCode_Cha nge()
Dim str As String
Dim i As Integer
For i = 1 To Len(txtCustCode )
str = Mid(txtCustCode , i, 1)
If Not IsNumeric(str) Then
msgbox "Only Numeric values allowed"
txtCustCode.Tex t = ""
End If
Next
End Sub[/CODE]
This is my code.....so... -
Error !
I m using VB6 n access. What is" multiple step operated generating errors. Check each status value "
plzzzzzzzzzz HELP -
I am using access....Leave a comment:
-
Calendar
I have used calender component to display days to the user n i want the users to be able to set reminders for the days that they want to. how do i do this??? -
It gives SYNTAX ERROR IN INSERT INTO STATEMENT error.....Leave a comment:
-
Insert date value into Access DB
I am really pissed with this date problem. please help me out.....
[CODE=vb]Public rs As New ADODB.Recordset
Private Sub Command1_Click( )
Call connection
Set rs = New ADODB.Recordset
rs.Open "INSERT INTO DateTry(Date,Na me) VALUES('" & Text1.Text & "','" & Text2.Text & "')", con, 3, 3
con.Close
End Sub[/CODE]
Plzzzzzzzzzzzzz...Last edited by Killer42; Feb 18 '08, 09:47 PM. -
so how do i write the sql query to insert that record in the concerned table???......Leave a comment:
-
how to write table name?
I am using VB6 and Access n ADODB. Now...i have 12 tables to storing Invoice details. each table is called INV and is suffixed with month number ie INV01, INV02, INV03 etc...
Depending upon the Date of Invoice, the table to be used should be decided ie if the date is 08/02/2008 then that entry should be entered in the table INV02. How can this be done? -
Thanks a tonnnnnnn...... ......Leave a comment:
-
Did sql query fetch some result??
I am working with VB6 and Access. I am using ADODB. when i set a reordset and run a sql query then how do i check if the query has fetched some result or no??
eg. I have a query as follows:
rs.open "SELECT * FROM Invoice_Master WHERE Inv_No=" & val(txtInvNo.te xt) & "",con,3,3
and now i wish to know if the invoice no mentioned in the textbox was found in the table or no then... -
Data Reports
Do you people know some link from where i can know everything sbout datareports in VB6???
Thanx in Advance -
Primary key foreign key
I am working with Vb6 Access.How to establish primary key foreign key relationship between tables in access??? -
MDIFORM and Modal Form
In my project(VB6 and Access), i have a startup form which is unloaded in 2 seconds(display ing the company name etc) then a login form loads amd on proper signing in the mdi form along with one child form opens. Now...there are several modal forms that i have made and used instead of msgboxes....so do i need to make them MDIChild too like other forms???? -
How will this query work??When vil it run???(i m using access as backend n vb as frontend)...I mean if during runtime the values in table1 are updated then will that immediately be reflected in table2???Leave a comment:
-
Primary key foreign key
How to establish primary key foreign key relationship between tables in access??? -
Display table on form
Hie.... I am using VB6 and Access for my software. Here i want to create a lookup table for the user where a particular table from the database is displayed on the form. what control should be used to do so???....If i use datagrid, it connects only through data control while i am using ADODB. also MSFlexGrid connects only to 97 format of access database but i m using 2003. so what do i do?? which control will help me?? -
Thanks a lot....Using alias it worked...Leave a comment:
No activity results to display
Leave a comment: