Ok...i've managed to somehow get a rough coding on the function that i wanted... but the problem now is that the loops are not really working when it should... Can anyone look at my codes and tell me where i went wrong with the loops... i'm confused with my own loops... =)
THanks to all...
Hello to all...
I'm having problems with getting some things to work in excel...
I have a database containing information about staff information, department information, sub-department information and course information.
I need to print these information grouped by department and...
How do i import excel spreadsheet into the ms access database? i want to get the column names and values in the spreadsheet to be displayed in a dbgrid after i import it...
How can i do that..?
and
is it possible to import tab/comma-delimited file to a dbgrid? if so how do i do that too..?
=)...
How do i import excel spreadsheet into the ms access database? i want to get the column names and values in the spreadsheet to be displayed in a dbgrid after i import it...
How can i do that..?
and
is it possible to import tab/comma-delimited file to a dbgrid? if so how do i do that too..?
=)...
hmm.... I'm using an ADO control....so i'm not really sure if i need to initialise it. =)
anyways...how do u initialise it..?
dim rs as adodb.recordset? (or should it be adodb.command?)
set rs = new adodb.recordset?
Ok...Thanks lotz guyz...it has been real fun trying out da new stuff...=)
I realised that the DB wasn't recognised cause i was using DAO v2.5
and yeap...i did some filtering on the codes so that they won't show the system tables...=)
hehehe
Thanks! =)
Hmm... yeas that's practically wat i planned but the random alpha sequence generation is something i haven't thought of... hmm..do u have any example or any source u can provide that might be useful for me..? =) cuz i'm not really proficient with programming that kinda codes myself... hehe but...
Hi... I wish to put a log in screen in my project where the passwords are kept securely in a database(with the passwords encrypted already) and allow the user(after they log in) to change their password.
And apart from that is there any way that the login can detect if there is previous users...
ok... ignore the syntax error...i forgot to remove the ado control...
i've tried with ACCESS 97 db and it works fine but the unrecognized database format comes out when i use ACCESS 2000 ... anything i need to update.?
Anyway...i tried this...
Private Sub Form_Load()
Dim db As Database
Dim td As TableDef
Dim dblocation
dblocation = App.Path & "\testdatabase.mdb"
Set db = OpenDatabase("" & dblocation)
For Each td In db.TableDefs
Combo1.AddItem td.Name...
Ok..i put the codes at form_load rite..?
and i connected the ado(adodc1) to my db..
the next thing i did was to link the combobox(combo1) to the ado.
do i need to declare anything? like any recordsource for the ado..?
i tried putting recordsource as adcmdtable but they give me an error saying...
Hi all...
I'm having a project where i have to show all the tables that exist in a MS DB into a VB form. I've seen examples of it being done using ASP and vbscripts.
The display format is something like Access where you get to see the different tables. And can i import information from an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.