Recent content by dannytuk_1982

Ok thanks namliam that makes it a lot clearer. I've had a look at this and created queries to produce the data I need. What I need to be clear on in my head now is how this all links together. To me so far I have a form that is linked to a query. When I insert new data or edit data in the...

Wow Thanks Guys!!! I always remember Analysis Of Algorithms and Computer Architecture from my uni days as the most long-winded sleep inducing lectures ever!!! However they did have a purpose and shouldn't be overlooked and I completely agree that the increases in processing power has...

Thanks namliam, I understand that this could cause performance issues and this is far from ideal and often overlooked, in SQL Server stuff like this is done using stored procedures. Does Access cater for anything similiar?

How? Which Control will do this?

Thanks for that, Ideally I would be doing something like this in .Net, however I've been asked if its possible in Access. However, I've hardly used Access and have been pleasantly surprised with its functionality!!! If I Implement the update query is there a way it can run every time a form is...

Hey, I need to update a field in a database table based on another field in that table. In fact I need to do it on a number of fields but one would be a start!! I managed to do it in a form using control source, however this will only display the data in the form and doesn't bind it to the...

Hi Thanks for your help, I've changed the final subform to a 1:Many basis and its solved the problem for me.

The 1st form is in a single form view that shows a certain problem with some machinery, it has a subform datasheet displaying any possible solutions, difficulty and cost of the solution etc. Inside this is another subsheet under a "+" symbol showing further information if the solution was...

The 3rd form is placed within the 2nd subform.

Hi Thanks for the reply, The Link Child/Master Fields are set to Work Id and pass ok from the 1st to the 2nd form, however the data isn't being passed to the 3rd form.

Hi I'm relatively new to access and have recently been creating a 3-tier database form. The Top Level of the form is used to capture data of a mechanical fault on an industrial site. This links to a subform that shows all proposed solutions for the problem, their cost and whether they have...