Development Contract
Oct 30, 2006
Placed this query in another section of the forum without response - possibly wrong section so please forgive me for duplication
Does anyone have a sample development contract subject to UK legislation. I need one for a project that is quoted at £4,500 stg and as this is my first biggie I want to keep myself covered.
whilst I know you may suggest I go to a solicitor I can't really afford to. some of you may say that I can't afford not to but hopefully after a couple of biggies like this it will be possible.
Thanks
Humph
View Replies
ADVERTISEMENT
May 29, 2006
I don't know who to write and thought that I would try this list. Has anyone written, or do they know of, a Contract Administration package for Architects, written in Access 2000 or later? I am an Aus architect who dabbles in Access and doesn't want to re-invent the wheel.
Any help would be appreciated.
Cornelis (Kees) Wegman
View 1 Replies
View Related
Jul 13, 2006
I hope someone can help me. It’s a bit of a strange one.
I have a query with information that I want to count.
Here are the details.
The query is for a reps database.
At a given time the rep will change data in a dropdown box with 6 options to indicate what stage of the prospect he is at. For example:
Stage 1
Stage 2
Stage 3
The rep could have anything from 30 to 50 prospects on the go at any one time with all of them at different stages.
What I am trying to do is count the contracts at each stage. Example
Rep name Stage1 Stage2 Stage3
Joe Bloggs 7 9 14
This will tell his employers how many companies are at Stage 1 and how many are at stage 2 and so on.
This information will then be send to a report that will display the information in the same order as the query.
Can this be done!!!!!
View 5 Replies
View Related
Dec 11, 2006
Hi all,
I need your help.
I am in process of designing a Contract Management database.
I have three tables
The first one is Contracts Details table, with these columns:
Contract ID, Contract Name, Vendor ID, Vendor Name, Start Date, End Date, Type, and Description.
The second table is Vendors table, with these columns:
Vendor ID, and Vendor Name.
The third table is VendorContact table, with these columns:
Vendor ID, Contact Person, Phone, Mobile, Fax, Email, and id.
I want you to help me to construct the relations?
Kindly, see the attached database.
View 4 Replies
View Related
May 18, 2013
I am trying to calculate how many days are left till end of contract...
whats wrong with this formula
=DateDiff("d",[Completion_Date], Date())
View 14 Replies
View Related
Jun 4, 2014
I have two tables, and I'm trying to create a crosstab query...I think. One table is Contracts, one is Contacts. Each contract could have multiple contacts, but they are numbered (1, 2, 3...etc.) based on importance. I want to create a query that keeps each contract on one line, and separate fields for each contact and each field of the contact. So a contact will have Title, First, Last, Address, etc. So I want my query to show as follows:
Code:
Contract-----Title1-----First1-----Title2-----First2
ContractX Mr. James Mrs. Sally
I of course need this to be dynamic, so if a contract has 9 contacts, there are fields up to Title9, First9, etc.
View 7 Replies
View Related
Dec 5, 2005
I'm after a bit of advice....
Have developed a booking system for a client, Access 2003 adp front end with SQL Server 2000 backend, they want to offer search and view facilities on their intranet and possibly on the internet. Very broad but Simple question, whats the best way to do it ?:eek: having never done any web development....
It will purely be a couple of combo boxes populated from the SQL server for selection, followed by the display of the results, possibly with an email button.
At a loss as to where I should start, can I do anything in Access or possibly ASP.NET or something else ????
Apologies if this is in the wrong thread, and many thanks in advance for any responses,
GRW
View 1 Replies
View Related
Nov 28, 2007
Is there a way to kick all users out of the database so updates can be made? I have an Access database that is used by several different machines. I need to make my updates around 4pm each day but sometimes the operators forget to log off. I need to be able to kick everyone out so that I can get my updates made on time.
Any ideas?
View 2 Replies
View Related
Jul 22, 2007
Hello,
I am looking for some advice on how to go about solving a problem.
I created a database 1 primary table with 1 other table, linked in a form with a 1 to many relationship.
The PK is auto assigned for both tables.
I want to have say three different companies use the same database but with some kind of unique ID for each company so when I bring all of the data together into one database it will all merge but be sortable by the company that created the data.
As some of you will note I thought that defining the PK for each record was the way to go but it seems that this is not going to work.
Any suggestions?
Thanks!
Fen How
View 2 Replies
View Related
Apr 10, 2008
I doing a db that is supposed to show the development plan of some persons.
2 tables:
graduates
departments
in the graduates table there are among other data about the graduates, four fields for their departments in the next year.
i have called them:
rotation 1
rotation 2
rotation 3
rotation 4
these rotations should be choosed from the departments table, so i have created a lookup dropdown list in these fields.
now i want to show a query that shows a list of all the departments with the linked graduates. something like this:
Rot 1: Rot 2: Rot 3: Rot 4:
dep 1: Ben John - James
dep 2: James Ben John -
dep 3: - - James -
dep 4: John - Ben -
dep 5: - - - John
dep 6: - James - Ben
'-' = meaning empty field (onley for illustration in this forum)
My question is how i set up the links between the tables to create a query that show this.
Thank you.
View 1 Replies
View Related
Apr 11, 2007
Hi,
I need to create a Database in Microsoft Access. Can anyone name me 3 different development methodologies I could use?
Thanks.
View 2 Replies
View Related
Aug 26, 2005
Hello:
I've been using Access as my database development tool for a few years. Now I would like to start learning how to use Access in conjuction with other tools (such as ASP, vb.Net, etc.) to develop web applications. Can anyone point me in the right direction, offer ideas on how to get started? I don't know how things work between an Access db and the Web.
Thank you very much.
Raneil
View 4 Replies
View Related
Oct 16, 2005
I recently got asked by a friend to set up a database for him to store his business contacts (so he can do mailshots etc) along with some basic order history. I've come up with the basics of this database (attached). There is still some work to do on it, a bit of tidying up and some reports etc but I need to go and see him show him what I've done and to clarify exactly what reports and stuff he wants.
I'm only doing this in my free time but he has said he'll pay me for my efforts. I don't feel I can really charge an hourly rate though as I'm still only learning the ropes and what might take me several hours might only take an experienced developer an hour or even 10 mins! :o
So I guess what I'm asking, is could those of you who are self-employed, or indeed anyone who has some idea of what the going rates for databases are, take a look at what I've done and give me an estimate of how long it would have taken to put together something similar and how much you would charge for it (either in total or per hour).
I'm also sure that some of what I've done could have been done a lot better, so if anyone has any views on improvements I could make, I'm all ears. :)
View 2 Replies
View Related
Oct 27, 2005
I am need of urgent help with the following situation:
Currently my project has been developed on my computer with frontend Access, backend SQL Server (on our companys server). Now that I am testing release as soon as I create the package and install it on any other computer it says that it cannot connect to the SQL Server...
Is there something I should add (macro) or otherwise to make sure that it recognises the SQL server and connects?
As a point of note the release will be on the RunTime engine rather than full access.
Thanks for any help.
Phil
View 4 Replies
View Related
Aug 15, 2007
Hi
I'm building a Software Licensing Database & I have come across this particular problem and i am not 100% sure which way would be the best way for me to solve it. So far I have created the database so that a user/software/license can be added to the system. The main form display's users information and below in a tabbed subform it displays the installed software on the machine. On the second tab it displays the license's attached to that machine. On each of these subforms its provides the user to add/delete software/license's however my problem is with error handling within the system. I have managed to make it so that a user can only selelct license's that are specific
Each License can cover anywhere from 1 to <x-amount> of pc's. What I want to be able to do is the user can select a license if their is 1 available and a small text box which denote's how many license's are available. So i know im going to need a license count which is easy enough using a SUM within a query. It is the error handling that im stuck on. I need to create a statement using the 'equal to or greater than' operator if possible saying
If NumberofLicenses >= then add license
Else If vbOKonly message - "Insufficient License's to cover this piece of software please purchase & add the new license to the system then try again"
Something along those lines.. I just dont know where this would go or how to write it! If anyone has a better way of achieving this.. fire away im open to ideas!
cheers
Ally
View 1 Replies
View Related
Nov 8, 2005
I am self-taught on Access and have designed a quite basic database for a friend who owns his own company. This is a client contact database designed to hold information about his clients and their companies, but also to send reminders to Outlook when they haven't been contacted for a while - ie. to make my friend more proactive in his business.
This was a project which I originally agreed to work on for a fixed price. Needless to say, I undersold myself and probably because I am self-taught, with the number of hours I have put in, I probably got paid 2p an hour!
The project is drawing to a close, but he wants to pay me per hour for any further development to the system, and for any similar work he wants doing, problem is I haven't a clue what to charge him per hour?
Any ideas, without divulging your well-earned salaries of course!
View 8 Replies
View Related
Jul 27, 2007
Hi,
Right at the moment i'm baisically designing and building a software licensing management system fro my boss at the moment but I have had a snag, the face that its 3pm on a friday is not helping with my concentration either.
Ok so my problem is that i've got 3 tables (tblUser_Informantion, tblSoftware_Information & tblHardware_Information) all of which are related via a 4th table (tblReference) which holds the primary keys of each of the other 3 tables mentioned.
For all intents and purpose's the primary keys are named according to their tables i.e. (User_ID, Software_ID, Hardware_ID, Reference_ID etc...)
On my main form a User can select via a cmbo-box or search for a Person via Surname or search via Machine Asset number. Upon selection this fills a number of pre determinate box's below that containing you typical standard information. However under this is a subform showing what software the user has installed on the machine and on an alternate tab it shows the software license's purchased and assigned to that machine. So far so good.
However I want to create a button in which the user can add software for that particular person in the fields. The user will select the software from a listbox filtered by combo boxes filtering by Software Vendor etc... My problem is that when the user has selected this software title either via double click or an update button i want it to update the tblReference table. So baisically i need this button to grab the User_ID, Software_ID and Hardware_ID and place it in the tblReference table as a new record.
Hopefully i have explained this well enough for people to understand below is a jpg of my current main screen so you can hopefully get a jist of what im trying to say and do. However im open to suggestions if people feel they know a much better way of achieving my goal.. as i sed its friday afternoon and im feeling particulary slow so you'll have to forgive me!
Any help is much appreciated.
View 4 Replies
View Related
Aug 15, 2012
how do I search for how to open an MDB in development mode, not active running mode ?
View 4 Replies
View Related
Mar 14, 2007
Hi
I keep the production version of my database on a server, and a copy of it for development work on my desktop. Today I've made several changes to the development version, which didn't work. I then opened the production version held on the server in a separate MS Access window to compare the queries/results to see where the problem was and have found that the changes have automatically updated in the production version. Can anyone explain this? They shouldnt be linked at all. The 2 versions both link to a datawarehouse through an ODBC link, but shouldn't be linking to each other (I'm using Access 2003).
Cheers :)
View 2 Replies
View Related
Jul 24, 2013
old Access database that's been upgraded through to Access 2000 or 2003 (probably 2000), but not beyond. Was rebuilt in Access 2003 format around 2006/2007 (by someone else who no longer works here). Being used now in Access 2007 and 2010. Uses DSN to connect to SQL Server backend. Last week it was SQL Server 2005, moved the back end on Saturday to SQL Server 2012. Changed the DSN when moving to the new server. But I don't think this has to do with the DSN (it's getting data just fine).
There's a data entry form. User enters a Generator ID, event triggers it to look for the details for the generator and load them into a generator subform. After it loads the information into the subform, and before the user does anything else, it throws "This connection cannot be used to perform this operation. It is either closed or invalid in this context."It triggers post update of the Generator ID:
Code:
Private Sub txtGeneratorID_AfterUpdate()
On Error GoTo Handle_err
Me.txtGeneratorID = UCase(Me.txtGeneratorID)
Call FillHandlerSubform(Me.subGeneratorInfo, Me.txtGeneratorID.Value)
If GetGenStat(Me.txtGeneratorID.Value) = "N" Or GetGenStat(Me.txtGeneratorID.Value) = "OB" Then
MsgBox "Warning Generator Status! " & UCase(Me.txtGeneratorID.Value) & vbCrLf & _
"This Generator has a status of N or OB!", vbCritical, "Bad Generator Status!"
Cancel = True
End If
[code]....
It doesn't throw this error in the development copy of the database, dev copy works just fine. It only throws it from the production version. They are located on the same network, just in different folders. They are pointing to the same database on the same SQL Server using a DSN file located inside the folder where the .mdb file is located (this is a change in the front end, prior to this it was using a DSN on each individual machine, but I changed it to stop that).
View 6 Replies
View Related
Jan 8, 2014
I have created a simple login form that is based on User Name and Password.the table contains UserName, First Name, Last Name, Password and User Role(dev, admin...ect.)How can I change who can access different parts of the database?I want all the Development tools only accessable to People who have "dev" as a "User Role".Admin can only access the forms related to data entry and managers can view all forms but not the tables, querie and tools...ect.
View 3 Replies
View Related
