Hi guys
I’m a new member here. I’m in the midst of setting up a database using MS Access and am having some difficulty in getting some features inserted. Can anyone help me?
(a) I have Date1 and Date2. I want to have a separate column which would count the difference of both dates (in terms of weekdays and if possible, exclude out certain days like public holidays). I’ve tried DateDiff but it didn’t work for me. At last, I used Date2-Date1 as temporary resort. Is there any other way to do this, at least counting only the weekdays?
(b) I have Checkbox1 and Date3. Date3 should only appear if I click on Checkbox1. Both of these are on the same form page. I’ve tried many commands using VBA (admitting that I’m just trial-and-error) and still couldn’t work this out.
(c) I have a list of selections and each selection carries with it, two other ‘attributes’. For example, selection ABC (as Code) is a computer (as Object) and $2,000 (as Price). I want to separate these into three labels and text box. This means, once I select ABC as Code, automatically texts under Object and Price should display ‘computer’ and ‘$2,000’ and user can’t click on Object and Price to modify them. Can this be done?
(d) Can we change the background colour of the form by inserting some background jpg?
Many many thanks to all of you and really hope to get a feedback and insight from you.
Regards
Anthony Chang