hi guys , i have a problem with my loading/refresh record in my form. i have only almost 500 record and take so long before refreshing/display the data. i have a user input form where user enter their record and while saving(direct to the database) and refreshing data i just call only my function getrec (). pls give me some idea to fix this problem. pls take a look Dim ActiveTable As New DataTable Private Sub frmRef_Userlist_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load getrec End Sub Private Sub dtBind(ByVal dt As DataTable) 'slow start here bs.DataSource = …

Member Avatar
Member Avatar
+0 forum 5

hi everyone, need to get some advice, when opening mysql connection what is the way using Imports MySql.Data.MySqlClient (use in my current vb.ney proj) or ado connection? (use in my current vb6) thx in advance.

Member Avatar
Member Avatar
+0 forum 1

hi guyzz i wanted to remove item in the lisview using the for each i want to delete multiple item with similar field in the listview. any help.. for this problem.. it could be possible ? i have here code but it delete only selected item in the listview. (ListView1.ListItems.Remove (ListView1.SelectedItem.Index) )

Member Avatar
Member Avatar
+0 forum 10

Hi everyone, goodday. Right now im planing to setup 5databases for each store(5 loan branch). Each branch encode customer and loan account. Also hold each db for the branch inventory. For single branch the database works perfectly (encode transaction and produce reports). Now my problem is.. I want to centralize my database. for example. My Loan record is in the Branch A. now im in the Branch B. I want to pay/down some cash for my account without going to Branch A. what is the best flow for this? could somebody share some idea. how can i manage this upgrade …

Member Avatar
Member Avatar
+0 forum 10

hello coder, could anybody can share an idea on making attachment files. on my cms software. i wanted to have an attachment portion. where my doc,jpg,xls files can be attach. im planing to stored it on my app.path by copying the files. but my problem is when opening on the network computer. im also planning to save it on the database. but the big question is HOW? hmmmm.. sample code or little idea will be appreciated. regard, jaasaria

Member Avatar
Member Avatar
+0 forum 6

Hi guys .. i wanted to open some of my files. like mswords that save in any of my folders. also wanted to open .txt, .jpg, html etc files. any code for this.. i have an idea using shell "location of exe" but it open exe files only. i wanted to open/preview some of my documents.. any help will be much appreciated.

Member Avatar
Member Avatar
+0 forum 2

Hi guys.. i wanted to make a report that can be design it own field location during runtime. Im using crystal report 8.5 and do u think this software is capable for this.? Any idea that can be share will be much appreciated. thx

Member Avatar
+0 forum 0

hi guys... im using flexgrid for viewing and encoding of data for my project. i wanted,to have a automatic computation for the column i have for example : once i input number in col1 and col2 the sum will show up automatically in col3. col1[ col2 col3 5 3 (automatic sum) any idea ? kindly help. thx in advance

Member Avatar
+0 forum 0

hi guys im using crystal report 8.5. but i wanted to print some report in the network by using some share printer. it is possible ? please kindly share some idea on how it take. thx in advance.

Member Avatar
Member Avatar
+0 forum 2

hi guyzz im using crystal report for my application... i have problem in making formula in details parts of my report.. i access two tables in making the details, but my problem is to display the amount by subtracting or adding the details amount.(for getting the running balance.) plss see my attchment. for my sample.

Member Avatar
Member Avatar
+0 forum 1

hi guyzz... i have more than 1000 datas in my tables i loaded it in the listview using function.. but i have problem in loading it.. it consume almost 9 second to load all in the listview... i think it is in my coding.. i would like to minimize it. here my code. [ICODE]Private Sub userPriceList1() Set rsFltUser = Nothing Set rsFltUser = OpenRS("Select branchcode,branchname,item_Number,item_name,balance_unitcost,balance_unit from itemlist order by item_name") With rsFltUser If .RecordCount <> 0 Then .MoveFirst Do While Not .EOF Set lstitems = frmPOS.ListView2.ListItems.Add(1, , !branchcode & " - " & !branchname) lstitems.SubItems(1) = IIf(IsNull(!item_Number), "", (!item_Number)) lstitems.SubItems(2) …

Member Avatar
Member Avatar
+0 forum 7

hi guyzz... is their a third party software were can i install/register all the vb dll files need in my visual basic project. im having hard time in my installer setup. im using setup factory. and before im making the setup up factory wizard, im using the Package & Deployment Wizard of vb. i have a lot of error. including the auto complete in combo box. when im in my computer the autofill of data working fine, but in other computer i have a problem in auto complete. (dll files not included in vb.) i thinking that if there is …

Member Avatar
Member Avatar
+0 forum 4

hello, by the way im using datagrid in showing all the data in my database... here my codes... ''''''''''''''''''''''''''' form_load set rs = orecs ("select * from employee") set datagrid = rs ''''''''''''''''''''''''''' how can i convert it in list view to view all the data in my database......... plssssssss kindly help me......... jaasaria

Member Avatar
Member Avatar
+0 forum 17

hi guyzz.. in my report i have a paper size of 3 x 5 inches. how can i customized my designer to fit my requirement.. ? i need a driver for this layout? if ever.. can u share this driver for me... thx in advance.

Member Avatar
+0 forum 0

hi guyzz.... i wanted to make a report to show the item sold by its months. here my attachment.. plss see... how can i make this report using crytal report..? plsss help

Member Avatar
+0 forum 0

hi guyzz... i have a problem in my combobox listindex searching. when i open my comp, the combobox working very well that when i type the first letter it automatically autocomplete the data in the combobox, but after an hour or restarting my pc.. it doesnt work any more... i have a conclution the in my dll file or something in my computer. any one can solved this... thx in advance

Member Avatar
Member Avatar
+0 forum 2

hi i have an error here could somebody know or expirence this before plss help.. this error enclude dll and i have the site now. this is the link [url]http://support.microsoft.com/kb/248055[/url] i already put the dll in the said folder and already installed mdac. plss any has expirence this .plss help

Member Avatar
Member Avatar
+0 forum 4

hi.. i would like to save every word in the sentence separating by space " "... any idea on it?? thxx

Member Avatar
Member Avatar
+0 forum 2

i want to study the tree view any code or site for help.. i look at the internet and any source code site.. but i havnt find one... any help and comment will be appreciated.. thxx jaa

Member Avatar
Member Avatar
+0 forum 2

hi guyz.. by the way im using crystal report 8.5 in my project. i have already a report but the report i have is to diplay the viewer.. i want it to automatically print it, without preview the viewer.. what code shall i used? shall i use crytal report? or other ? any idea well be appreciated.

Member Avatar
Member Avatar
+0 forum 4

hi guyzz.. i wanted to make a code to change my system unit date and time using vbcode. i have a small idea, to run a command prompt but i don't no how to make it so. any possible idea well be appreciated.

Member Avatar
Member Avatar
+0 forum 3

hi every one.. i have problm in my cviewer.. im using crystal report for my report when i view the report the data come in my crystal but the problem is when i click the print button on it.. it doest print, but only show the printer.. when i try it in other form the viewer is printing.. i think their a bug or something wrong with it.. anyone help will be appreciated.

Member Avatar
+0 forum 0

hi guyzz ... i wanted to make a system to compute na percentage of the item sold in every days period... here is the problem. ^_^ i have (10) item sell product but within (30 days).. i want to get the (20%) of that item... within the parenthesis is my variable... p pllsss help me to get the formula.. plss help for those can understand my english... and sorry for the novice post.. thxx

Member Avatar
Member Avatar
+0 forum 5

elow guyzz... i have here an POS system.. i wanted to buy a laser scanner but i dont have any idea to use it.. if their any comment and suggestion or examples can be more helpfull and appreciated.

Member Avatar
Member Avatar
+0 forum 1

hellow expert.. im trying to install vb's system's on any pc' with out microsoft office. im trying to put open office for that unit. but sure that i will encounter a lot of error.. like out of memory. or something that required FM20.dll and other DLL. any idea for that and im sure it is possible. im collecting other DLL required but im not sure.. that it will work well. any 3rd party(open source) software that can be use? any help will be appreciated. thxx

Member Avatar
Member Avatar
+0 forum 2

hello sir... from our office we are using wamp for our mysqlserver... but i wanted to be connected to my sitemate database only changing the MysqlHost address.. username and also the password... the problem is i cant connected to it.. maybe u already incounter this before and im hoping that u can share it with me.. hopefully and thankzz for someone who would welling to help me...

Member Avatar
+0 forum 0

sir, question.. can i get the exact len of string when quering? because i have two format in my TransID. The one is the 10digit for the MSAccess and the another is the 11 Digits in my MySql. So if i update all in the MySql database the problm is he read the last transId from the access and add the 1 value that must be only in MySQL transaction.. how can i query the 11digit transID only and add the value. this is my format in my TransID that i think make me more complecated... MsAccess = RMI-000000 MySql …

Member Avatar
Member Avatar
+0 forum 5

hi guyzz... i have a code here about chatting using winsock, but it is not working and I tried 2 surf in net but the error cant be solvd cleared.. .i have a runtime error 40006(wrong protocol or connection state....) and the error is refer to the senddata properties... plzz somebody help...

Member Avatar
Member Avatar
+0 forum 2

hi guyzz, i wanted to have two connection using access and mysql in my proj. my access was my main db connection and what ever data in my access will store directly in mysql db when their is internet connection... I declared 2 fuction connection but my problem is the switching of the recordset. "OpenRS" and "OpenRS2" i declared "OpenRS" in every table in Access but my second connection is "OpenRS2" for my mysql.. how can i use the OpenRS2 in saving that will no change in every code in every forms. any help or comment will appreciated........... thx in …

Member Avatar
Member Avatar
+0 forum 5

could anyone can give me some php site that can be uploaded the source code........ the best site for newbie..... and expert..^_^ any help would be appreciated......... thxxxxxxxxx in advance......... jaa

Member Avatar
+0 forum 0

The End.