Search results

This is how I figured to access the subform recordset from Main form recordset: Me.[SubForm_Name].Form.Recordset Hope this jogs up your alzheimer's memory. Thanks for your help.

That is good. Thnaks. But is there no way to refer to the subform recordset from the main form VB space ? Raktim

Hi, I have a Form with a subform in it linked on a field. I can access the the records for the main form with the 'Me' object. How can I access the recordset of the subform in the VB code space. I am not too familiar with linked recordsets. Any suggestions will be helpful. Thanks, Raktim

Hi, I have DoCmd.OutputTo code which is working fine. But the execution stops at that line and ignores the rest of the code. Any suggestions how I can execute the remaining code which is an Update query which should be executed if the .xls file is created. The code snippet is given below...

Thanks a Lot. I fixed it after reading the article. You saved my life. Happy Halloween. Raktim

I have a very strange problem which cropped up all of a sudden. I cannot open couple of form in Datasheet view or FormView. It given an error that I have never seen before. An err.jpg is attached. These 2 are the most critical forms of the application and I am just not being able to crack this...

Thanks, But I have already tried that. The problem persists. I am using Xp/Access2k Raktim

Hi, I am opening a Form from a Button Click with the strLinkCriteria set. However when the Form opens the record pointer points at the First Record in EDIT mode. I do not want the form to be displayed in EDIT mode and have set the Me.AllowEdit, Me.AllowDeletions & Me.AllowAddition property...

Thanks very much. It worked.

How can I use ORDER BY clause in the strFilter criteria of OpenForm function. Thanks in advance. Raktim Code: If strFilter <> "" Then strFilter = Right$(strFilter, Len(strFilter) - 5) strFilter = strFilter & " ORDER BY CreateDt" End If Error: 'Syntax Error (missing Operator) in...

It worked. Thank u very much.

Hi, I have an unbound textbox control in a Report's Header that I want to populate in the report's OnOpen event. When I try to set the field with the code below, I get an error. What am I doing wrong ? Thanks. Raktim ************************************ Code: ' Userd is the unbound control...

Hi, I am getting the following error on a form button when I try to save a new record. Anyone had this problem before and know how to solve it ? Thanks Raktim ************************************************ The command or action 'SaveRecord' isn't available now

Hi, I am creating a search form which collects filter search criteria and builds a criteria string and then calls a OpenForm with the filter. How can check before opening the form if the filter returns any records. If not I do not want to open the new form. Below is the snippet of the code that...

I want to create a general purpose unbound form to do some table search. Based on the records returned by a SQL query in the VBA recordset I want to then display the records in the same for viewing or editing. Currently I can only point to the found record in the bound form using bookmarks...

Thanks very much. I would really appreciate if you can provide me with a few pointers. . How can I create a multiple record recordset by clicking a search button(by running a SQL query etc) and how can I limit view of the form to only those records ? I would sincerely appreciate any help. Raktim

Hi, I am not too good with VBA. I am trying to implement a button on a bound form, clicking which it selects the first record matching the criteria. I want to display the record in the same form. How can i do that ? I wrote some part of the code which is below. How can I assign the selected...

Thanks Steve. I am still struggling with the problem. I would definitely appreciate some help from anyone. Raktim.

Hi- I am new to this forum. Can someone tell me how to print selected records from a form and then print the selected record by clicking a button on the form. This can easily be done if the File-Print option is used from th Menu where s"elected records" radio can be used for the purpose. But if...