dspnhn

Not much of development lately but i think u need to match ur field change to ur recordset and then just replace it with the field value.... For save u just need to match record count and insert all fields.

how much RAM do you have installed....if u are using 2 DIMM remove one or if u r using 1 DIMM try adding another and start the PC it will show u memory size error.......and allow u to configure boot through bios

I often use dynamic grid posting in my applications try this : Set con = New ADODB.Connection con.cursorlocation=aduseclient con.open= "Microsoft.Jet.OLEDB.4.0; Data Source = " & App.Path & "\Telephone_Index\Telephone_Index.mdb" Now to populate or fill the grid with your record do this : Set ttel_idxRs = New ADODB.Recordset ttel_idxRs.cusorlocation=aduseclient ttel_idxRs.open ( "SELECT …

[QUOTE=;][/QUOTE] simply hide all controls you do not wish to print and then give the command Me.printform and after that command unhide all the controls... Be sure to set background color to white for the listview control otherwise you will get shaded listview print. Hope this helps.

dont close the connection. and use Set dbgrid.DataSource = rec_rs rec_rs.requery omit this 'rec_rs.close

please refer to my earlier postings on orientation.

EQP = EQP & " AND VideoNumber like '" & txtFVN.Text & "'" you have not used wildcard here

i try and use a simpler approach like set <object> = new <object instance>

please intiate transaction and then commit it to database Conn.begintrans conn.execute (<your code>) conn.committrans

I agree with veena......compile to p-code (psuedo code)....it is faster and more efficient in porting data from comp to comp

try a simpler approach image1.picture=nothing

let me see ur dataenvironment snapshot and the report code first

it is possible to design such report provided you use either datareport or crystal report.

i need to look at ur table structure first before assuming anything. so please post ur table structure first.

see this link [url]http://www.daniweb.com/software-development/vbnet/threads/26939[/url] further more try and use ODBC to connect with database. eg Oracle ODBC Connection String Driver={Microsoft ODBC for Oracle};Server=myservername;Uid=myusername;Pwd=mypassword; Oracle OLEDB Connection String Provider=msdaora;Data Source=mydemodb;User Id=myusername;Password=mypasswd; Oracle .Net Connection String Data Source=mydemodb;User Id=myusername;Password=mypasswd;Integrated Security=no; hope this helps.

[QUOTE=;][/QUOTE] i prefer chipset cause it offers extensive usage and OCing compared to originals.

[QUOTE=;][/QUOTE] In simple words all your code for stand-alone application is the same for any kind of client-server application except that for a server end you just need the path to the database in your client code. what i do is use mysql on server...get my IP address...store it in …

[QUOTE=;][/QUOTE] i assume you have declared all variables and database paths do something like this.. private sub showdata() set rs=new adodb.recordset ' that is if you have referenced it and declared it along with db or any other for database rs.cursorlocation=aduseclient rs.open("select * from <your table name> where age=" & …

[QUOTE=;][/QUOTE] the only way i can think of is crossfire mode.....for that you pair up two similar graphic cards that offer SLI interface. I believe AMD offers upto four cards to be paired up....just imagine.

[QUOTE=;][/QUOTE] Here is your cause of problem. this line-> rs.Open "Select * from tbllistgood where category like '" & cboscategory.Text & "';" change last portion to "%';" DONE.

[QUOTE=;][/QUOTE] i have a 7750 Dual Core Black Edition on Asus M3A78-EM with Corsair DDR-2 4GB RAM. The system is encased in Thermtake Strike MX cabinet with Tagan Stone Rock 400Watts SMPS. I am now confused whether to upgrade or not...can you guys suggest a few good rigs keeping in …

[QUOTE=;][/QUOTE] you need to set VIEW in property pages of ListView to 1-lvwSmallIcon then just before the loop intializes put this Put this in the start of your procedure Dim clmX As ColumnHeader Dim itmX As ListItem Dim imgX As ListImage Set imgX = ImageList1.ListImages.Add(, , LoadPicture(App.Path & "\" & …

please post all of ur code so i can understand it better and give u a solution

i have a question here ... why do you rely on user input..why not limit user to selection from a list or combo... this way your code can be efficient and bang on target. lemme explain: 1) get all your authors in a combo using DISTINCT clause so even if …

[QUOTE=;][/QUOTE] why don't you try this... 1. put a label control and keep incrementing its top position from the list top position and keep displaying ur list items. 2. put a timer pause for 5-10 sec...if no key is pressed blank the label caption.

replace the fan and use heavier thermal compound

count the occurrence and suffix (1) to database name....similarly, again count occurrence and add (2) and increment it till u logout.

try use this-> private sub loadlist() Dim clX As ColumnHeader Dim itX As ListItem Set tmp = New ADODB.Recordset tmp.CursorLocation = adUseClient tmp.Open ("select * from tblname"),db,adOpenDynamic,adLockOptimistic If tmp.RecordCount > 0 Then tmp.MoveFirst i = 0 Set clX = lstvw.ColumnHeaders.Add(, , "Sr.No.", 700) Set clX = lstvw.ColumnHeaders.Add(, , "First Name", …

use this-> set rs=new adodb.recordset rs.cusorlocation=aduseclient rs.Open "select StudentID,StudentName,Dob,Class from Admission", con, adOpenDynamic, adOpenStatic if rs.recordcount >0 then label1.caption="Total Records Found: " & rs.recordcount else label1.caption="Total Records Found: 0" end if rs.close set rs=nothing

try to use <snip>.....it is a utility and has potential to clean terrible infestations. i have used it quite often. just disable ur antivirus and run it...follow all instructions and do not opt for windows recovery console when asked for. HOPE this gets ur PC back on track

try using a bootable disk and run HDDreg from the disk it might show u the cause

check your datatype within your access table....try to remove "'" from your sql statement and then run it.

if you are saving it to oracle i think u need to create RDO instance not ADO or maybe ADODC works fine....it is the update event that commits the changes to database.

you might as well download pageset.dll from microsoft site and also the relevant code explanation....after that for setting the orientation the properties are given there once u reference the dll.

that is because your laptop has ahci or sataII enabled in cmos... go into the cmos settings and change it to sata or disable it completely (there is an option for that too) then you windows CD or DVD will boot.....better still try and make or download unattended version of …

while u are at it u might wanna just remove the RAM....use a pencil eraser and just clean the contacts and insert it back...

u might wanna try combofix....use it from some other drive (pen,falsh whatever) and follow the instructions. donot worry about the messages just keep going forward....this is what i call the mother of all fixes.

use this DataEnvironment1.(your rscommand name).Properties.Refresh Dataenvironment1.(your rscommand).open show you report here Dataenvironment1.(your rscommand).close Regards DSP

just add values to a tmp table and call it to populalte the grid. Every time you press ADD just call the REQUERY function. for details search datagrid threads

cant say much without ur code....but is guess u could use a temp table and fill in all values desired and display it on the report all at once.

[QUOTE=;][/QUOTE] try changing wild card for LIKE with '1%'

[QUOTE=;][/QUOTE] amend ur Right(ws9B.Cells(iRow, 4).Text, 1) = "A" Or "C" to this Right(ws9B.Cells(iRow, 4).Text, 1) = "A" Or Right(ws9B.Cells(iRow,4).text,1)= "C" Then USE THIS RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1,"\","*",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))) SEE IF IT HELPS

for date format the value to mm-dd-yyyy or mm/dd/yyyy and put it in a variable named through dataenv. similarly put a variable for unit through dataenv and simple use the var in sql when executing ur query. This will give u a fair idea what i m talking bout article …

[QUOTE=;][/QUOTE] are u using DAO then first connect to the database and then to the table if u r using ADO then when u end the "str" use the connection string to database there with relevant options such as adopendynamic,adlockoptimistic

[QUOTE=;][/QUOTE] u can use this in between...but modify this first Set sFileSystemObject = CreateObject("scripting.FileSystemObject") Set sFileObject = sFileSystemObject.getfile(App.Path & "\" & <filename>) sFileObject.Copy <newlocation like "D:\> & "\" & <same filename>

[QUOTE=;][/QUOTE] put strsql.openrecordset in front of ("select.....

hello all, Is there some way that i could create a menu just as we all use in various applications that pops up on mouse right click event with loads of options.......it would surely help me save a lot of buttons...

use dataenvironment1.command1.cursorlocation=aduseclient then show your report

please open a new project in vb and add all your forms and instances one by one and keep saving them in a new location......also add all components and references used in the project earlier.......it will show you the error if you don't do so.......try this and let me know

use inner join in SQL.....it is available as a sample example in MSDN or anywhere on the net similarly, for the next transaction try and insert the relevant record into table2 and then delete it from table1 on some unique key using sql.