Search results

  1. I

    Update a datefield

    I see...makes sense now. Thank you, will do take it in consideration.
  2. I

    Update a datefield

    Sorry, that was a typo (Mistake), I just removed it in the query provided, but same results, I was thinking to do a loop instead, looking on the AttendDate field each day for the year and if a date is missing to add it to the field.
  3. I

    Update a datefield

    Hello, I am trying to update a date in the field AttendDate, that field contains the data for the whole year from 1/1/2018 till 12/31/2018, what I am trying to do is a query where can update is that field is missing a date per example date 9/24/2018 is not in that field. I was able to retrieve...
  4. I

    Export Data from Access table to Json file

    No luck means that I was not able to send data from Access Form clicking in the Add button to JAMS, but when I am in the JAMS tool and add parameters in a Job, then go to Access I am able to see the parameters I added in JAMS.
  5. I

    Export Data from Access table to Json file

    Hello, This is a long code I am trying to submit/ add data when click on the Add button, need help, very new at this Rest API with access, I using an API from JAMS which is a Job Access and Management System tool to schedule and create jobs. The only thing I got is to get the parameters in...
  6. I

    Not Adding a new record

    No, On Private Sub Form Current() I had: Me.lblRecordCounter.Caption = "Record " & Me.CurrentRecord & " of " & Me.Recordset.Recordcount I changed that for: If Me.NewRecord = False Then Me.lblRecordCounter.Caption = "Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount...
  7. I

    Not Adding a new record

    Hello, Did the same thing, same results: SELECT tbl_GCDS_Operations_Positions_Recruit.* From tbl_GCDS_Operations_Positions_Recruit WHERE (((tbl_GCDS_Operations_Positions_Recruit.[Position Applied For])='Lewis, Richard (GB)*Data Analyst*')) ORDER BY...
  8. I

    Not Adding a new record

    Hello, Thank you for your input, run it but that's not the problem, it's just no adding a new ID for the New record, that's why cannot save it. This is the result: SELECT tbl_GCDS_Operations_Positions_Recruit.* From tbl_GCDS_Operations_Positions_Recruit WHERE...
  9. I

    Not Adding a new record

    Hello, Hopefully someone can help me with this problem, I an trying to add data in two fields on a subform call "B" from a subfrom call "A", but it 's no creating an "New" on ID field when I filter the data to be add it in subform "B" Please, help. Thank you. Private Sub...
  10. I

    reference a value on a form from another form

    Hello Everyone, Just figure our how to do it, just silly of me, I was complicated myself, sorry about that, all I just need to do is to reference the table BankHolidays in the property sheet (Data = Row Source) of the New Employee form and that was it. Thank you for all your help.
  11. I

    reference a value on a form from another form

    Sorry Just realize that Combobox Based is under a navigation Form as well
  12. I

    reference a value on a form from another form

    Based is a ComboBox from the form that I want to add the value that I enter in the other ComboBox cboCountry which is in frm_BankHolidays
  13. I

    reference a value on a form from another form

    What I want to do is everytime I enter a new value in cboCountry to also add it in the other field Based that is in the other form.
  14. I

    reference a value on a form from another form

    Hello, I am trying to pass a value from one form (comboBox) to another form (ComboBox) where the value is on frm_BankHolidays and the combobox that I need to add that value from the other form is Based, the form name is frm_Register_New_Employee. I am not sure if I am using a wrong reference...
  15. I

    Disable save button

    Thank you Pat! I Will check my code and test it to follow your advised, I appreciate it.
  16. I

    Disable save button

    OMG! jleach that was beautiful CInt did it. Thank you so much!
  17. I

    Disable save button

    Hello, I am trying to disable save button when the cboYear is not <> currentYear, right now the code I have is disabling all the years including the current year when I filter the cboYear, Do I need to add this code somewhere else like on Load or Current? Or Am I missing something else? Please...
  18. I

    Save button

    Good eye MajP! let me fix it if I have more problems I will add more comments. Thank you.
  19. I

    Save button

    Hello, Can you please help me to figure why is giving me this error: Syntax Error(Missing Operator) in query expression '()' What I am trying to do is when user clicks Save, the system will firstly remove all bank holidays in the holiday Flatfile table (for selected country) and replace with...
  20. I

    Combobox filter by month

    Thank you plog, attached is a sample of the DB
Back
Top Bottom