Recent content by Johny

  1. Johny

    scroll excel sheet from Access

    Hello, I got an unbound OLE object on my access form that holds the excel sheet. The unbound object is disabled and locked so the user can not click in it (otherwise the menu's of Excel appear) Now.. when I paste data onto the sheet through code, sometimes the object isn't big enough to display...
  2. Johny

    popup menu (custom toolbar)

    thanx man. Just what I needed
  3. Johny

    popup menu (custom toolbar)

    When the user clicks an item in my custom toolbar, which event does he trigger? How can I capture which item he selected ?
  4. Johny

    General option?

    The person who made the access tool
  5. Johny

    General option?

    ok now I had the briljant idea to just ask him and it works now. I had to execute the following line again: DoCmd.SetWarnings true
  6. Johny

    General option?

    I got an MS Access 2003 db which I think has an general option disbabled or so dnno, here's the case: When I create a query, and choose to close the query (just be clicking the "X" button at the top), Access doesn't ask me to save the query or not.. it directly displays the box to fill in the...
  7. Johny

    Need some advice

    Well the program already exists and it works perfectly with those 20 comboboxes. The person who programmed it, just declared each afterupdate event of the combobox to construct the sql string and execute it when pushing the 'Search' button. I just started to rewrite the whole program because...
  8. Johny

    Need some advice

    You misunderstood. I have to adapt an existing access appl. The form exists of +- 20 comboboxes. But now the users want to choose multiple values for each field. So I am askin' if someone knows a solution for this because I can't just change them into 20 listboxes, the form is already to...
  9. Johny

    autonumber when table is created

    You can do this without programming: 1. Make a temporary table 'tblTemp' 2. Make a copy of 'tblTemp' and include 1 autoincrement field and name it 'tblTABLE1' 3. Make your make-table-query that makes 'tblTemp' 4. Make an append query to append all records from 'tblTemp' to 'tblTABLE1'
  10. Johny

    Null Value & DAvg

    You can also filter out the null values of that field if you specify it in the criteria parameter btw LED from BooZZe?
  11. Johny

    Add to list

    Well, I'd do it like this (dnno if it's the best way): you can specify the tag property of each imageframe you want in the listbox. Then you iterate through each control on your form and check the tag property. You can name your imageframes White Rose, Red Rose and Yelloe Rose so you just have...
  12. Johny

    Add to list

    I don't know exactly what you want. Are the pictures stored on the HD or are they placed on the form in imageframes? Otherwise ya can write a function to read a directory on your HD and list all files, which ya can show in your listbox. If it's this you want, I got the code for you
  13. Johny

    format number within text string

    Why not entering each data in a separate textfield? 1 for name (restrict to only textinput) 1 for date (set the inputmask to 'short date') 1 for age (restrict to only numerical input and max 99?)
  14. Johny

    Need some advice

    Anyone?___
  15. Johny

    Choosing values from a list box

    something like: Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("SELECT Selected FROM tblTABLENAME WHERE ID=" & Me.lb1) With rs .Edit .Fields("Selected") = IIf(.Fields("Selected"), False, True) .Update .Close End With me.lb1.requery...
Top Bottom