Search results

Hi again all, So I have found two methods of doing this, the simpler but less reliable is using Sendkeys and I have this working. The other method is using ADO objects as shown in this ling (the linked code is for Excel but is a good starting point for figuring out how to do it in Access)...

Ahh, excellent. I don't know anything about that yet, but the sendkeys are all ready driving me up the wall so I will look into it now (well probably monday as it is very nearly hometime, yey!), sounds much more promising. Thanks

Okay, just a quick further update. I have been looking into the SendKeys method, but primarily I can't get this to work (although it does work when I create it as a macro but not in VBA) and having a look round the internet it appears to be a very buggy method, but I haven't found any sort of...

By the way I have now found the ActiveX Microsoft web brouser control, so I now have the page I want opening in a form, whish seem slike a good start. Am now looking into how to control it using VBA. I am assuming now that this is possible, please correct me if I'm wrong. Also the report...

Hi, I am wondering if it is possible to automate adding data to an Internet/Intranet (this is on the companay Intranet) if you know that all Key presses required? Specifically I want to pull information off of our time booking system, to do this you have to open the web page then enter...

Glad you like it. I'm assuming by portable you mean so I don't have to re-write the code everytime I want to use it. I was planning on keeping the task field names with the <Letter Number> convention so that wouldn't involve too much retyping, but it would be great if you could just cut and...

Oh I know why that is. It's becasue I just changed the caption of the task that appears in "Complete" and on it's control source so you culd be unchecking an earlier task and then the code (rightly in it's mind) thinks that you have not completed all the required tasks. The code will not have...

Oh really? I will have a look at that. It's probably due to how I've related the tasks to the statues (a miss-match between the code and the the status to which the tasks actually belong). You should be able to go back a level if you uncheck a task

Also I have no idea if we will need proof that tasks have been done, for example checking for hyperlinks to documents and so forth. I sense this could get quite complex, but hey it'll be a learning experience. The test will be to be able to get something with the desired capabilities that...

Erm, Currently they just change the status back one, nothing happens to the tasks. I'm not too sure how that will need to work in reality yet, like whether it should reset all tasks later than the current status if the status is lowered or if they can still be classed as done. I am assuming...

Thanks, Have uploaded the working sample database on the original thread, now to get on with sorting out the rest of this mess!

Okay so this is what I have now, and it seems to work, So unless anyone can see any obvious flaws that could be a problem later withthis method I think I will stick with it as this was I can add the tasks as fields in the main project table simplifying the need to have tasks for each project...

Simple as that. Beautiful.

I have a form with three checkboxes on it, behind the form is some code that changes the control source of the checkboxes depending on the value in anotehr field. The code seems to run okay (that is it doesn't crash) but the checkboxes on the form do not appear to be enabled. At least they...

Okay, so I have attached two database projects. One "Structure (again)" or something like that is based on your design, it cureenetly doesn't work fully as it only has one set of tasks so all the projects have the same tasks completed, which is obviously not satisfactory but I am assuming that...

I thought about that, the difficulty arrises in that projects will not necessarily be advanced to the next status as soon as all tasks are performed. I could add an extra task with the sole purpose of advancing the project but I'm not sure if that might confuse the managers using it. Also it's...

Hey thanks for that. having just had a quick look at it, I very much like the design of the form so think I will be using something like that. I have managed to write a rather clunky but effective code to limit changes to the status when the task have not been completed (only when all tasks...

Thanks so much, I will keep on at it myself too but not sure I'll get anyway and time soon. Just another quick thought: Was just thinking about this point. Is there any advantage in having them as seperate tables. I could just put the tasks as fields in the main project table that way...

That does sound the type of thing I need. I do need to state that I am very new to Access at the moment. I kinda agreed to the project as I have reasonable experience with Excel and Excel VBA and I figured "so how hard can it be?" am now finding the answer is "pretty d*am hard!" Anyway, so...

Firstly sorry for the slightly confusing title, was a bit stuck on how to summarise in one scentance. Basically I was hoping someone could advise me on the best structure to use for part of the database. The area working on is this. There are several projects, each project can be in anyone...