Search results

The code is not all my work, I found it somewhere and made changes to suit. Have a look at the "New" attachment, I have fixed a problem with the DataID being Enabled = False. If you just copy the code from the old version into you db and make changes to control names etc then you would not...

Have a look at my post here, the code in this sample should do what you want.

Have a look at the attached sample.

Maybe I am missing something but if I am reading your post correctly then you have a main form with a subform (all controls locked) You want to be able to click on a button on the locked Main form/Subform and open a copy of the Mainform / Subform that is not locked, to the current record. If...

Your posted: You don't say who you were addressing when you posted this so I am assuming that you have looked at my sample and then asked the question, "how do you make the value of a key carry over?" I think it is a good idea to address your replies to whom you are asking the question of...

Try putting Is Not Null in all the fields in the query that is the source for the report.

Why not create an Access Report using the same source as the form and then e-mail the report?

Wrong. You can add a record to the subform (or as you call it 2nd form) and it will automatically link to the record in the main form. You can also add a NEW record in the Main form and then add a record in the subform. You must be looking at a different sample. See the attached screen...

Have a look at my reply to a post << HERE >>

You don't have to change the design of your form, put the command button in the Form Header or Form Footer. Have a look at my sample I posted <<HERE>> It will allow you to move through records and also add a new records to the subform.

You can do this several ways; You can have the list box result (what you select) bound to a Control source on the form. You can have an unbound list box that when an item is selected it will update either a bound or unbound (or both) text box on the form. Post back with your choice and I...

Instead of this: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 shouldn't you use this: docmd.RunCommand acCmdSaveRecord

You don't say what the relationship is between the two forms. Are they main form and subform ( 1 person can have many medical details). To link them try using the wizard; Put a command button on your, select Form Operation, open form - Next Select the name of the form you want to open -Next...

Your are getting the error because you are entering data into the Charge-type-id using the combo box, then your code saves the record and there is not record in the driverid. If you look at your table job-charges you will see that you have driver_id set to Required = Yes. This is what is...

No. Unbound text boxes work the same as gemma-the-husky explained.

You need to replace my parts table with your products table, I am only guessing as I have not seen your database. If you do this make sure that you make the changes so that pricing changes can be made to the "products" table.

In my opinion [unitprice]*[quantity] should be done in the query that is the source for the datasheet.

Welcome to the forum. Have a look at my sample that I posted HERE Its called InvoiceSavePrices180606.zip it is for invoicing but you could change it to quotes. Any questions post back.

Do a search for cascading combo boxes. Any further problems post back.

Arv, When I look at your problem I don't think that the sample I posted is for you. I would be better used on address labels or lists, when you do not require labels to identify controls. Have a look at my attached sample it may be what you want. In your case I thing that the report should...