Search results

Thanks. The only thing I was missing was the second '!' I had a '.' in there, instead. S.

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, that seems to have taken care of that error, but now when the code is run, I'm getting one that's even more vague: "Multi-step operation generated errors. Check each status value." Any ideas on this one? Can't seem to find anything (in an albeit cursory search). Thanks again, S.

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

If you wish to be semantic, by all means. But I think you could easily discern that I was intending to differentiate between a Recordset declared and created within a sub function, as opposed to the greater underlying Form Recordset. Although, I perhaps could have worded the inquiry...

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

Thanks, that seems to have done the trick, although it still wouldn't accept changing the text box visible property to true from false, so I used the msgbox function, instead. (IE., it wouldn't take: If (RecordsetClone.RecordCount = 0) Then Me.NoAnswer.Visible = True End If S.

Nope, when I run that in the OnOpen or OnCurrent, i get an error. If I run it in AfterFinalRender, nothing happens.

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

It's really odd. Everything indicates (ALL format settings for anything that touches the field, on the form and in the query) that it should be the Medium Date Format, but it's still displaying as Short Date. The only difference between the fields is that one is actually a field in the Table...

Okay, I changed it to use the DateAdd function, but that still did not correct the problem I'm having. (well, so it corrected a minor oversight in leap year technology, BUT) the field is still displaying the date in all numerics. S.

The date field is displaying dd/mm/yy, but I have chosen the Medium Date format which should be dd-MMM-yy (Month in text, not numbers). Again the Date from the Table is displayin correctily in the Field right next to the 'query' field, set up identically, and it is displaying the date correctly...

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

Arrrgh! What a rigamarole! There was nothing wrong with the code, the form just 'broke' !?!? Tried compacting and repairing, nothing. So I copied the form, and renamed it. Changed the calls to the new form name, and uncommented all the code, and everything works exactly as it should! GD M$...

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

thanks... Thanks, again. That worked great. Hopefully I don't post too many more "stupid" questions, (and or just miss the obvious in the replies as before) although I am working through a few issues right now that I may need to pick some more brains about. S.

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

okay, I AM dim! :D Thanks, that did it... now, any idea on my other problem (regarding changing the Record Source)? Or should that be re-posted to a new thread? Thanks *once again* S.

Okay, once again, complete (with proper object names included) sub code for this button click action: Private Sub AddCustomer_Click() On Error GoTo Err_AddCustomer_Click Dim stDocName As String stDocName = "Add_Lookup_Edit" DoCmd.OpenForm stDocName, acNormal, acEdit...

okay, honestly, I'm not that dim. in my code I substitued the actual form name and field name with Form Name and Field Name in my post. I know better. It was looking for an object on the already open Form with the same name as the Form, which obviously doesn't exist. S.