Search results

Sure :) Thank you very much for all your support but I am confused: you mean this DoCmd.OpenForm "cazzola_2", , , "EER = '" & Me.ControlName & " # " So basically I am know in cazzola_1 form and I want now to go to cazzola_2 and the record I want open the cazzola_2 form for is contained in...

It should look for the ID I am already workign on. So if with the first button "Go to record" I managed to go to record 3, nw when I click "go to form 2" I want it to go to the form 2 for record 3.

mmm...name of the textbox? Is not ID a field only? so how can I know the name of the textbox holding ID?

Oh, well, here I am:) So, this is the line of code I wrote Private Sub name_Click() DoCmd.OpenForm " cazzola_2 ", , , " ID = " & Me.ControlName & " ' " End Sub And the message that I get when I do the debug is "Compile Error: Method or data member not found"

Yes, basically, if I am on form 1 for the record No. 13 (Primary Key) if I save the record and then go to form 2, the data that I will be now entering on form 2 will be entered as belonging to the 1st record ever of the database, it will not be considered as part of the record number 13. So...

I am reading the link...but takes me time to understand. So basically should I change the code I wrote for the 'Go to record button'? ah, no, wait, I should change the code for the button at the bottom of the page which says "Go to next section'. Correct? Now it will take me some time to figure...

What do you mean by filtering it down? On the forms I did not put the 'Go to record' button...

No, well I did not refuse to drink it just took me lot of time to understand and eventually make work it out :) So I eventually managed to create a nice form which brings me back to the record I want to go to. This is how it looks: Now the big problem is: suppose I want to go back to the...

Many thanks, yes, I found out the elipses now :) So basically I have to create a macro: but I have no clue on how to programme in VBA "Open the fomr X for the record ID XXX"

Thanks a lot but I am unfortunately able to undertsand very little of what is written in that page you linked me...:( Plus, I dont get any elipses on the button. If I right click on it, the menu gives me the option Build event.

Easy, I have the unique ID. Wha do you mean by this? should I create another form? if so...how should I tell access how X record? Could you please give me mor edetails? Many thanks!

I managed to do that: I simply created more than 1 form and then I connected all of them using the Buttons. Now I just have to make sure it works :)

Hi everyone :), I have developped a table and some forms reated to that. Since the main survey is quite long, I developed 4 forms to enter the data. Now I have a question related to data entry. Suppose I start entering data for one record and I decide not to fill up all the 4 forms, I simply...

Oh well, thats fantastic! Thats precisely what I need!! So how should I go about it? Should I first create more than one form and then link them? Also, when I created the button, it did not give me the option "Go to the next section" but only "go to the next record" and/or simialr which is...

Ok but what shal I do next? whats the purpose of the button? Should this send me to the next form?

What so you mean by physical form? I created this form using Create>Form and it popped up automatically. But the last fields are all squeezed. I would rather not do that as I dont need to split the dataset. I mean, as my fields are well below the limit of 255, I think it is just better keep all...

Hi everyone! I am new to Access and I am developing a form. I have already read and found useful resources on internet but there is something I am not able to sort out. I have seen that the limit of fields I can enter in Access is 255 and my survey is far below that number. So no issue at all...

...Thanks, thats precisely my aim. But I guess that the fact that I still dont have the proper terminology is because I am learning...and there is no way to learn the proper terminology if not by attempting to describe something with words. Basically if I knew the appropriate terminology...

Well, first I created the fields in Date view, then I saved it and then I went Create>Form. Thanks, that was good, I watched it and I did learn some new tips. However I still strugle with some of the things I need to do... For example, I entered in the Data view all the fields that I need...

Create> Form It automatically gives me a form Yes, sorry,I meant any table field Access 2007