Thomadh
Last Activity: Nov 5 '06, 10:19 PM
Joined: Oct 20 '06
Location:
-
If I am unable to include the database in MS Binder then I could set a hyperlink to the database in a Word document and include the word document as a work around? -
Including an Access database ina Microsoft Binder
I would like to include an Access Database along with some Word and Powerpoint files.
The Word and Powerpoint are OK but can anyone suggest how the Access database can also be included.
Many thanks -
Thanks for this but I cannot seem to get it working
What I have is 3 identical tables of staffnames (Resource1,reso urce2 and resource3) (Don't ask why it was just a simple way for me to assign up to 3 people to a task via a drop down list!)
To update staff information therefore involves 3 identical actions at present and I wanted to have 1 form which would add,amend or delete a staff member details in all 3 Tables...Leave a comment:
-
A Form updating more than 1 table
I have only updated 1 table with a Form to date
Can you update more than 1 table from a single Form input?
The Wizard seems to allow only 1 Table to be selected as the data source
If so any quick pointers would be useful
Many thanks -
All sorted now.
Huge thanks!...Leave a comment:
-
MMCCARTHY
Almost there and thanks, but all end dates are now calculating as dstes in January 1900.
Can you suggest why that is?
Hope you can suggest a reason
Many thanks
Thomadh...Leave a comment:
-
A further query please MMCCarthy
As well as above it seems that in calculating end date it is setting the end date as a weekend date whereas I only want it to fall on a weekday (e,g, startdate of 20/11/06 (a Monday) with noofdays =5 gives and enddate of 25/11/06 (a Saturday).
Also connected with this could you suggest a way to include the startdate as day 1, i.e. the end date in the example above would then be 24/11/06 not 25/11/06...Leave a comment:
-
MMCCARTHY
Thanks so much , works great!
Can I ask a couple more things (you are so good!)
1. My use of Forms has been to display and input one record on screen at a time.
Given that effectively I am looking to build a Microsoft Project type task list via Access, it would be useful to see all preceding tasks on screen at input time (i.e. as in MS Project, Excel or Access Datasheet view), but still...Leave a comment:
-
mmccarthy thanks so much for this.
I now have the update query working!
However I wonder if you can help with how I set the after update event on the input form.
I am a bit of an Access novice and my input Form is simply a Wizard construction of input fields with one or two table lookups via drop down lists.
If you could tell me how I could action the date calculate function by the after update event on form input of number...Leave a comment:
-
Thanks very much for this but it still seems to simply add the days to the start date and calculate taht as end date (i.e. it does not 'jump over' the weekends.)
In simple terms I have a Table with startdate,noofd ays and enddate as 3 fields and I want to take the start date add the noofdays and place the correct end WORKING DAY date in the enddate field
As I say really helpful module script,but not quite working!
Also is it pssible...Leave a comment:
-
Calculate end date (working day) in Access
If I set up a task table with a task start date and a number of days to complete the task (as in MS Project), how can I calculate an end date field and place it in the table, ignoring weekends (i.e. only considering Monday to Friday)
Really bugging me, can someone help please?
No activity results to display
Leave a comment: