User Profile
Collapse
-
Sorry I want to do the importing data by using VB6. Not directly open my database. -
Import specific column from excel into access using visual basic 6
Hi experts,
I would like to import data from excel into access. For example I have field "Name" in the excel table. Then I want to import all the data under the field into my database (ms access). -
-
How to connect ADO dynamically
Hello experts..
I'm using ADO,VB6 and MS Access as database. I would like to create a form as template for many subjects. I need to make dynamic connection based on subject. I created a module for ADO connection then used IF statement but fail. Here is my code in the module(.bas):
...Code:Option Explicit Public snconn As ADODB.Connection Public sncmd As ADODB.Command Public rs As ADODB.Recordset Public Sub
-
-
How to replace certain string in whole codes
Hi experts..
I have completed my code for one subject. I need to repeat the whole codes for the other subjects. The difference between the subjects in the codes is only rsSn2 and rsMath2. Is there any idea to replace the string in the whole codes rather than retyping them? -
my data looks like this:
let's say I choose atec,dell and nangka. I would like the numbers in data report sequence 1, 2, 3.Code:CustomerID Company Name 111 kolapis 121 nangka 131 atec 122 vis 152 dell
Leave a comment:
-
it's produce numbers but not sequence like
3.
5.
2.
I would like it produces like
1.
2.
3.
until the end.Leave a comment:
-
How to number records in data report
Hi experts,
I'm using Visual Basic 6, MS Access as Database and Data Environment in my Data Report. I would like to give numbers for my selected data. I separated my data and the numbers then used this code.
...Code:SELECT Customers.CustomerID, Customers.CompanyName, (SELECT Count(*) From Customers As Rank Where Rank.CustomerId <= Customers.CustomerId) AS RecordNumber FROM Customers ORDER BY Customers.Custo
-
-
i think it's still related with "indenting of NUMBERING DATA". But it's ok I will create new thread for that..:)Leave a comment:
-
i can do for the data but how can i generate numbers based on my data?Leave a comment:
-
indenting of numbering data
hai experts..
in my Data report the indent looks like this..
1. blah blah blah blah
blah blah blah blah
what should i do to make it indents properly like this..
1. blah blah blah blah
-->blah blah blah blah -
thanks rabbit..you are the best..now i can compile my program..next time i will normalized my database first before start project..actual ly just learned programming couples of weeks ago..:)Leave a comment:
-
i know how to normalize my Database but i have to start from the beginning. Rewrite the whole code..mess with data report and everything. Since this is only my last problem i need to overcome then my program will complete..anywa y thanks experts..if you have any idea about the numbering i appreciate that..thanks again.Leave a comment:
-
ok i explain in more details..
i use vb6 and msaccess 2007 with ado.In vb6, i got a combobox(Jan,Fe b...) and several checkboxes labeled with 111,121,131..In my msaccess i got field of name,111,121,13 1...,Jan,Feb till Dec. For example when user select Jan(combobox) and 111 and 121(checkbox) in vb6 ,their statement will write in database under Jan with numbering format.If the user select again 131 in Jan,the numbering not sequence properly..that' s...Leave a comment:
-
here is my ms access database..each number(111,121. ..) holds
a statement..when the numbers being checked the statements will show in month fields(Jan,FEb. .) arrange with numbering....Leave a comment:
-
even memo in ms access?i put them under January field so when i choose January at combobox,data report will shows the data.i use one table only.any idea?Leave a comment:
-
numbering data problem
hi experts..
i would like to store several data in one field in ms access. i use this code to split and numbering the data..
everything's going well until...Code:Dim lines() As String, ixx As Integer lines() = Split(Text1.Text, ",") For ixx = 0 To UBound(lines) Text3.Text = Text3 & (ixx + 1) & ": " & lines(ixx) & vbCrLf next -
now i understand what do you mean at the first post..looks like it's work..thanks expert..will coming back if there has other issue related.Leave a comment:
No activity results to display
Show More
Leave a comment: