Recent content by goppo

  1. G

    Using VBA to open the Form Wizard

    DoCmd.RunCommand acCmdNewObjectForm
  2. G

    Running a Delete Query on Prompt

    DELETE ClientIR.ClientID FROM ClientIR WHERE (((ClientIR.ClientID)=" & ClientID & "));"
  3. G

    CRAXDRT help

    Hy everybody, i work on a code that search for rpt file and get tehnical description on them.(server, databases, tables, etc) I use CRAXDRT class for this. do anyone knows how do I get type of report source. is tabel, or view or stored procedures? I canot get from sql server because some of...
  4. G

    Help with using VBA to create a table from a pass-through query

    in access in tools -> option -> tab general you have an option "Compact on close"
  5. G

    can someone please take a look at this code for me

    better try with case... it's easy to manipulate later...
  6. G

    Shell Command

    opent excel file and press Alt+F11 you will see what i mean
  7. G

    Not able to change decimal places as per code!

    look at this and tell me if i undestud corectly
  8. G

    Shell Command

    why do not put in excel code to run on open? Private Sub Workbook_Open() <code> End Sub
  9. G

    Not able to change decimal places as per code!

    not "Format ([txtEntryPrice].DecimalPlaces = 4)" use "Me.txtEntryPrice.DecimalPlaces = 4" try...
  10. G

    omitting msgboxes by deleting-query

    sorry for my mistake... is without "=" DoCmd.SetWarnings False
  11. G

    use other table to calculate values

    try this. I dont know if sintax is ok...
  12. G

    Filename picker

    and you call like this...
  13. G

    omitting msgboxes by deleting-query

    on begining of code put DoCmd.SetWarnings = False at the end put with true
  14. G

    Access and OLAP

    I wnat to retreive all "Initial catalog" from OLAP server. somebody can help me wih some code? I want to create an aplication wich can retreive from sepcific server all the databaese and cubes existing.
  15. G

    Check to see if 2 fields are filled in?

    here is in 97 format :)
See more
Back
Top Bottom