Search results for query: *

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...

Hey. Had the same problem as you had when trying to create a report by using the wizard or just plain new report, and having a query as the source from which it should get the data. However for me it worked by going to the "query area" and rightclicking the query that the report...

Thank you

Hey. I would like to be able to store a value feeded in to a textbox in two different tables in the same time? This concerns actually the primary key. Lets say I have two forms based on different tables and then I fill in the first firm and save it. It saves the information but then when I...

Oh thank you finally precisely what I was looking for I think I have tested the runcommand function as before but it didn't find any commands because I didn't open the subform first. I think it was that, anyway I got it working now. If I could I would give five stars, but can only give you one...

Yes I actually have the button yes. As I have discribed it functions and if I create a similar button on the subform it functions also. But can't get this to duplicate both records, or call the other button or something. The subroutine behind it is this: Private Sub duplicate_record_Click() On...