Recent content by belfagor71

  1. B

    How to find a record?

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

    How to find a record?

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

    How to find a record?

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

    How to find a record?

    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"
  5. B

    How to find a record?

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

    How to find a record?

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

    How to find a record?

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

    How to find a record?

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

    How to find a record?

    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"
  10. B

    How to find a record?

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

    How to find a record?

    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!
  12. B

    Is there any limit to the number of fields in a form?

    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 :)
  13. B

    How to find a record?

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

    Is there any limit to the number of fields in a form?

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

    Is there any limit to the number of fields in a form?

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