Recent content by corentin

  1. corentin

    How to reference a Textbox by Query Criteria on a unbound Form displayed in Main Form ???

    Ok I have found the problem : the correct syntax that I have found by the report dataCountrolSource is : =[Forms]![Main_Form]![Form_View].[Form]![SearchBar] Thanks a lot for helping me Minty, have a nice day ! Corentin
  2. corentin

    How to reference a Textbox by Query Criteria on a unbound Form displayed in Main Form ???

    Thanks a lot for your reply but it doesn't work. I have still the enter parameter input box that is displaying. "Stock_Management" and "Main_Form" Forms are not linked at all. When I put the infomation of the TextBox into the inputbox, the query works. I think the problem comes only from the...
  3. corentin

    How to reference a Textbox by Query Criteria on a unbound Form displayed in Main Form ???

    Hello everybody, Bom dia, Let me explain my last problem on my project. I have a MainForm and other forms that are displayed on it with a subform view called "Form_View". Note that between MainForm and the other that I wantr to display, there are no links (Link Master Field and Link Chield...
  4. corentin

    How call On Load Event for a Form included in a Main Form ?

    Sorry guys I found the solution of the problem ! I just have to modify the On_Load Event by refering it to my main form !!!!
  5. corentin

    How call On Load Event for a Form included in a Main Form ?

    Ok thanks for this lighting explanation but I am beginner in Acess and I don't know now what you meant by "YourProcedureName" ... Here is the code that I did and doesn't work ... Private Sub Part_Click() Me.Form_View.SourceObject = "Add_New_Part" Me.Form_View.Form.Form_Load End Sub...
  6. corentin

    How call On Load Event for a Form included in a Main Form ?

    Thank you for your help bu I didn't understand the syntax well. What does subformcontrol means ? form is the current form where the subform is included ? I show you my vba code that displays well the form "Add_New_Part" from the main form called "Main_Form" but doesn't load it as I doubled...
  7. corentin

    How call On Load Event for a Form included in a Main Form ?

    Hello dear users, In order to finish my "MRP" project, I need your help. I have a mainfrom called Main_Form and an other form called Stock_Management. What I want is simple : display the Stock_Management form (when I click on a button) in the subform window of the mainform (that is working) but...
  8. corentin

    Problem to insert last autonumber record ID into an inster into statement in a loop ...

    Ok I didn't find the issue to that problem but my main problem is solved. Thank you to help me ! :)
  9. corentin

    Problem to insert last autonumber record ID into an inster into statement in a loop ...

    Thank you I have modified the code in order to be more lisible. I just can't populate the table "tbl_PO_Process" with the last ID from table "tbl_Production_Order" ... But the rest of code is working. What I want to do is populate a table with the last Production Order ID that has been...
  10. corentin

    Problem to insert last autonumber record ID into an inster into statement in a loop ...

    Thanks for your help arnelgp. I did what you adviced me but still the problem happens. Here I get : Run time error 3022 The problem is on : "CurrentDb.Execute strSQL3, dbFailOnError I am sure the problem come from the fact that system can not get the last ID proprely ... But can't solve the...
  11. corentin

    Problem to insert last autonumber record ID into an inster into statement in a loop ...

    Good morning users, I am facing to a hard problem (beginner in VBA code). What I need is to get the last record ID "Purchase_REF" field (autonumber incremented, primary key) from table "tbl_Production_Order" and put that value into an other table "tbl_PO_Process" (into a text field, primary...
  12. corentin

    Create QR code in access report

    Good afternoon, I am currently working on an access form and I would like it generates QR codes ... I have already downloaded xlQRCode database. It has worked the first time but now when I run it, there is a issue in the function InitQRCode (please, see the attachements). :confused: Do...
Top Bottom