Search results for query: *

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

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