Search results for query: *

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...

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...

Yep, thats what I have got.

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

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...

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...

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...

When I mean fix itself, it would suddenly start recognising the clicks out of the blue. Sometimes moving it from the server to the desktop would prompt it or someone else accessing it and then you access it and it would start working. I thought it might have something to do with the icons so I...

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...

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

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...

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...

Hi, I am having problems galore when trying to view pages on this computer from another. I can go to http://dell2006-1/localstart.asp and get the ‘Your web service is now running’ message so everything is fine there I think. I can remote desktop to another computer on the network and copy and...

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...

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...

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...

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"...

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

Ah sorry mate, never done that before...

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