Search results

  1. C

    Solved Open a record in one of 2 forms based on the last character of a field

    Morning, My Form "ReworkF" - Record Source is the Table "JobInfoT" I have gone thru my fields and ensured nameing and control source is correct. On both forms (Where the open button is) Field is "JobID" and the ReworkF the field is "JobID" Code for the button is...
  2. C

    Solved Open a record in one of 2 forms based on the last character of a field

    Entry ID is only the label. The name of the field is JobID on both forms
  3. C

    Solved Open a record in one of 2 forms based on the last character of a field

    Thank you, The difference is the JobID is not where the "R" is. Its in a field JobNumber. I am getting a blank form at the moment. thank you
  4. C

    Solved Open a record in one of 2 forms based on the last character of a field

    G'day Mate, Thank you for the reply. I have done the code as per below. The form opens but the form is blank. Private Sub BtnOpenJob_Click() On Error GoTo Err_BtnOpenJob_Click Dim stDocName As String Dim stLinkCriteria As String If VBA.Right(Me.JobNumber, 1) = "R" Then...
  5. C

    Solved Open a record in one of 2 forms based on the last character of a field

    Hello, I have a button that opens a form based on the jobID e.g. Obviously all works, however, I want to add an additional option to this open form/record button. Criteria is: Look at the Job# (JobNumber) field, If the JobNumber ends with an R e.g. then open the record with the form...
  6. C

    Solved On activate code - affecting all records instead of just one.

    Thank you
  7. C

    Solved On activate code - affecting all records instead of just one.

    Oh bugga!! I forgot about that event!:rolleyes: Legend! Thank you :D
  8. C

    Solved On activate code - affecting all records instead of just one.

    Hey mate, Yes using Print Preview and printing the report. I cant condition format the check boxes, and cant conditional format a label. (I can change the label to an unbound text box) Might have to use your suggestion and conditional format the text and just have the check boxes always...
  9. C

    Solved On activate code - affecting all records instead of just one.

    Hello, I have some reports that I have coded to do certain things, however it is affecting all records and not just the relevant record according to criteria. Here is the code: Private Sub Report_Activate() If ChkSubstrates = True Then ChkSubstrates.Visible = True...
  10. C

    Solved subtract number of WORK DAYS in report expression

    Cheers mate, Worked a treat :) Thank you
  11. C

    Solved subtract number of WORK DAYS in report expression

    Oh Bugga, :( Any example for me? :) I don't want to store the data, its just a report. I have a few working date functions in VBA, can I call on one of them in the expression builder maybe?
  12. C

    Solved subtract number of WORK DAYS in report expression

    Hello, I have a report that I need to minus certain amount of workdays from a preferred date. This is what I have that is working, but it is including weekends. =DateAdd("d",-[LeadTime],[CustomerPreferredDate]) I need it to only use working days. (I'll tackle the whole holiday thing later)...
  13. C

    Solved Split Database - The database engine could not lock (TableName) because it is already in use...

    Just tried that, and it worked. thank you. Ill have to have a look at what the form is bound to. Thanks again.
  14. C

    Solved Split Database - The database engine could not lock (TableName) because it is already in use...

    OK - Weird!!! I closed the Main Form and then split database. It worked.
  15. C

    Solved Split Database - The database engine could not lock (TableName) because it is already in use...

    Hello, Trying to split my database. Receive the following problem I have nothing open in design mode, and nothing should be running, just the main form open. appreciate some help. Thank you
  16. C

    Solved Enter a date, check box is true, click checkbox to false, clear date.

    G'Day mate, I appreciate everyone and all input to my issues. I am a novice with access and coding. I didn't comment much on the previous thread as I was still getting my head around the responses and solutions. I always try and come back to comment and mark as solved and thank everyone. I have...
  17. C

    Solved Enter a date, check box is true, click checkbox to false, clear date.

    Lol 😂 Sort of different.
  18. C

    Solved Enter a date, check box is true, click checkbox to false, clear date.

    Hello, I originally had some code that on click put in today's date. Have some issues with that, and probably not the best use in this instance. So, what I want to achieve is; 1 - Enter a date, the checkbox is then enabled and true. The Date field becomes enabled = false. 2 - Uncheck...
  19. C

    Solved Incorrect Date formats

    Thanks mate, I have added the following code and I think it is all working :) "AddDays" AddDays = Month(dtdate) & "/" & Day(dtdate) & "/" & Year(dtdate) "AddOrderDays" (another function) AddOrderDays = Month(dtdate) & "/" & Day(dtdate) & "/" & Year(dtdate)...
  20. C

    Solved Incorrect Date formats

    sure UPDATE JobInfoT SET IFA_Due = #8/10/2021#,SampleSubm_Due = #8/10/2021#,IFC_Due = #8/11/2021#,SetOutDue = #9/11/2021#,CarcassCut_Due = #19/11/2021#,CarcassEdge_Due = #19/11/2021#,PFBCut_Due = #19/11/2021#,PFBEdge_Due = #19/11/2021#,WhiteSatinCut_Due = #10/11/2021#,TwoPakPartsOut_Due =...
Back
Top Bottom