I want to run a start up form that appears only when the data base starts for about 10 seconds, then closes, and opens a switch board. I no I could do this with code, but not sure how!!!!!
I want to take a date, add a set amount of days, to give me a completion date not counting week end days. ie
Date started Set days Completion date
17-01-02 5 24-01-02
Can anyone HELP!!!
I have a form, with a subform, and a subform within the subform. I want to tab from the last subform to the second subform.
I have tried Forms![sb Scanner activity]![Command43].setfocus in code but it does not recognise the location. Can any one help.
I have an existing data base which creates records with a autonumber. I want to have a facility which allows me to attach a additional unique number to a record automaticly, specific records only. Can anyone help!
I want to have a form that will not go to a new record unless specific data is inputed. i.e. if the date field has no data showing a message would inform user that data is required.
I am using the 24 hour clock to calculate time in a query, but access loops the total ie 25 hours would show as 1 hour.
Can anyone advise me how to overcome this in a query!
I want to show the differnce between two dates in a query, but not count weekend dates ie 30-11-01 to 3-12-01 is two days.
I have tried Datediff but with out success.