Search results

  1. howling_muffin

    Set continuous form textbox labels

    So the Form.RecordSource is set to the sql string that contains the query, and the Textbox.ControlSource is set to the name of one of the fields returned in the query. Is that it?
  2. howling_muffin

    Set continuous form textbox labels

    Well it's not really the same question but I never got the hang of making a query with parameters that can be passed in programmatically, and I'm trying to pick my VBA battles over here :). Which templates are you referring to?
  3. howling_muffin

    Set continuous form textbox labels

    How do I do that? Normally to set the value of a textbox I would use something like Public Property Let Name(value As String) Me.txtName.value = value End Property but because this is a continuous form I haven't got a value, I've got a SQL string which I think I'm supposed to be setting as...
  4. howling_muffin

    Set continuous form textbox labels

    Sorry if I haven't explained well... The textbox has a label, and I want each label to display the query data (which in this case is a name), so that the user can fill in the textbox
  5. 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...
  6. 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...
  7. howling_muffin

    INSERT ADO Recordset into Currentdb Table

    Thank you for this lifesaving piece of code, it's exactly what I need and saved me a good few hours of research
  8. 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...
  9. howling_muffin

    Solved Plea for help - overflow error

    You're right on first guess, and I'm eternally grateful 😁 I replaced the table and column references with strings, and the code runs!
  10. howling_muffin

    Solved Plea for help - overflow error

    Hi, thanks for your response It's actually a DELETE query but while I was trying to figure out where the error is coming from, I changed it to SELECT and then forgot to change it back before copying the code into the post. The results are the same in both cases
  11. 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