Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. irishjoe

    Logging remote access

    I have a database which logs when a user opens the database and modifies certain things. The problem arises when another application connects to the database and changes the data that way. We have 1 guy who uses excel to read data and modify data. I would like to be able to run code in the...
  2. irishjoe

    Treeview problem

    I've deleted the tree, added a new one and re-doing how the tree filters the forms. It could be something in there that is messing it up. I have a couple of other databases that use treeviews and not had any problems like that with them so no harm in re-writing the code to do it the way I...
  3. irishjoe

    Treeview problem

    Yep, thats what I have got.
  4. irishjoe

    Treeview problem

    How do I find what version I have? My access version is 11.8166.8221 SP3
  5. irishjoe

    Treeview problem

    Got rid of the macro and made an empty form that would auto load and load the main menu and then close itself. No go there either. Says I'm not allowed to do that in an MDE. Works fine in an MDB. Private Sub Form_Load() openTree Form_frmStarter.SetFocus DoCmd.Close End Sub...
  6. irishjoe

    Treeview problem

    It did work.... until I made a MDE to send to the client. I made a macro to open the main menu in design view then open in form view and called it Autoexec so it would automatically run. But the MDE came back and said that action wasn't allowed in an MDE database. I've never used a...
  7. irishjoe

    Treeview problem

    I tried something like that before but didn't know where to put it. I tried creating a form with that code on the onload part then I would hide the first form. But it didn't work. I did just get one bit working tho... Yes, macros are evil and should be steered clear off but I created one to...
  8. irishjoe

    Treeview problem

    ...all the code of the onclick so it just looks something like this… Private Sub axTreeView_NodeClick(ByVal node As Object) Debug.print “Clicked ***” End Sub I don’t know what a custom class would be, but it could be hidden in there somewhere, I didn’t create the database, I’m just making...
  9. irishjoe

    Treeview problem

    Ok, this is going to seem like a stupid problem but bare with me… I have a 2002/3 database with a treeview on the left which filters all the forms to the right. 90% of the time, it works great. The other 10% is something else. It seems not to register the clicking in the tree and even if I...
  10. irishjoe

    A2000: On Error Handling Not Working

    Cheers Ed, thought I was going crazy for a while! That fixed the problem nicely...
  11. irishjoe

    Connecting to localhost from another computer

    My jove, I think you have it! I couldn't switch the XP firewall off but I added a custom port in for port 80 and it let the remote computers connect to the Dell2006-1 computer that had IIS on it. I could have sworn I checked the firewall, but was ages ago so might have been for something else...
  12. irishjoe

    Connecting to localhost from another computer

    Sorry for the confusion, I’m confusing myself a lot of the time!!! iis is running on Dell2006-1 and I am trying to access it from Dell2004-1. I have tried typing in the Dell2006-1 IP address into Internet explorer like this http://10.0.0.35/ but still comes back the same as before. Both...
  13. irishjoe

    Connecting to localhost from another computer

    ...allowing guest access or something because I did this a couple of years ago at home and it worked fine first time without any problems. Notes: * I am using the default firewall on all machines and they are running XP. * The network is a domain in my work. (Not a workgroup.) * I can browse...
  14. irishjoe

    Treeview inquiry

    Yeah, I had that problem too. You have to start the key with a letter or it trys to use it as a number or something. Don't really know why, just know to start each one with a letter from now on. Think you helped by making me put the problem down on paper and pointed me in the right direction...
  15. irishjoe

    Treeview inquiry

    I may or not have fixed the problem. This was my chain of thought…. I have deleted the treeview and added it again and it can’t connect to the ImageList correctly. But when I go into design mode then into form mode, it works but if you go straight in, it can’t find the ImageList. So, that...
  16. irishjoe

    Treeview inquiry

    Sorry for not replying, for some reason Outlook started putting the email notifications in a spam folder instead of my inbox. I was trying to load the imagelist your way instead of thru the design interface but having problems. Do I need to add references to the code to be able to reference the...
  17. irishjoe

    Treeview inquiry

    Are you sure you have to have code for the treeview to use the imagelist? A have made a database up (a long time ago) that had a treeview with an imagelist and I didn’t put in any code. For that database, to add a node to the top level, I had filterTree.Nodes.Add , 4, "HH1", "1- Piping"...
  18. irishjoe

    Shrink the size of my database

    Try creating a new blank database then import all the tables, queries, etc into the new one and see if its any smaller.
  19. irishjoe

    Connection String In Excel

    Ah sorry mate, never done that before...
  20. irishjoe

    Connection String In Excel

    If you change the DBQ line to this, it might work... DBQ=CurrentProject.Path & "\MCD.mdb"

Part and Inventory Search

Back
Top