Search results

  1. 5

    Prevent date field from changing format on data entry

    Ok, that's what I thought. I knew it was something to do with local time. Thanks!
  2. 5

    Prevent date field from changing format on data entry

    I have a date and time fields which displays what I want it to display. I've also set up an input mask for users to enter what I need them to enter. It looks like: However, when I try to edit the field it changes the format. When clicking on date field: When clicking on time field: How do...
  3. 5

    How do I normalize my tables correctly?

    I think I get what you're saying. But before I attempt I should clarify. I'm trying to do a hierarchy for causes. So for example, one of my causes could be "Personnel". This is the main cause which can also have a list of different personnel (AVN, AVS, ACS, OTHER). So if I selct "Personnel"...
  4. 5

    How do I normalize my tables correctly?

    Do you mean something like this? Edit: This might be better: Edit 2: I've included a file if anyone wants to help with this. Edit 3: Sigh..... Well I'm thinking my latest iteration is better.
  5. 5

    How do I normalize my tables correctly?

    Hello everyone, I'm struggling to understand how to normalize my tables. Please see attached screenshot below. Problem is my tblCause table has CauseID and Cause fields. However, certain causes might have a sub-cause which I'd like to add or remove to. How do I go about this? Edit: What I...
  6. 5

    Solved Run-time error '3027' Cannot update. Database or object are read only.

    Good day everyone, I have the following error: Run-time error '3027' Cannot update. Database or object are read only. when using a certain form. On "Debug" it stops on following line of code: (Me.Dirty = False) Private Sub findWI() With Me.RecordsetClone If Not IsNull(lstWI.Value)...
  7. 5

    Solved Run-Time Error '3075'

    It's based on querry
  8. 5

    Solved Run-Time Error '3075'

    Ok, SOLVED! Here's what I did: On related form instead of using: DoCmd.OpenForm "frmWorkInstruction", , , "fldWISerial= '" & Me.fldWISerial & "'" Instead I used fldDocID to locate record, like: DoCmd.OpenForm "frmWorkInstruction", , , "fldDocID= " & Me.fldDocID Thanks everyone for help.
  9. 5

    Solved Run-Time Error '3075'

    Ok, if I load the form by it self then it works ok. Problems stems when opening form from another related form. In my related form I have a field fldWISerial and it has on-click event: DoCmd.OpenForm "frmWorkInstruction", , , "fldWISerial= '" & Me.fldWISerial & "'". So then, following...
  10. 5

    Solved Run-Time Error '3075'

    Here are all declarations: Private Sub Form_Current() Dim strLastAudit As String Dim strAudit Dim strDR As String Dim strLastDR As String strAudit = Me.LastAudit strLastAudit = Nz(DMax("fldDateClosed", "tblIQA", "fldDocID = " & fldDocID)) strDR = Nz(Me.LastReview) strLastDR =...
  11. 5

    Solved Run-Time Error '3075'

    I'm getting following error: Line of code: strLastAudit = Nz(DMax("fldDateClosed", "tblIQA", "fldDocID = " & fldDocID)) I've also tried the following: strLastAudit = Nz(DMax("fldDateClosed", "tblIQA", "fldDocID = '" & fldDocID & "'")) fldDocID is a PK in tblIQA, an auto number. Any ideas?
  12. 5

    Split database accde file can't open by more than one user

    Hey there, thanks for reply. I'm on version 1909 of Win 10 Enterprise. Not sure if this version has that bug. OS Build - 18363.2037 Unfortunately, I cannot update windows as my organization does that, so I'm stuck with this for now I guess.
  13. 5

    Split database accde file can't open by more than one user

    Hello! I have a database which I manually split. It contains no tables. Portal.accdb Next, I have a back-end file with all tables Portal_be.accdb Obviously tables are linked, everything works fine when using the application. These files are hosted on a server file folder. Next, I took...
  14. 5

    ComboBox selection to perform an action

    Hello everyone! I'm having some problems with my combo box selection. I need to select an item from drop-down combo box and depending on the selection perform an action. In this example, a simple message box with yes or no. Private Sub cboReview_AfterUpdate() DoCmd.Save...
  15. 5

    Error 2465

    Ok, this is weird. I was playing around with the code, rewrote it again just as above and now it works :unsure: Anyone know why?
  16. 5

    Error 2465

    Me.fldFolder = \Document Reviews\Document Reviews\2022\DR-22-007 WordDocs.name = CC177-T3-429-4.05-03.docx
  17. 5

    Error 2465

    Oh, I'm sorry, Can't find the field '|1' referred to in your expression.
  18. 5

    Error 2465

    I get the run time error 2465 with this code: docxFile = Me.fldFolder & "\" & Left([WordDocs.Name], 25) WordDocs.Name is a filename with .docx extension I'm guessing i've got syntax wrong? Anyone know how to fix it?
  19. 5

    OpenForm "Where condition" contains hyphen

    Never mind, figured it out. It's supposed to be: Private Sub fldSerial_Click() DoCmd.OpenForm "frmDocRevDetail", , , "[fldSerial]='" & (Me.MaxOffldSerial) & "'" End Sub
  20. 5

    OpenForm "Where condition" contains hyphen

    I'm having issues figuring out how to fix this bit of code: Private Sub fldSerial_Click() DoCmd.OpenForm "frmDocRevDetail", , , "[fldSerial]=" & MaxOffldSerial End Sub MaxOffldSerial contains a hyphen. It looks something like this: DR-22-001. When I click on the field, it opens the...
Top Bottom