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?
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?
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...
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
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...
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...
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...
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
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...