Search results for query: *

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

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

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

Hello I have a mainform with a subform and I would like to have a button on the mainform with which creates duplicates of both forms records. Oh, a copy of all info into the new record, except the JobID that links the forms together. It is because there can be similar Jobs but they should be...

I have a main form which has many buttons on it which open other forms. What I want is an on activate event for the main form that will close all other forms open no matter what their names are and then after the event the mainform would be the only one open anymore. Any ideas? There are the...

Hi I have a form with buttons on it. When i press a button it opens another form. I used the buttonwizard and created the button and there I linked the ID field that shows up on both forms so when pressing the button the other form opens with same record nr as in the "main form&quot...

Hello yeah stuck again. I have a main form with lots of subforms (approx. 30) that opens with buttons. They are linked by an autonumber it is displayed on the mainform, idfield. I want to open the subforms displaying the record that is currently in the idfield when by pressing the button...

I have a subform or will have actually, on it there is listed approximately 10 checkboxes. I want a button that when pressed all checkboxes get checked and the opposite when pressed again all checkboxes gets unchecked.It seems like it should be easy but I am stuck anyway.