Search results

Thankyou Force Referencial Integerity / Cascade Delet Related Records is not an option I can use in this perticular instance. Would you happen to know what the vb code would be to do this? Thanks in Advance.

Is there away of ensuring that when a record on a form is deleted any child in a relationship with it on a sub form is deleted? Thanks in advance

Thanks for all the help, I was hoping there would be a simplier method as all I want to do is set focus to the last record an event that only happens once. Will keep playing.

I have a customers form that opens (datasheet view) allowing a user to choose a customer - on this form there is a button to add a new customer via a another pop up form. When this (add new) pop up form closes, it requerys the customer form, showing the new customer in the list, which is...

Put your labels in the page header, then arrange your info in the "detail" section of the report under the relevant labels.

If you had an end date field you could use a date range, not sure about duration.

Get the button to close the form when the report opens and then get the report to re-open the form on its close event, or vise-versa.

I tried that, the next field I want it to move to is on the next record (new record), this just moves to the relative field within this record. Thanks for the help though.

I am using this code in the on exit of a field on my subform, Private Sub Quantity_Exit(Cancel As Integer) Dim intQty As Integer intQty = Quantity If intQty > 0 Then Quantity = -Quantity End If End Sub Works fine, however if the Qty is >0 then I have hit Tab twice to move to the...

Thankyou that works, I was heading in the right direction except I was using If [SomeForm].SomeField = "" Then MsgBox "Enter main detail first dummy!" [SomeForm].SomeField.setfocus End If Which did absolutely nothing lol. Thankyou both very much.

I am probably missing the obvious here but it something that has me really stumped. Any Help would be appreciated. I have a form with a linked subform. I need a way of when I add a new record the record is created automatically. What happens at the moment is the user can by pass any of the...

Yes this also works well, thankyou.

Thankyou

When is it proper to trap for errors, is it a good habit to trap for errors in every procedure or is it not needed. Can anyone explain error trapping a little more to me, it's something I have not really dealt with before. Thanks in advance.

The error message is Run Time Error 2501: Close Action Was Cancelled Yes. Moved the code to the on Open Event and that seems to work... Thankyou very much for all your help

Sorry I will expand a little Basically it check to see if there are any results to displayed in the form, if there are not the form unloads and the message box pops up.. if there are results, the form opens and displays the results. All this worked fine. Now what is happing is the form is...

I made some changes to a database I use in work while at home this weekend. Everything worked fine at Home but when I use the DB in work I am getting an error in the code I added. Here is the code: Private Sub Form_Load() Dim intResponse As Integer If DCount("SumOfQty", "qryPickLocation") < 1...

Ah.. that all makes sense... thankyou very much

I don't use VBA a lot and was wondering if anyone could tell me why I can not see all my Forms in the object browser window. Thanks in advance.

Have you accidently selected to sort the data?