Recent content by eves

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...

Hehehe...i forgot to mention that i wanna import into the dbgrid.. in my vb application...=) =)

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..? =)...

OOPS!... got the post in the wrong category... =) Sorry to all... i'll post again in the database category...

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...what is wrong with this... adoInfo.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ App.Path & "\testpassw.mdb;Persist Security Info=False" adoInfo.RecordSource = "SELECT * FROM NumOfUsers" NumOfUsers =...

hahah Cool.... Thanks lotz... This will really help me lots...=) Thanks very muz..=)

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...

Hmmm... do u have any example source to guide me to this? =)

hmm... is there anyone at all who knows how this can be done..?

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.?