Recent content by dejanc

  1. D

    Insert/update values into linked table (linked from sql server via odbc connection)

    Thanks for reply. I have found that I was missing primary key field, and timestamp.
  2. D

    Insert/update values into linked table (linked from sql server via odbc connection)

    Hello, I would like to found how to insert values into Ms Access linked table? Table linked from sql server, with odbc connection. Thanks in advance for help...
  3. D

    How to refresh form gridview after insert into?

    I have found solution. So, if someone need it, can take it...:-) Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim TEST = New WindowsApplication1.IdisDataSetTableAdapters.Queri esTableAdapter TEST.InsertQuery()...
  4. D

    How to refresh form gridview after insert into?

    Hi , I have a form with gridview data with database data. With query I run INSERT INTO from one table into another, with button. I would like when I run procedure, also reset/update/refresh gridview with new import data??!! For info, I have try with some methods, such as me. gridview.refresh()...
  5. D

    Set date as first row in .xls file when export it from query???

    Hi, I have an issue, but do not know how to solve it. I have a sample database (see attachment) which I will filter with query/sql by date, and after "query run" export it into .xls. I have three dates from 1.jan - 3.jan. And I would like to export to excel as those three dates will be...
  6. D

    How to uncheck all CheckBoxes in form?

    I have multiple checkboxes in form, and they are just as objects in form. Note related to any table. And I would like all unchecked with button, to call query or procudure, etc... See attachment... Thanks in advance for help...
  7. D

    Need to someone to check VB code!?

    you are total right...thanks
  8. D

    Need to someone to check VB code!?

    Hi everyone, I have form with a few checkboxes, and button. With checkboxes I checked fields, and which are then exported into excel with button. But something is wrong with code, because when run code it open selection box to enter BirthDay parameter. Open attachment... thank you in...
  9. D

    sql mid (). Is it possible?!

    Have another question. With LIKE operator I got it what I want. But, I want to filter query from form with Listbox. I know how to do that, but in this case I dont know where to put FORMS!FORM1!LISTBOX Please see print screen from access..
  10. D

    sql mid (). Is it possible?!

    thanks for quick reply I will try
  11. D

    sql mid (). Is it possible?!

    Hello, I have a question. I need to pull out records, but some records have different nr. of characters or they are write oposite. And I need get them in the same group. I will write down examples... record: iron-EKO ironEKO EKOiron How can I get all 3 records in the same query by word EKO...
  12. D

    Filter ListBox with ComboBox?!

    Thanks GalaxiomAtHom for help :-) !!!
  13. D

    Filter ListBox with ComboBox?!

    First, thanks for help GalaxiomAtHom sorry, I have send wrong zip file. here is a new one. Can you please check this one?
  14. D

    Filter ListBox with ComboBox?!

    Hello all, I need to have a comboBox which will filter listBox. I have create a query, relationship, and put AfterUpdate VB code on comboBox. But wont work, and listbox getting a blank values...?! I have attached an example.... Thanks anyone in advance for help....!!!
  15. D

    abscombo.ocx, version 26.0 ????!!!!

    thanks HiTechCoach
Top Bottom