Search results

My fault; One is pick up duration and the other is delivery duration. The purpose is to make sure that another pick up or delivery is not scheduled during that time. So if ResourceID 001 has a pickup on 5/23/05 @ 8:00AM Duration of 45 minutes then the soonest this resource could be scheduled for...

Bakta, Thanks for the input, but I guess I may have been a bit unclear. The resource is not what is being picked up but who is picking up/delivering and with which vehicle. I need to check before the record is added otherwise I could end up with a resource picking up an item on 5/24/05 @...

I am in the process of writing a scheduling application for a friend. One of his requirements is that the same resources can not be scheduled for more than one pick up at the same time. A resource is basically a "kit" made up of 1 or 2 drivers and a van. The schedule table has basically the...

mresann, Thanks. I gave that it a try and it works nicely.

Hello All, I have a subform that I want to display values other than the key field in. For example, One of the fields on the subform is location. It is a plain text box. It displays the value of 5645 instead of "334 Greenbriar Road". 5645 is the key value stored in the db, but that is not...

Hello All, Is there a way w/n Access to ping GPS units out in the field and retrieve their coordinates and store them in the database? Also, any thoughts on the necessary hardware? This is all new stuff to me. Thanks,

Thanks. I figured it was something like that, but it is good to hear it from someone else. Craig

I have my DB split up ( DB01 = tables & indexes and DB02 = Forms, etc..) What is the max number of users that the backend can support in this configuration? I am using Access2000. The hardware is P2.8 with 1GB of RAM. I am trying to figure out how many users I can adequately support before I...

Thanks Geoff, I used the following code and it works well: Private Sub Form_Timer() Dim ctlForm As Control Set ctlForm = Forms!frmTest![tblSample subform] ctlForm.Requery End Sub

I have a subform that I am trying to have automatically refreshed every X number of seconds. I created a button so that the user could manually refresh and I created a macro that the timer interval can execute. The macro sends SHIFT + {F9}, which works fine so long as I am looking right at...