Good morning to you all.
I have created a database for my company to monitor all of our cases. Within this database i use reports to create standard letters for our housing advisers to send out to clients and contractor.
What i need to do now is to find an easy way to update the name at the bottom of the letters. For example if John Doe sent a letter it would automatically put his name at the bottom but if Jane Doe...
Breeves22
Last Activity: Nov 30 '10, 11:35 AM
Joined: Sep 10 '10
Location: Coalville, Leicestershire
-
Using usernames to edit reports
-
thankyou very much for the assistance -
block fields based on selection in a combo box
Hi all,
sorry to bother you again but i find im quite stuck in access 2000.
At the moment i have a combo box in which users select the type of works that are being done (Simple works, Complex works or stairlifts).
Further down in my form i have three sections for works progress, one based on each item in the combo box.
What i am aiming to do is have a user select an item from the combo box... -
Thanks smiley one.
your help with this problem was greatly appreciated.Leave a comment:
-
Unfortunatley i am having the same problem as JDDDDD. I am unable to get =addworkdays the code to work on my form. I tried adapting it a little to make it similar to the way i use a DateAdd but still no luck. any help would be greatly appreciated.Leave a comment:
-
Thankyou for that. Problem is now solved
:)Leave a comment:
-
Open an external folder using access 2000
Hi all
I have no idea if this is possible and doing a general search on the internet yeilded no results so i thought i would ask here.
In the database i am creating there will be a need to open up a folder stored on the computer to edit a file contained inside. This file is updated on a weekly basis and when this happens a new file is created so it is not practical to use a command that opens directly to the file. Is... -
Thankyou for your time.
What i am trying to do is create a database to monitor all our active cases. My company works on a 5 day week (Monday to Friday) and the database needs to reflect that. For example once we have drawn up a schedule of works we send it to the local council for approval and they have 15 days to return it to us with their comments. Now if i use DateAdd to just add 15 days from the date sent it will come up with...Leave a comment:
-
How to calculate dates based on a 5 day week
Hi all,
I was wondering if it was possible to use Access 2000 to auto calculate a date in a field operating under a 5 day working week
Thankyou in advance -
Thats Fantastic works great now. cheersLeave a comment:
-
Hi Neopa. Yes that is exactly what i am trying to do. Sorry for not making it clearerLeave a comment:
-
Sorry the error message i am getting is you may have entered an operand without an operator.
And i entered it wrong on my entry. where the code says Joint Visit its meant to say visit date. i already corrected that problemLeave a comment:
-
How to create an expression that uses auto date with isnull
Hi I am fairly new to access and only just beginning to work with creating my own database.
I have three fields, the referral date, the visit date and the joint visit date.
I am trying to create an expression that will imput a date into the joint visit box based on whether the visit date box is filled in or not. For example if the referral box is filled in then but not the visit date then the joint visit box will come up...Last edited by Niheel; Sep 10 '10, 01:42 PM.
No activity results to display
Leave a comment: