Search results

  1. howling_muffin

    Set continuous form textbox labels

    I have a continuous form with a textbox, and I'm setting Form.RecordSource to the data I need displayed, but nothing's displaying. I'm having a hard time understanding how to assign query data to an element in a continuous form. I would usually do Me.LabelName.Caption = "Assign value." but here...
  2. howling_muffin

    How to insert charts in Access

    Here's a screenshot taken from a video on creating charts in Access: Note the Insert Chart button in the middle. And here's a snip of Access on my computer: What am I missing? Where's the insert chart button? There is a chart option in the control dropdown, but that gives WindowsXP-style...
  3. howling_muffin

    How to safely delete linked records in Access

    I'm creating a database in Access and VBA, and I'm trying to figure out how to delete records correctly and safely. What I'm trying to do is simply delete a record and all its foreign key'd records cleanly, without #Deleted showing up in the table. There doesn't seem to be any documentation on...
  4. howling_muffin

    Solved Plea for help - overflow error

    I'm trying to use a generic function to execute sql queries in my Access database, but I'm really stuck on the overflow error that keeps coming up. Public Function ExecuteParameters(sql As String, ParamArray Params() As Variant) As ADODB.Recordset Dim cmd As New ADODB.Command Dim...
Top Bottom