vn412

Hi, I have a table with curdt field with datatype datetime in ms-access. the entries in curdt as follows:1/28/2011, 2/9/2011 etc. I have a form with two datepickers with custom format of dd/mm/yyyy. my query is like [CODE] select * from table where curdt between #dtfr# and #dtto# [/CODE] where …

Hi, Im using the following script [CODE] var ajax1 = new Ajax_init(); ajax1.GetData('bindddl,ddlCity_01,SELECT cityid,cityname FROM city where countryid='+text.value+' order by cityname','ddlCity_01'); var ajax2 = new Ajax_init(); var ctyid; if(document.getElementById('ddlCity_01').value){ ctyid=document.getElementById('ddlCity_01').value;} else{ alert('szdfzxf'); ctyid=0; } ajax2.GetData('idols, where cityid='+document.getElementById('ddlCity_01').value+ ' and countryid='+document.getElementById('ddlCountry_01').value ,'divlist',p); } [/CODE] Here is the ajax code: function Ajax_init() …

Hi, I m populating 2 select boxes country & city dynamically using ajax. All is working fine in mozilla &all but not in IE. but when i change country acc. to it city select box doesn't get populated in IE. [CODE] <td width="60%" align="right">Country : <?=PopulateSelect('country1',"SELECT * FROM tblname order …

Hi, I generated columns from database and getting cell values from database too. my problem is that for some columns I have to generate checkbox in each cell at runtime. I m using visual studio 2010. Please Help Thanks

I've written a code where depending on some condition i have add item in list as [CODE] With lview .Items.Add(mydr(0)) With .Items(.Items.Count - 1).SubItems if some condition then .Add(mydr(9)) end if end with end with [/CODE] But when i call listview click event for the if condition failure cases it …

Hi, I have a form where I generate a report on some button click. I need help with the code to show another Form in Modal Form, And Place Progress bar on that and Increment the status, from calling form so that when progress bar is running user cannot close …

Hi, I am generating table with Microsoft.Office.Interop.Word In my table cell values i get is: 7, 11, 13, 14, 15, 18, 28, 29, *25,26,28 Now my prob is i want to replace ,* with new line in word. i have written this code [CODE] tbl.Cell(i, 4).Range.Text = tbl.Cell(i, 4).Range.Text.Replace(", *", …

Hi, I have a login form with username and password authentication . It works fine. But I want to give option to remember login info option in the form. Please help me with the code. Thanks

Hi, I've build an application with Mdiparentform. I want to load login form on start up of the application and on succesful login load the mdiparent form and close the login form. Please help me with the code. Thanks

good, i am having trouble on how to insert record date in my access db. i am using hdate as my field and his data type is short date here is my code [CODE] cmd.CommandText = "INSERT INTO hold ([hdate], des) VALUES (#" & myDate & "#, '" & TextBox1.Text …

Hi, I have a problem with displaying output in listview in windows7. I am populating listview colum using OleDbDataReader from database which has value in string as "1,2,4,6,8,9,10" etc. But when I displays it in listview it appears as "10,9,8,6,4,2,1" i.e in opposite order but only in windows 7 not …

Hi, I am using vb.net 2010 with access 2007. everything works fine in XP, but when I switched over to windows 7 I did not proper result some queries here is my query: [CODE]Select * FROM tblname WHERE fordt=#13-12-2010# [/CODE]. It shows result in access as well as as in …

Hi, I've problem with formatting the data. I have rows in grid with date columns "1-12-2011, 7-6-2011, 06-12-2010, 07-12-2010, 08-12-2010, 09-12-2010, 10-12-2010" similary in other rows i have the values like this. I need help with the code so that format the datatable as Jan: values of dates in Jan …

Hi, i have a code where I dynamically generate the columns name and bind it it datatable. now I am iterating thru loop for each column and fill the datatable. My Problem is when I fill for first column row is already added to the position(e.g 0,1). I want help …

Hi, Please help we with the code with Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) to find the location for access database in windows7 and vista. thanks

Hi, I've a problem handling dataset. I have 3 tables in access database. In loop i am firing query to select values [CODE] for i=1 to 3 sql= " SELECT field FROM tbl where some condition" [/CODE] Now i execute the query to get dataset(ds) as output. [CODE] next [/CODE] …

Hi, I m using vb.net with access 2007. I have field with datatype "datetime" and values in format dd/mm/yyyy e.g 8/2/2011. Now I have problem when i fire a query [CODE] SELECT * FROM tbl_name WHERE tbl_name.datefield= (Select Max(tbl_name.datefield) from tbl_name)); [/CODE] I have some records with dates 11/1/2011 and …

hi, I' ve a small project with few forms. i want to design a menu a one form so that when user clicks on the menu item respective form loads in project. thanks

I have a datagridview bound by database. is there any way I can export it to excel and should not store Excel file on server But now user wants the ability to just print on a print button and print that exported excel file. IS that possible? If so how …

Hi, I m newbie in vb.net. Please can someone help me with crystal reports in vb.net with backend as ms-access 2007. I want my report should be printed by dataset populated via query. Please help me with some sample code. Thanks

Hi, I m attaching the view i want with the datagridview design. Please help me with the code to design programatically with dtagridview in vb.net 2010. Thanks

Hi I m using datagrid my cloumns are coming dynamically. Here is the attached view I m getting. For first column I get value from database. now for each cloumn I have to get values for which i have to traverse multiple records from database I want each cloumn should …

Hi, I m usng Ms-Access 2007 with vb.net. My problem is that I have a table with column name strval which has following values: 2,3,43,5,6 etc in each row. Now I want to search for that row which contains e.g 2 in cloumn strval . i use SELECT * FROM …

Hi, My code is: [CODE] sqlsub = "SELECT distinct field1, field2" sqlsub += " FROM tbl I Dim da As OleDbDataAdapter Dim lsdataset As New DataSet 'populate data adapter da = New OleDbDataAdapter(sqlsub, conn) da.Fill(lsdataset, "tbl") thpr = Gettheoprac(lsdataset.Tables(0).Rows(0).Item(1).ToString, "shortform") subcombo.DataSource = lsdataset.Tables("tblname").DefaultView subcombo.DisplayMember = "snshort" + "(" + thpr …