Search results

Hey, I'm back. After taking an extended break, hoping to realize the error of my ways, I now find myself more frustrated than ever at my lack of progress, I turn once again to those more versed than me in the hopes of finding an answer... Yadda yadda. So, here's what I'm doing. I'm trying to...

Okay, I've set up the following code: Dim ItemData As ADODB.Recordset Set ItemData = New ADODB.Recordset With ItemData .Fields.Append "Desc", adChar, 80 .Fields.Append "Colr", adChar, 25 .Fields.Append "CAND", adCurrency .Fields.Append "USAD", adCurrency End With...

Could anyone point me to VALID examples of Recordset declaration/creation? Anything I've googled on is very limited, and not very explanitory. What I'm looking to do is pull data from a table using temporary Recordsets, so it can be manipualted between forms etc. easier, as opposed to binding a...

What would one use to make an 'invisible' field visible if no record are returned by the query that a form is based on? IE: Searching a FAQ database for keywords. The keyword searched for has no 'hits'. I want a text field to appear that states the term searched on returned no results. How can...

I'm sure this is another simple "D'oh!" that I'm just not seeing, but here's the problem... I query a boolean field, if it's true, 640 gets added to the date in a date field (two years), if it's false, 365 gets added (one year). Query works, no problem. The problem is that the Field on the...

Me, again! okay, I'm just banging my head repeatedly against a wall here, and I have no idea what the snap is wrong with my code. It's exactly what was found in the thread regarding Changing a Form's RecordSource, and it worked when I put it in, but suddenly, it's stopped working. Here's the...

Is it possible through code to change a form's record source PRIOR to the form being opened on the screen? Example: Form 'A' is set so that Record Source is a Table. Primary Form has two buttons, both which open Form 'A'. I want the one button to open Form 'A' as is, but I would like the...

Another really simple (but easily forgotten) scenario: Opening a form with a control button on another form. That I have no problem with. However, I wish to change the attributes of the controld of the field(s) on that form. Here is the code: Private Sub Button_Click() On Error GoTo...

I have aform that will not pull data regardless of whether the data source is set as the Table containg the data, or as a Query. All field names match in Table/Query and the Datasources of the fields on the form. I have another form that is set up identically (as it pertains to data, etc., not...