Search results

  1. skea

    Slang Helper

    Hope you don't mean Forms!Form1!controls(1) Ditto controls(2) Ditto controls(3) :D :D :D :D :D
  2. skea

    Slang Helper

    There quite a number of slangs used in here that many of us don't understand. May this thread help us to know what people mean:rolleyes: For instance, Ditto?:confused: what does it mean?
  3. skea

    Removing missing Reference with VBA

    Here is something for a start.Its but not backward compartible so it didnt help me much too. Sub FixUpRefs() Dim loRef As Reference Dim strPath As String Dim strMessage As String Dim strTitle As String Dim bytButtons As Byte On Error Resume Next For Each...
  4. skea

    API Call To Change a File to Read Only

    The problem with me is that my applications are used both at the main office and also remote locations. But we have very stubbon Data Clerks who keep on shipping my applications to different locations and even to the worst, out of the office.:o This puts me back because at deployment,a shortcut...
  5. skea

    API Call To Change a File to Read Only

    In the same context, wouldnt like my access file to be moved or even to the worst, copied from its installation folder. How can i achieve this.:rolleyes:
  6. skea

    I’ve been inventing again.

    Be fast.:)
  7. skea

    Scrollig SelectedItem in LB

    I think i saw your Qtn way back before i tried it out myself. But to get you right, when you look in the screenshots thread in the samples forum, i implement this in my database reporter. I search for something, then the listbox scrolls it in visibility. Is that what you meant? If so try it out...
  8. skea

    Screenshots - Part 2

    Jordan, why would you really mess up the image then post it. It looks useless to me. I thought this thread is meant to help people learn from others.If one feels that his image is too private to be posted on cyber-space, i think it would be best to completely leave it. One question for you: Are...
  9. skea

    Forums now upgraded to new version

    I have noticed quite a number when you click post reply. The One which amazes me most is when you click the quick reply. Its very fast and direct. If you want to edit that post,it will take you to Quick edit in the same message. I suppose there quite a number deep-rooted in there. Compliments...
  10. skea

    Reinstating moderators

    Heehee.:D Dont you know why guys feel soo sad about thier post count bieng reduced!!:rolleyes: Look at yours and compare with that of SJ.
  11. skea

    Building A String From Multiple Records

    Once Again. This code is my hero. It saved my A** a great deal. Thanks A Million Peter.
  12. skea

    Forums now upgraded to new version

    Jon, thanks so much. Your effort is noticed. The New Features are great.
  13. skea

    Building A String From Multiple Records

    Thanks,It helped. Before i was appending data from another query and not a table. So now, i append from a table to another then run the query. Great for my detailed reports.:D
  14. skea

    Building A String From Multiple Records

    Ok. Peter, ive been playing around with you code but seems i cant get along unless i assign all fields in the old Table to the Function This is what iam trying to do Function MakeList() Dim rsOld As DAO.Recordset Dim rsNew As DAO.Recordset Dim strSql As String dim tmpInfrustructureID As Long...
  15. skea

    Building A String From Multiple Records

    I think one can, I will try and put under thy nose.
  16. skea

    Building A String From Multiple Records

    So, If one has more than 5 fields in a table, it implies that he has to reference all those fields in one module.
  17. skea

    Building A String From Multiple Records

    good work there peter. Thats another tool for me to play around with.:D
  18. skea

    Scrollig SelectedItem in LB

    I forgot to point out. For you to ahieve this, you will need to setFocus to the listbox.
  19. skea

    Scrollig SelectedItem in LB

    Use a For loop and listindex. It may not need to show on top, as long as its selected into visibility.
  20. skea

    Remote shutdown of a shared DB...

    Thanks Big Boy :D
Back
Top Bottom