Recent content by KSimm

Have you tried an On Open event on your form that incorporates an acAddNew? I have a search function on a form that clears the form when the search button is clicked and incorporates this statement: DoCmd.GoToRecord , , acNewRec Following that, I set the focus to the field that I want.

the correst syntax is: =DateDiff("d", [Date1], [Date2]) with the "d" indicating the interval to be calculated between the two date fields

For some reason simply posting a question here seems to result in me finding the answer a few minutes later. :D I needed to select the rich text box and view the properties menu. Then I needed to click on the ellipses for the "Custom" property. That opened up a dialogue box "RichtextCtrl...

I'm using Access 2000. I've got a report with Active X rich text boxes that change the font from regular black to bold red based upon the value. That part is working fine. For the life of me, I can't get the darn border to disappear. I've set the border to 0 using the properties box. I've...

Thank you!

pbaldy - I have that in the function already (it's at the end of the code window) as this: 'Find Month Name Function Function FindMonthName(strMonth As String) As String Select Case (strMonth) Case 1 FindMonthName = Jan Case 2 FindMonthName = Feb...

I've been trying to solve this problem all week, and will welcome any suggestions. I've searched the forums and MSDN library, and googled, but I must be missing *something* :confused: I'm using Access 2000 and VBA I would like to pass an integer variable (that corresponds to calendar...

Thanks for your help and explanations. I really appreciate it.

Thanks. so does that mean that I've created another recordset named varArray that is a clone of my original recordset named rstBedDays? My apologies for all of the questions. It's been quite a while since I've used VB, and I've never used VBA while in Access to manipulate Access records.

clone is the answer I finally got it to work. I ended up changing my statement to: Set varArray = rstBedDays.Clone and so far everything seems to be fine. :D

type mismatch due to ADO library and DAO library both being active I was able to solve (I think) my original problem. I was only referring to DAO objects, but I had the DAO library at a lower priority than the ADO library. I switched that and now I still get an initial type mismatch error...

I'm trying to populate an array with rows from a table. Right now I've only got one row in the table for test and debugging purposes, and I'm able to connect to the db, set the recordset, and I can count the rows in the recordset (while debugging, I can see the RecordCount is holding a value of...