Search results

What code do I have to put in so that Access does not display the messages when deleting or ammending or adding a recond? I know it is possible to do it in options but I want VBA to control the error handling and not access. Cheers in advance

I have a form which opens in add mode. On this form is a close button. When the form is opened and some data is add, clicking the close button doesn't mean that the data is not saved. The close button just closes the form and the data entered still gets entered into the table. Is there anyway...

I respect your views on my database and have taken it all into account. This is mainly for a piece of college coursework which is due in shortly so don't really have time to re design it like you have said. Today I have create it so it is working how I want it to work, even though it might not...

I want to include the ActiveX control in my database so when a command button is clicked it opens the calendar so the user can select the date and then it gets inserted into a text box. This is possible, and if so how??

I have pasted your code and I get the error: "Cant assign a value to this object" Whats wrong there? I have this: Private Sub lstDetails_DblClick(Cancel As Integer) Me.txtSurname = Me.lstDetails.Column(1) Me.txtCustomerID = DLookup("[CustomerID]", _ "tblCustomerDetails", _ "[SurName] = '" &...

Well I will use that code as I can't get it to work. But I use macro's because I hate VBA. But thanks for sorting it out. Cheers

Please look at the attachment and see if you can understand the problem I am having. open frmNewInvoice and in the top right combo select a Post Code. Then double click on a customer in the list box. This should then update the text boxes to the left of this list box depending on which customer...

I cuurent have two tables which store my data. When a command button is clicked on my form I want all the data from one table to be moved to the other. I thought about using an Update Query however this does not work. I design it using QBE, but here is the SQL of the query: UPDATE tblTemp...

Yeah I figured it out in the end but thanks for giving me the idea. Cheers

I also want to know how to do this. I have a combo and when the product is selected another combo changes dependind on what is selected on the first. Howver I want the second combo box to display the first in order automatically as this is usually the required value. So how exactly do I do...

Good Idea, but how?? I havent got a clue!

Is there a way in VBA so that when the mouse is held over a control for 1 second a message appears saying what it means. You all know the sort. Happens in Windows all the time when you put your mouse over a icon.

When I try to hide one of my buttons after being click I get the message: "You can't hide a control that has the focus" I kind of expected this. All I want to know is whether there is a way of sending a comand button behind another? I have one which when clicked I want to hide, but as above...

Yeh I thought that but there are a lot of controls so I thought there might be a quicker way to do it. Never mind will do it that way. Cheers

I have apiece of code the requerys my form, however I don't want it to requery some of the txt boxes on the form. At the moment I have: [Forms]![frmNewInvoice].Requery Is there a piece of code which I can add for my txt boxes so that they don't requery??

I currently have the following code on my command button Private Sub cmdDelete_Click() On Error GoTo Err_cmdDelete_Click With DoCmd .SetWarnings False .OpenQuery "qryDelete", acViewNormal, acEdit .SetWarnings True End With txtDiscount.Requery...

It needs to run every time one of my command buttons are clicked I tried requery but that does seem to work with queries. How is it possible to get it to run and calculate the new values after my command buton is clicked?

Any body?

I have a query on one of my forms that calculates the sum of all the records in one of tables. The table is also getting added to, but I can't seem to be able to get my query to recalculate the correct sum on my form. Can anyone help? Cheers

Right got them working nicely with the code and everything....only thing now is how do I make one of them be set as default on form load??