Search results

It isn't running! It isn't running. How is that? How do I fix it? This is confusing¿ Thanks!!!

Yes Yes it is on the on click event of the button. This is a copy and paste. deleteshpdata is the button name. Private Sub deleteshpdata_Click() DoCmd.OpenQuery "shpdataquery" End Sub

No idea I don't know how to put a message box around the DoCmd. This is a delete query. I do want the warnings. I am using W2k with Access 2000. I get no errors and nothing happens when the command button is clicked except that a small dotted green rectangle appears within the button when it is...

Not working for me I tried the code, but it isn't working for me. The delete querie works but after I coded the button on the form, it didn't work. The name of the delete querie is "shpdataquerie" and the I used the code DoCmd.OpenQuery "shpdataquery" I could really use some help...

Thanks everybody Thank you, now hopefully I can implement your ideas!:)

You are correct. Please excuse my lack of knowledge. The lot number would be 1 + the number of records in the database. If there were 50 records in the database and a new record was entered the lot number would be ****0051. I hope this is more correct. Thanks for your help. Robert

On my form I have a field that is using the record # as part of a lot # for our product. Presently a combo of letters and #s are manually typed in the field that I am speaking of. A lot of mistakes are being made and I would like to have the information to be put in automatically. I have changed...

Thanks Thanks Fizzio for the excellent answer to my question and thank you missinglinq for the good suggestion. :)

I have a form with several fields that give information to people in production as to what is needed from them to fill orders. Upon completion of these orders, there is a check box in each record that they can check when the particular order has been filled. I would like to create a button on...

Thanks friend. I hope someone helps you someday!:D

Thanks, that was half the answer. Now how do I open the database with the menu bar uhidden so that changes to the database can be made?:confused:

How do I hide the menu bar and toolbar so that they are hidden form users in a database? Also how do I open the database with the menu bar and toolbar unhidden in order to make changes? Thank you for your much needed help.:)