Recent content by Aenon

Greetings! I am having a slight issue with one of my forms that cant be closed. Please download the attached database in order to see what i mean :) I have tried to make macros that will open the form called frmLogHours. Both the cmd button "New Work Item" and when i press the ID in a source...

Thanks for your help everyone! In the end I just went with Simons solution of using two forms. I just could not make the Visual Basic script to work. I dont think I understand how that works well enough to pull it of as of right now. :rolleyes:

Im not really sure I understand exactly what you are talking about at the start of the post there Simon. But i do like your suggestion about just using two forms. I will have to look into that if i cannot make John's script work. Thanks :)

I have tried now to change the code in the places you specify. However, all records dissapear, both the ones that have already been entered, and the new ones i want to enter. The list in the Combo box is empty. The code at the end of the post is exactly as i have written it in my code builder...

Thanks John! Although I have waited since friday, so it will be 72 hours and 10 minutes :p Not that it really mattered, i wasnt in a rush. I just want to make this database work eventually. I see that you are speaking on a level waaaay above mine here though. I dont really understand how to...

Im trying again. Bump :)

Right... uhm... I'm really not that proficient in Access that I have any idea how to do that :o Any chance you could specify? Or show me in the database i uploaded?

Thanks NickHa. However i already tried that too :( This will give the same result. Once I save the new project list after making a project inactive, the WHERE clause will also remove the project code from all cells it has already been listed in the tblWorkHours. Do i need to make other changes...

Greetings people of Access World Forums! I have a small issue with a time sheet database. I started making a database some time ago, but then i came over this awesome premade database which you can download directly from access. So i made some tweaks to make it fit for my purposes and stuff...

Great! You sir, are king :) Thanks a lot! Just the solution i was looking for.

Greetings! I have uploaded the database I am speaking of. Access it through the link below. Please look at this file for details in the structure of my database to get the necessary info if you are able to help me. I am having an issue with a query im trying to set up in a hose tracking...

Um, that did not really that much sense to me :S Are you trying to point out some mistake in your demo? If that is the case i have no idea where that sub-stuff is. Could you just nudge me in the right direction considering my query? So that it will do the job i want it to do? Thank you! :)

I cant really make it just like you do in the demo, as it wont include all the hoses that i have which i am missing data on, but are still laying around at different locations as spares. And I dont really understand that whole event thing that you made in the "asset" box. The reason i want it...

You are awesome MStef! I took the function you used in the totals celland i figured i could use it for in a query that had the exact structure i wanted. However, i cant make it work exactly the way i want. Right now i am just trying to list the total cuttings for each hose in a normal...

Greetings! I am trying to create forms to interact with a database i made to track usage of assets. In my tables i have linked many of my assets to each other by using their unique ID numbers. For instance the ID number of my assets are linked to a foreign key in a locations table. This way i...