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. tekthis

    Monitor issue!

    Hi. I am having monitor issues. When I power up th PC the monitor makes a noise like it wants to turn on, but won't. The green power light is on. I then hooked up another monitor with a different cable and the same thing happened. The power is there, but nothing is displayed. I can...
  2. tekthis

    Search file and open...

    thanks...i just found that .filename a second ago...and it worked...thanks again
  3. tekthis

    Search file and open...

    thats not what im looking for...i just need the file that i have double-clicked from the FileListBox to open in notepad...since i have so many files i think i need to pass the one i selected through a parameter... Private Sub cmdSearchMod_Click() flbViewMod.Path = "C:\Test\"...
  4. tekthis

    Search file and open...

    hello...i have files that are stored in a folder...i created a program to retrieve all of the files in this folder and they are displayed in a FileListBox...when i double click on a certain file in the list i want to have it open up in Notepad...i have the search to work but i can't get the open...
  5. tekthis

    Auto fill textbox

    thanks for the reply pkailas...i have the combobox connected to the db and i have the on click already setup...i have it list names...i cant seem to figure out how to reference the fields to the selection i make from the combobox...i figure i need to index the fields and relate them to the...
  6. tekthis

    Auto fill textbox

    hello...i have a dbcombo that gets populated by using the "Data" tool...when i select an item in the dbcombo i want to fill in the textboxes with the fields that correspond with that selection...
  7. tekthis

    Insert error

    thanks for the reply, here's a star fredericofonseca...i think im going to go with this and try to figure it out...the only thing is that i don't know what you mean by "last_grid_row"...i don't see that anywhere in the grid properties...here is my code with the parameter...
  8. tekthis

    Insert error

    thanks frederico fonseca...i went ahead and restructured my code and i got it to insert in the database but, it just inserts the first row, which makes sense since i only told it to...what if i wanted to insert the entire column of each field in the temptable??? is that possible??? thanks again...
  9. tekthis

    Insert error

    hello... im trying to insert information from a datagrid into a TempTbl but, i keep getting an error involving "Number of query values and destination fields aren't the same"...here is the code im using for that... -------------------------------------------------- Private Sub cmdSave_Click()...
  10. tekthis

    Datagrid to temptbl!!!

    hi... it is really important that i get this completed... i have a database that has 3 tables...1 of the tables is empty; i use it as a temp table... i wrote a program that retrieves certain information from the 2 tables with data and puts the info in a datagrid for updating...after the user...
  11. tekthis

    Combine info???

    i understand the thought process...the thing is i have 2 tables that are getting populated in the datagrid...then i want to push a button to have that data that is in the "datagrid" to the temp table... dont worry about the code...someone else may have run into this situation before...thanks...
  12. tekthis

    Combine info???

    yes...thanks for the reply deanconsulting...
  13. tekthis

    Combine info???

    hi...i have 2 tables in a database that i open in a datagrid and do some changes if needed... after i was done with those changes i was wondering if it were possible to save those changes and combined columns, from a command button, in a temp table??? thanks for help...
  14. tekthis

    List certain tables

    perfect...thanks DrJavaJoe...heres a star...
  15. tekthis

    List certain tables

    i have a program that i search a database and it populates a combobox with all of the tables... is it possible for me to add only certain tables and not all of them??? the tables i want shown all have 2004 in their name...i.e. August2004, Sept2004, etc. (if this info helps) i tired this...
  16. tekthis

    Select database

    i got the error to go away... i just closed RS and con in the form load...i should have noticed that sooner...thanks all for your help!!!!
  17. tekthis

    Select database

    that work!!! it inserted the data in the table i selected from the db... the only problem i have now is that i get an error after its says that the item was added successfully... the error reads "Operation is not allowed when the object is open." heres the code it points to... Private Sub...
  18. tekthis

    Select database

    sorry i meant to include... Dim db As Database Dim rs2 As Recordset Debug.Print cmbTables.Text doesn't say anything...i keep getting a type mismatch error...hope this helps...thanks
  19. tekthis

    Select database

    here is the code i use for the connection and adding... Public Sub AddIt() Set db = OpenDatabase("C:\test\test.mdb") Set rs2 = db.OpenRecordset(cmbTables.Text, dbOpenDynaset) TempName = txtName.Text TempDate = txtDate.Text TempNum = txtNum.Text TempOrder = txtOrder.Text rs2.AddNew rs2!Name =...
  20. tekthis

    Select database

    that worked...but it now gives me a Type Mismatch error... thanks for your reply...

Part and Inventory Search

Back
Top