unbound

  1. gheyman

    Make a unbound field = 1

    Private Sub Command11_Click() On Error GoTo Command11_Click_Err updateQuery1 DoCmd.OpenForm "frm_NIS_TSL", acNormal, "", "", , acNormal [TextSql].Value = 1 Command11_Click_Exit: Exit Sub Command11_Click_Err: MsgBox Error$ Resume Command11_Click_Exit End Sub How...
  2. L

    Audit trail for Unbound forms

    Guys There are a couple of good examples in the internet on how to implement an audit trail database. But unfortunetaly are examples for bound forms/controls. I'm developing a database with unbound forms/controls. I cannot use the property OldValue on unbound controls so I cannot implement the...
  3. kpasa

    Build Array from Table, Create new Table

    I have the following code to cycle through a table and find rows that match a few pieces of critical criteria. Sub FocusMissingAction() Dim tbl As ListObject Dim cell As Range Set tbl = ActiveSheet.ListObjects("Table1") For Each cell In...
  4. H

    Save button inserts unbound controls into append query

    I'm new to using append queries. I found this page MS Access Unbound Forms and VBA which talks about creating a continuous form unbound from the original recordset. I think this is part of what I need. I have a continuous form with the source being "qry_BLT_Update". This is an append query...
  5. J

    I just want to hide a column in a subform

    I'm tring to toggle the visible property of a column in a sub form based on input from a check box on the main unbound form If Me.Check55 = True Then 'This part works fine, if checkbox 55 is true the subform filters records based on "DBSUB.[Austin] Yes or No strWhere = strWhere & " AND " &...
  6. J

    Xcelsius viewer in Access

    Hello, I have a Xcelsius file that I would like to display in Access but need some help. I have tried a couple different ways to export the Xcelsius file so that Access could pull it in but no luck. I exported the Xcelsius into .doc and .pdf and tried to add an Unbound Object Frame to an...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top