debasisdas

you simply need to use MDI form and other forms that you want to minimize as child form of the MDI.

you need to frame the sql dynamically at runtime and pass the same to the report.

try the following [code]select b.SAL_ACC ,b.NAME ,b.ADV ,b.DT_PREP from mstr a,detail b where a.psno=b.psno[/code]

i didn't understand your question . What is a [B]forum[/B] window ? What do you mean by update without saving ?

then you need to push the power button on your computer.

i don't think that is VB 6.0 code. if vb 6.0 then try this [code=vb]Dim Sql As String = "insert into Customer_tbl (Custsql )values '" & txtFirstName.Text & "','" & txtLastName.Text & "')" con.begintrans 'con-----ADODB connection object. con.execute sql con.committrans[/code]

After the insert operation you need to call the REQUERY method of the recordset before passing the same to the displaying control.

try using [B]localhost[/B] instead of system name.

you need to resize and rearrange the controls based on system resolution. You need to use X and Y coordinates of the screen.

Then this question should have been posted in the .net forum ,not here.

so what are you passing , month name ?

You need to format the date to proper format before pasing the same to database.

From your post i became a bit curious and tried to trace back my old days here. My first post was in community introduction section [URL="http://www.daniweb.com/forums/thread80215.html"]here[/URL], as i was trying to post a brief intro of self ,as per the couple of stickies in that section,just to complete formalities ,before …

comment [B]Unload Me[/B] in your code and i hope the rest wills tart working. use [B]Me.Hide[/B] instead of [B]unload Me[/B].

OS will always print to the Default printer.

For that you need to use a staging table and update the master table based upon data in the look up table. You need to handle the code in a PL/SQL block.

once you COMMIT that will be reflected in the database table. if you exit without commit all the uncommitted transactions will be rolled back.

try the following select * from table_name where status ='Avaibale' and status not in ('Completed','Progress')

a single update statement will do , why you need a loop for that.

The simplest method will be create a view based on the table with last five days record. That will be always refreshed every time you run any query on the view.

you may not directly update the view , again that depends on your table structure.

I don't think that is an ER diagram. That seems to be a flow chart to me. You need to understand the basis difference bewtwen the two.

Add a menu item and a sub-menu to the main menu to the form. Add a picture box to the form and set its visible property to False. Add the following code to a general module (.BAS).(API Functions) ================================================= [code=vb] Public Declare Function CreateCompatibleDC Lib "gdi32" (ByVal hdc As Long) …

you need to call AddNew or Edit before using Update method.

you need to convert the date and time to proper format before passing the same to database for processing through SQL statement.

follow the link for your question [URL="http://bytes.com/topic/visual-basic/insights/726143-adding-items-treeview-listview-database"]link[/URL]

do not expect us to guess and solve your problem. Please post the structure of your tables.

delete deletes the records, which can be made permanent by using COMMIT, and can't be rolled back. Truncate deletes the rows and resets the high watermark and there by de-allocating all the space allocated to the table.

[code=sql]select * from dept where d_name in (select d_name from dept group by d_name having count(d_name)>1 )[/code]

Bangalore, India.

do you want to do all that from VB 6.0 ?

addnew or edit method of the recordset must be called before the update method. try as the following code [code=vb] rs.addnew rs.Fields("Supplier_id") = Val(Text1.Text) rs.Fields("Supplier_name") = Text2.Text rs.Fields("contact_person") = Text3.Text rs.Fields("contact_no") = Text4.Text rs.Fields("office_address") = Text6.Text rs.Fields("emails") = Text7.Text rs.Fields("website") = Text8.Text rs.Fields("Fax_no") = Text5.Text rs.Fields("item_type") = Combo1.Text rs.Update [/code]

you need to use the function REPLACE.

you must be connected to the database.

there is no such thing like most recent record in database. there is no way findout the most recent record. you need to pass some value to fetch the record.

you need to open the recordset as per selection of the combobox input and pass the same recordset to report.

try to use SAVESETTINGS GETSETTINGS DELETE SETTINGS for the purpose.

you need to frame the sql query dunamically and pass the area and get the pincode from database.

You can't get a experience without a realtime job.

what is the query that you are working on ?

the code is straight forward but i am afraid that is not the complete code and has some dependency with other parts of the code

you do not need any code to get the value of barcode in a textbox. Once the barcode reader reads the code the value will be populated on any control having focus. what you need to do is process the value as desired , that might involve some calcuations as …

try the simple code [code=vb]con.begintrans 'con-----adodb connection object. con.execute "your DML statement here" con.committrans[/code]

if you are using oracle as database then can use external table for the best solution,but you need to extract the zip first.

where is the code to modify. the code only includes a select statement.

you need to parse the value before passing the same into database.

Why you need all the lengthy code just try this [code=vb] con.begintrans 'con---ADODB connection object. con.execute "your insert statment here" con.committrans [/code]

try using the following [code] Public Sub runOmitVendorQuery() SQLomitVendor = "select UserRights from tblUSERS where UserID = " & CurrentDeviceUserID Set rsOmitVendor = New ADODB.Recordset rsOmitVendor.Open SQLomitVendor, cnConnection, adOpenDynamic End Sub [/code]

[QUOTE=ryan311;809355]help how can i know if the user is not an admin i have combo box in my combo box have a user or admin additem if he choose admin then all i want is to validate if the username and password is for admin user this is my code …

what is the database that you are using ?