Search results

  1. 5

    Keeping sharepoint list/table readable (no need to update) but adding more fields to same table?

    Just need to read data, don't need to change any data that comes from SP list. But I do need additional fields.
  2. 5

    Keeping sharepoint list/table readable (no need to update) but adding more fields to same table?

    Currently I have a table which is linked to a sharepoint list. It contains all users in my organization with additional information. I'm using this data but it's missing some of the information that I need to track. My current solution is using this table as is and linking it to my own local...
  3. 5

    Solved How do I set main form record by selecting sub form field?

    Ok everyone, thank you for all of your help. After doing everything that everyone has suggested, I've given up after none of it worked. What I ended up doing was making a hidden textbox on main form, changing it's query ID field to filter based on that text box, and set oncurrent event on the...
  4. 5

    Solved How do I set main form record by selecting sub form field?

    Basically my subform is a glorified list box. I'd like to be able to select a record on it to display all of the relevant data on the main form. Subform is based on a much smaller query, but same data as main form. Parent / Child relationships don't work because main form filters the subform...
  5. 5

    How do I bypass "Cannot find the referenced form frm_FromName" without opening the form hidden?

    Just like my tittle says, on my main form I have a navigation control with a button to form in subject. So, here's the structure of the issue: frm_Main contains: Nav Control with button to frm_Members frm_Members contains: Search box txt_Search with code: Private Sub txt_Search_Change()...
  6. 5

    Best approach to show event length and display it as blocks of time

    Hello everyone, I'm really stuck on this one. I have a database which tracks status of fleet, and hours spent on each "Event". I want to use the data to show a chart, or a planner in a "tape" fashion and show each event in blocks of time. It's kind of hard to explain so I will include...
  7. 5

    Solved Run-time error '3077' Syntax error (missing operator) in expression.

    I have Run-time error '3077' Syntax error (missing operator) in expression error come up when trying to .findFirst in my recordset. 'Criteria' strCrit = "pkEventID = " & DMax("pkEventID", "tblEvents", "[fkAircraftID] = " & Me.cboTail & " AND [fldDateEnd] is null") 'Part of code'...
  8. 5

    Solved Compile Error: Type Missmatch

    Here's what I'm trying to do: Function SCHD2() Dim bolOK As Boolean Dim db As DAO.Database Dim rstIQA As DAO.Recordset Dim rstNewTable As DAO.Recordset Dim strIQA As String Dim nxtInspection As Date Dim intInsp As Integer intInsp = Forms!frmSCHED!txtInsp.value strIQA = "SELECT...
  9. 5

    Solved Compile Error: Type Missmatch

    Yes, it's a recordset.
  10. 5

    Solved Compile Error: Type Missmatch

    No, nxtInspection not on form, just in the loop code Yes, fldAuditDate is Null as this is a part of loop code which empties table and ands new values. It is attempting to calculate next fldAuditDate. Here is a line right before this one: nxtInspection = Nz(rstNewTable!fldAuditDue, Date) 'Sets...
  11. 5

    Solved Compile Error: Type Missmatch

    Good day, Can someone identify the reason for type mismatch error I'm getting for following code: If DCount("fldAuditDate", rstNewTable, "Format$(fldAuditDate,'yyyymm')='" & Format$(nxtInspection, "yyyymm") & "'") < intInsp Then Not sure if it's something obvious or not. I've tried putting #...
  12. 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!
  13. 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...
  14. 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"...
  15. 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.
  16. 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...
  17. 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)...
  18. 5

    Solved Run-Time Error '3075'

    It's based on querry
  19. 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.
Top Bottom