Recent content by xollef

Oops Maybe it was because i asked it here that I figured it out this fast. I got it working like this: Dim workid, search_criteria, year_abbreviation As String Dim year As Date year = Date year_abbreviation = Right(year, 2) search_criteria = year_abbreviation & "_???" workid =...

Hello I want to create an incrementing number in this format YY_001 YY_002 Where YY is the year, thereby order 28 this year looks like this 04_028 I lookup the value with a dmax function: And i get this to work workid = DMax("[work_id]", "orders", "[work_id] Like '04_???'") But this wont...

Well now thank you so far, now I have a subform with checkboxes, and you can check them correctly. But next step / problem, how do I save the checked boxes / tests into another table orders_tests. The subform uses tests table as source and only the checked I want to store into the orders_tests...

Check this link out. Ther it is explained how to go about it. http://support.microsoft.com/?kbid=278379

Thanks for the reply, I am aware that I should use A subform, my problem is I don't know how to design the form so that it works as I want. If I design it normally it will only show one record per time / if you design it as a datasheet, then you can view all records directly, but then if i add...

I have had the same problem that hyperlinks don't work when clicked on. I don't know why but using this little peace of code it started to work: Function openfile() Dim fso As Object Set fso = CreateObject("Scripting.FileSystemObject") If Not IsNull(Forms![Searchresults]![Search...

Well orders_tests will only store wich tests belong to the order. And there will be one row for each test connected to the order with order_id The problem is I can't get the tests displayed with a checkbox on the form, one checkbox for each test in the test table. So when someone is filling in...

Hello I have a mainform that contains information on orders stored in an ordertable, then for each order i want to be able to store plenty of tests for that order. I have an test table where all the different tests are. They can be manipulated, added new edited or deleted. Then the third table...

Just had to add I managed to create this: (Nz(MonthA, 0) + Nz(MonthB, 0) + Nz(MonthC, 0) + ...) / (n + IsNull(MonthA) + IsNull(MonthB) + IsNull(MonthC) + ...) Without it giving #Num! error if all fields are empty. You don't have to write VBA to accomplish it. This is my expression that...

Hey. I have a form that has 5 textboxfields on it which gives the criteries to a Query. The query is after that inserted to the form as a subform so that you can see the results of the query on the form after you update it. So now my question is that when I have 5 fields for different...

Hey. I have a form that has 5 textboxfields on it which gives the criteries to a Query. The query is after that inserted to the form as a subform so that you can see the results of the query on the form after you update it. So now my question is that when I have 5 fields for different...

Hello. If I understood you correctly you need to create a query that has for criteria the text you type in the text box on your form. To be able to view the results on the same form you will have to insert the query as a subform on the form and then it will display the results you want. So...

Hello again. Thank you again. No but this time it works BIG THANKS! My solution became this: This event that I put on the Oncurrent event works, Then I got an idea. As you can see there is a small difference between the IF statements in the events. Onopen event: If IsNull...

Hello Thanks for the answer, but (there is always a but : ) it doesn't work. Ok to explain: I have assigned it to the on open event of the form. And it works if I leave out the if statement. Meaning that if I only enable it: Me![nameofbutton].Enabled = True it works but as you can figure...

Hello I have a form and on it some buttons and button, the form button is disabled. Because I have a textbox where you should fill in a value and then save that value before you can open the form. So when pressing the save button it saves the value and then enables the form button. But then...