Search results

How do I code a Cancel button?? I want to close a form which is bound to a table or a query but I don't want to save changes. I have tried the following code but it doesn't work: Docmd.Close acForm, "frmGeneral", acSaveNo. CAN ANYONE HELP?

How do I code a Cancel button?? I want to close a form which is bound to a table or a query but I don't want to save changes. I have tried the following code but it doesn't work: Docmd.Close acForm, "frmGeneral", acSaveNo. CAN ANYONE HELP?

As usual I am not sure that I am posting this in the right section therefor I have also posted it in other sections... sorry. My question is... I am using a Where clause on the OpenForm command and I want to be able to create a new record if there are no query results. Right now it shows me...

PLEASE HELP! I am developing a database with the main purpose of generating detailed reports for our users. One report is quite large and I have now come to the point where Access will not allow me to increase the size of the detail section for the report and there is currently no way I can...

I am using the Find method to locate a record in the record set. However, when there isn't a record for the particular product it shows the first product of the recrod set. I have written the code which checks the recordset's No Match property and it seems to do what it is suppose to except in...

I am trying to replicate a Progress database system in Access 97. The current system allows the user to copy different pieces of a record or an entire record for a new product. i.e the user enters a new Product Code (Primary Key) and then they are able to copy the info from existing records or...

I have posted this in the VB section as well because I am not exactly sure where it belongs, but here it goes.... I need to create a report that is based on multiple criteria that the user selects from a series of combo boxes on one form. For Example for a particular Product Report the user may...

HELP WANTED!!! I am trying to set up a search method that uses the recordset findfirst command. After I execute the RS.FindFirst I have placed in my code an IF condition which checks the RS.NoMatch Property which if NoMatch is true the code is suppose to display a message box saying that the...

I have been using forms and subforms quite a bit lately and what I would do is add the subform control from your toolbar to your form and base the subform on the table (i.e. Problems Table) /or a seperate query without an joining to the table or query that your form itself is base on that way...

I have several forms in my application which contain subforms in datasheet view. The subform contains the records queried from a table and the master form contains the subform and two command buttons which are suppose to allow you to add or delete a record in the subform however I don't know...

Can anyone tell me how to position the user to a cerain record in a subform. I am trying to create a search text box on a form and with every entry the user places in the text box (the On Change event) I want to position the user to the matching record in the subform. Any suggestions??

I am trying to assign a value to a field on a form that was selected from a second form (Subform) similar to a drop-down list but using a subform instead. The problem is that the new value for the field is not being displayed on the original form. I have used message boxes to insure that the...

Can anyone tell me how to position the user to a cerain record in a subform. I am trying to create a search text box on a form and with every entry the user places in the text box (the On Change event) I want to position the user to the matching record in the subform. Any suggestions??

I am creating a multi-page report that is group by Product Code. I want each new Product Code to begin on a new page with the detail pages to follow directly below, however it is printing the Product Code Header on one page and the detail section starts on a new page. How do I prevent this...