Search results

Hi Bob, I will try to explain as best I can the 'logic' behind the isGrouped checkbox on the form. The project is - essentially - a Transport Database. Part of its function (this part) is to log the arrival/standing times of a fleet of delivery vehicles on a daily basis. Our company delivers...

Excellent, thanks. This seems to make much more sense. So much so that this here novice has been able to implement the event procedure albeit with code snippets provided by all respondees so far. New Code: '------------------------------------------------------------ ' isGroupedAfterUpdate '...

Hi and thanks for the response. You are right, this is to be the OnClick event for the checkbox. There is no reason - except for a general lack of VB knowledge - that I used a module instead of a subroutine. I have taken your advice though and used the sub as you have suggested. For the most...

Thanks for your help. So far so good. I now have a dialog box that displays Yes/No buttons triggered by the OnClick event. The message and the title are correct. The problem I'm having now is applying the logic to the Yes/No scenario. Assuming the Forms checkbox was clicked in error and the...

Hi, I have a module with which I would like to offer the user an option to cancel their action using a dialog box. Being new to VB, I'm not quite sure how to implement this. Here is the content of the module so far: '------------------------------------------------------------ '...

Hi, I'm looking at using the 'AutoFillNewRecord' sample to input a previous date into a new record. I am using the Calendar control to pick the 'date of transaction' (which may be anything up to a week prior to the current date). The date picked may have to be input for a full 180+ recordset...

Yep! I guess so...:mad: I have been chewing this over for too long without a solution! I knew this was inevitable. Back to the drawing board for me then! Still...It's a learning curve. I'll post my solution just for those of you that are curious enough to see someones brain sizzling :D

How do I write a DLookup expression that would check each sequence for duplicates? Given that the duplicate value in route_1 may be 5 but in route_2 the duplicate values may be 1,3,4,6,7 etc? Forgive my complete lack of knowledge in this area but the permutations must be many. Thanks :o

To better explain the scenario, lets take the first example and call it route_1. In it, there are 11 branches but because branch 'x' and branch 'y' share the same destination there are only 10 'drops' and therefore, only 10 separate arrival and departure times. However, on route_2, there may be...

Hi and thanks for your response. This is essentially a transport database. Amongst many other things, it will be logging the arrival and departure times of a fleet of vehicles at destination points on a daily basis. There are 280+ destinations in the current branchList table. These are...

Hi, New here, first post! I need to find a way using a module/VBA or even a macro which will 'flag' duplicates in a sequence of numbers. For example, I have a list of delivery destinations in a table. Each delivery is unique but some share the same destination. Because of this they are...