Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SpeakUp

    Remove Display Settings?

    Ok got it but i want also to remove it when i right click on my desktop to avoid any changes in the properties settings. Is there a way? Thanks!!!
  2. SpeakUp

    Remove Display Settings?

    How can i remove the display settings to avoid any changes in my desktop.... Thank you very much!!!
  3. SpeakUp

    Importing access data to txtfiles

    Hi! Is there a way to import a data on msaccess to textfiles using vb6. Thanks!!
  4. SpeakUp

    How to Edit Records using ADO

    Actually im using ADO ODBC but im not good in ADO. Can u give the equivalent code of this in ADO... Set rs = db.OpenRecordset("MyTable", dbOpenDynaset) With rs .FindFirst "Field1='" & Text1 & "'" If Not .NoMatch then my code goes here ...
  5. SpeakUp

    How to Edit Records using ADO

    Hi!, Just asking how to edit records using ADO, im really not much of an ADO user. This is my first time practicing ADO i know how to add records but not Edit and Delete. Im using ADO ODBC!!! Any help!!! Pls..... [pc]
  6. SpeakUp

    How to populate a combo box based upon a datacombo?

    Set db = Opendatadase("Your Database") Set rs = db.OpenRecordset("Select * From TableName Where Field1='" & Datacombo.text & "'") With rs combobox.clear Do combobox.AddItem !Field2 .movenext Loop Until .EOF...
  7. SpeakUp

    serachin an access table using VB 6.0

    Ok. If You're using DAO as your reference then here's the code. 1. Go to Project Reference and then Select Microsoft DAO 3.51 2. Open the Database and the Recordset...... If you are searching use dbOpenDynaset if adding records use dbOpenTable... Assuming that you have a TextBox where you type...
  8. SpeakUp

    visual basic and access

    Add a Data Environment and from there right click on the Connection and select Properties and find the path of your Database. Once connected, add a command and select what table you want to display or just use an SQL. From your DataReport set the datasource to DataEnvironment1 and then the Data...
  9. SpeakUp

    embed sound in vb

    There are two types of embedding a sound in your application, the first one is by using API function and the other one is using OLE. Try this.... Public Declare Function sndPlaySoundA lib "winmm.dll" (ByVal lpszSoundName as String, ByVal uFlags as Long) as Long Private Sub...
  10. SpeakUp

    Unrecognisable Database format

    Hi! MSAccess 2000 is not recognizable when you are using DAO as your reference. Try to use ADO... i guess these will solve your problem. Try to download some Service Pack. OK[bigsmile]
  11. SpeakUp

    Date Picker Please help!!!!

    Are you using DAO? Try This.... Set rs = db.OpenRecordset("TableName",dbOpenDynaset) With rs DTPicker1.Value = !fldBeginDate End With rs.Close Set rs=Nothing Note: If you are trying to find a specific Date to load to the DatePicker Control... Try to query before loading...
  12. SpeakUp

    How to get User and Password from NT4 Server

    Hi! Just asking if it is possible... I had a system and i want those users to log on to my system using their network password. Thanks...
  13. SpeakUp

    How to get User and Password from NT4 Server

    Hi! Is there a way or a function that gets the username and password from the NT4 file server? Thanks in advance!!! Regards, Arnel
  14. SpeakUp

    Printing CR with footer only at the last page

    Hi! [hammer] Sorry im new in crystal report... anyway i tried to put the summary (total count of PC in every branch) in report footer but its not working. Its a summary of all pc in every branches grouped into department. How do i do that? HELP! [pc] Regards, Arnel
  15. SpeakUp

    How to integrate crystal report using Visual Basic 6.0

    Thanks Buddy i got it. Its working already...[cheers]
  16. SpeakUp

    How to integrate crystal report using Visual Basic 6.0

    Thanks Buddy i got it. Its working already...
  17. SpeakUp

    Printing CR with footer only at the last page

    Hi! Thanks for the reply... actually im using the crystal report ocx in vb. Here's my code... Dim sBranch as String sBranch = "{tComputers.Branch}='" & cboBranch & "'" Cr1.ReportFileName = "\\mnlpdc\......\PCList.rpt" Cr1.DiscardSaveData = True...
  18. SpeakUp

    How to integrate crystal report using Visual Basic 6.0

    Actually i made the report and it goes like this... Cr1.ReportFileName=app.path & "\inv.rpt" Cr1.DiscardSaveData = True Cr1.WindowState = crptMaximized Cr1.Action = 1 I have a combobox with branches and the code goes like this... set rs = db.OpenRecordset("SELECT * FROM...
  19. SpeakUp

    How to integrate crystal report using Visual Basic 6.0

    I had this program using Data Report in Visual Basic and im trying to use Crystal Report 7.0 but the problem is how can i filter the data using visual basic from my Crystal Report. Any help is greatly appreciated.... Thanks

Part and Inventory Search

Back
Top