Search results

  1. Luka

    Upgrade 2003 -> 2007 problem

    Hi, I have a problem with custom menubar that is used in my Access 2003 database. I have upgraded to Access 2007 and this menu appered in Add-in ribbon. Somehow i deleted that menu in add-in but now when i open database in access 2007 i get error: MS Access can not find macro or procedure Menu...
  2. Luka

    Macro group rows

    Hi everyone. I have excel file with structure: a bb ccc dd e What I want to achieve is to have a macro that will group all this rows. I am currently using this code: Sub Group() Dim i, j As Integer i = 8 Cells(i, 1).Select While Cells(i, 1).Text <> "" For j = 1 To...
  3. Luka

    Print to star SP200

    Hi, anyone have some experiences with seting and printing reports to Star SP200 printer? I can't see installed printer i can only get activex control in access (which means that driver is installed).
  4. Luka

    mscomm runtime problem

    Hi everyone, My db uses activex control and mscomm to communicate with external device. Db runs ok on access 2003 and 2007 version but i can't get it to run in access runtime 2007 (its on different computer). I tested external device on that computer and connection is ok. But access db giver me...
  5. Luka

    Is it possible - search?

    Hi everyone, I have this situation. Main form 1 subform - child to mainform (fields are NOT connected with ID) 2 subform - child to 1 subform (fields are connected with ID) Main form is used for searchig 1 first subform shows item records 2 subform shows some data connected to items Search...
  6. Luka

    Customer dispay on com port

    Hi, I'm using this code sending data on customer display over com port: Open "Com2:" For Output As #1 Print #1, "Test" Close #1 The problem is that display is showing some strange characters. Something like: CCCCCCCC... Any ideas how to fix that? thanx in advance
  7. Luka

    Loop update table

    Hi everyone I have a form and a subform both linked to the table. Subform has increment line number. 1 - first record 2 - second record 3 third record,... The question is how to reset increment line numbers in subform if i delete second record? Soo the result would be: 1 - first record 2 -...
  8. Luka

    Form/subform, Is it possible?

    Hi, I have main form with subform. Is it possible to open form on specific record, like main form ID = 2, and then add records to subform? I keep getting error (Changes were not succesful... error 3022). For example: I would like to open form Invoce and I want it to open on Invoce number "2"...
  9. Luka

    Excel startup

    Hi, this is not really a problem but anyway. I' m getting data into excel (pivot table) from access db. Pivot table is set to refresh data from access every time at startup, but at the startup I get this form in which I must confirm data refresh. Is it possible that this form is somehow shut...
  10. Luka

    UCase problem

    Hi, I'm using code which convertes names of costumer into upper case when user type the name into control. But there is a problem. If letters č,š,ž are pressed they are not converted to upper case. Code: Private Sub Customer_KeyPress(KeyAscii As Integer) On Error Resume Next KeyAscii =...
Top Bottom