Recent content by Takstein

i solved it with a work around! it seems when i base the sub form on a table it automatically updates the child fields with value of which the master is linked (and this was not visible in my form). But this does not happen when i change the field list on the sub form to a query. So what i...

Thank you for your reply! Isn't it? I thought if the link master fields and link child fields was set up it would work? The subform query was based on tblDeliverables(i just added two summary fields from another query ). And it works just fine if I change it back to be based on...

Hi everybody! I have a problem that is way past my understanding of access at the moment. I will do my best to explain and hope somebody has any ideas! I have a form ProjectManager which is based on the table tblProjects and tblDeliverables (one project can have many deliverables). The subform...

Hi and thanks for the reply! Yes, i heard that from several people. So what i did was use the environ() function and an accesslevel field in the database to tailor the setups! regards, Arnstein

The Environ function seems elegant and EXACTLY what i need. Thanks!:D

Hi! I am making a database for our department for resource planning. I have two versions of this one, where one is the master (With everyting) and one "user" version, where the idea is that the employee can only see hes/her data and have very limited access. The idea of the user version is that...

Hi! I have a database where i want two editoins; one for the users and one for the managers. With the users one i started with a blank database and just exported the forms i wanted from the main database. The problem is however that the forms subforms does not "tag along"! So in the new...

FYI john woody, I did manage to convert the accdb to mdb like you said as well, so that solution also worked. Thanks!

That would be the easiest and most elegant solution I believe! Thanks!

I have tried that actually..However, I was so "smart" when i started that i used a template from microsoft which contains attachements in the tables so that would not be possible. I have tried to remove the attachement fields but still i wasn't able to convert it to .mdb. Maybe there's some...

Hi all! I've got a problem; our office is still running on Access 2003. Before Christmas I started working on an application for planning work hours for the department. Before I started I heard we are updating to Win7 and new Office, where i checked and I was told to develop this on Access...

Getting closer! I have managed to make something in the query now that actually works - somehow. the problem is that the query returns many similar entries of the sum. How can i display only one per week? The problem is that when i use my DSum coloumn in a chart it can only show the Count...

Anybody have any input on this? Is my question understandable? Any help would be appreciated!

Hi everybody! I have made a database where i plan the company's resources in form of hours. The idea is that every employee will put in their own data for the upcoming 4 weeks. I do this in a table where i store employeeID, weeknumber, year, PlanneHoursUsed, ActualHoursUsed. This again i take...

Thank you for your input! This is actually very close to what i have already, i just never thought of putting week as one of the factors... I was thinkin a needed a ned "time" table... I haven't tried pivot tables before but will do that now! thanks for your help!