General :: Determine Rate For Charging Application Maintenance And Support Fees

Aug 17, 2013

I've built and implemented an Access 2010 application for a corporate client. It's entirely menu driven, with no user access to the navigation pane. It's split with multiple BEs on a share drive and the FEs on individual PCs (distributed via Auto FE Updater). Two hundred users have been defined to the application but so far there are only up to 10 max concurrent users at a time.

The clients want to add more users to the system but after that will go into maintenance and support mode. The question is how much I should charge for the maintenance and support service on a monthly basis.

I'm not looking for a $ amount as much as strategies/guidelines for pricing. The clients anticipate using the application for about four years, at which point a new, corporate-wide application should be rolled out and my app will get replaced by it. They will probably need to convert the data from my app into the new app, and will want/need occasional enhancements to the system over the next four years as well.

View Replies


ADVERTISEMENT

Using Country Field To Determine VAT Rate.

May 9, 2007

hey,

i have a customer form which includes a "Country" combo box.. the reason i did this is because i have a separate table with a list of countries and their VAT (Value Added Tax, you americans call it sales tax i think :)) rates.

i want this country saved in the customers table.. i need the country table to act merely as a source of data. Now ive spent a good hour tying to fix it messing around with the relationship between the two tables and the combo box itself.. but ive only been able to come to two end results

a) access tells me i cant save the new customer record cause a related record is required in the country table.

b) access enters a new line in my country table with the autonumber of the country selected on the add new customer form in the Country field.

im stumped as to where the problem is:// how can i fix it?

View 5 Replies View Related

Queries :: Average Call Rate - Determine If Trend Is Up Or Down

Jun 28, 2013

I have a query that displays the average call rate on various pieces of equipment over the last 12 months. I was wondering if there is a way to have Access look at this query and determine if the call rates are trending up or down over that time frame. Kind of like a trend line would do on a chart in Excel, only I want this to show me the word Up or Down in my results. Is this possible?

Here is the query I am using:

Code:
TRANSFORM FormatNumber(Avg([All Call Rate]),2) AS AvgCallRate
SELECT List_With_TNC_tbl.Device, List_With_TNC_tbl.Model, List_With_TNC_tbl.[Item Num]
FROM List_With_TNC_tbl
GROUP BY List_With_TNC_tbl.Device, List_With_TNC_tbl.Model, List_With_TNC_tbl.[Item Num]
PIVOT Format([Month Start Date],"mmm") In ("Jan","Feb","Mar","Apr","May", "Jun", "Jul","Aug","Sep", "Oct", "Nov", "Dec");

View 3 Replies View Related

General :: Schedule Maintenance - Reminder By Date

Jul 15, 2015

I have a table called schedule maintenance.

In that table I have a "date" field

Is it possible that if " todays" date = a date in the field date a e-mail can be sent to me to remind me there is a scheduled maintenance to be done.

View 6 Replies View Related

General :: Rate Calculation Over Period Of Time - MDB Format

Jan 29, 2014

Calculating the rates over a period of time. I think the attachment will give you a clear picture of what I am looking for.

To get the cost for a particular period I want the rates to be updated as per the given period. How I could get the calculation in the mdb format...

View 4 Replies View Related

General :: Lookup Criteria - Rate To Calculate Salary

Sep 6, 2012

I have one table with employees and positions. Each position has a specific rate which is stored in another table (table2). Since the rates of the positions are changing, I want each time the employee get paid with the correct rate.

The problem is that I do not want to lose historic data since I want the rate to calculate the salary. I thought that the best way is to look up for the rate according to the position and the period that is valid.

I have attached herewith a small example with the two table that I want to use the relationship.

View 3 Replies View Related

General :: Object Class Does Not Support Set Of Events

Aug 14, 2015

I have Access 2007 database.

I and trying to link to Outlook 2007 using the "External Data/More/Outlook Folder option and keep getting the "Object Class does not Support the Set of Events" error message.

I can link to a DBF and Paradox file without any problems.

I am running Office 2007 Professional and Access 2007 and Windows 10.

I have also done the following:

1. Removed Office 365
2. Decompiled the Access VBA code and corrected any issues
3. Compacted/Repaired the database

I have attached a screen shot of the references that I have selected.

This is a new setup as I recently purchased a new PC and Windows environment. I still have the old PC running Windows XP with the same configuration and it also experiences exactly the same error message.

View 6 Replies View Related

General :: Front End - Object Or Class Does Not Support Set Of Events

Oct 17, 2014

I have distributed my front end on the shared drive for users to copy to their desktops.

In one form I have a formula in the query that show's the word 'Gap' if any of the 15 questions on the form is equal to 'fail'. It runs on current when the user is in a record it shows the word 'Gap' at the top header part of the form.

When the user opens the form they get an error message pop up that says "The expression On Current you entered as the event property setting produced the following error: Object or class does not support the set of events."

Once they click 'ok' they are able to work in the form until they attempt to filter records by their name it pops up again.

I've tested on my end and no errors or issues come up.

View 1 Replies View Related

General :: Front End Support For MS Access Login Form?

Aug 3, 2015

I have created a Login form in Access Database in which the users can log in to enter the work information like how much time and which job they worked on particular day , this data is stored in a table . How can make the users to use this form , I dont want to access to be installed on every machine..I want to give something like a URL so that the users can use it..

which software I can use for creation of website so that it can be compatible with ms access ...I basically need to create a front end application and connect ms access my project in the back end scenario..

View 6 Replies View Related

General :: Error - Object Or Class Does Not Support The Set Of Events

Oct 9, 2014

Couple days ago our database was not opening, Access would open but show a blank workspace. Anyhow, we restored the database from Server and it worked on all 5 shared systems on company's network but this one computer. It is giving the error, "Object or class does not support the set of events."

I tried to copy new local folder but nothing. I checked the links and target folder it looks fine.

I tried to import the everything into new database but it said I don't have permission for that.

what's causing this issue and what can I do to fix it?

View 3 Replies View Related

Guidelines Needed Regarding Charging Clients

Nov 18, 2007

Since I left school I have had to jump into application design on my own because I am finding it difficult to find work without 1 to 3 years of experience typically required by the current job market. This leaves me without any gut feeling for how to charge my customers. Charging by the hour is difficult to do fairly because I am not as efficient as more experienced programmers. Charging by the form, query, report, macro, or module, however, doesn't accurately capture the time variable associated with extensive scripting. Any guidelines offered in regards to charging and possibly ballpark rates would be hugely appreciated!!!

View 7 Replies View Related

General :: IIF Statement To Determine A Closed Form

Oct 12, 2012

I am running Access 2010. I am building a form that is finding the "Docket Numbers" from three different forms. In order to get these numbers, I put in three text boxes with these statements:

Text box1
=[Forms]![Jobslist]![Docketnumber]

Text box2
=[Forms]![Jobslist2]![Docketnumber]

Text box3
=[Forms]![Jobslist3]![Docketnumber]

However, not all three forms will necessarily be open at one time so I am trying to use an Iif statement to check if the form is open. I can't seem to figure out the function to check if the form is open. I am looking for something along these lines:

Text box1
=iif([Forms]![Jobslist] = closed,"",[Forms]![Jobslist]![Docketnumber]

What i need to figure out is what to used instead of "= closed".

View 9 Replies View Related

General :: How To Determine A Directory With Given Path Which Is Empty

Jul 9, 2014

In Access, how to determine a directory with given path which is empty?

View 7 Replies View Related

General :: Sending Email With SendObject - How To Determine User Name

Apr 27, 2015

When I send an email from Access with SendObject, how does it determine the user name, the 'from' name. Is it just the user's Outlook name? Do I have any control over that?

View 1 Replies View Related

General :: Determine Value Of Any Field Based On True And False Statement

Aug 5, 2013

In a form, the value of any field may determine if the other field will be true or false. For example in my form, inventory, if value in code is equal to 2 then the Field Table will be automatically false.

View 12 Replies View Related

Calculating Student Fees

Jun 10, 2005

I am handling a group of students and I want to calculate the fees coming from the student. Does anyone knows how to develop a tables and forms in microsoft access?

View 1 Replies View Related

How Do I Create Monthly Fees?

Sep 21, 2007

I have stuck in something and i hope someone will help me with this: I have created a DB which shows all the students of a musical school. Each student pays a monthly fee (sep-june, 10 payments per year). I dont want to create all these columns in my main table beacause it will be too crowded. The only thing I can think of is to create 10 different tables one for each month but i think it won't work well when I want to see how much a specific student pays.. any ideas? the information for each month that i want to have is the student first and last name, date of payment, level, fees amount and money paid (and perhaps month name..).
Thank you in advance guys!

View 6 Replies View Related

Database Maintenance

Aug 17, 2007

Hi folks,

I have searched on this, but did not find any article that is comprehensive enough. I wonder if anyone can advise on database maintenance routines particularly for Microsoft Access.

I know:


Regular Back ups
Compact and repair database


Please fell free to add on to this list.

Thanks,
B

View 4 Replies View Related

Maintenance Scheduler

Feb 13, 2006

Morning guys and gals

I am trying to create a sceduling calendar for my department which displays given events day by day.
I have created this using subforms for each day and a combo box to select the month.
For display purposes it works fine but I am having a little difficulty with the functionality.
I want to be able to click into any of the subforms, and depending on whether there is data within, open a specific document.
1)If there is an item in the schedule the I want to open a report filtered for that date.
2)If the day is blank then I want to open a form to input an item. (This works but I cannot get the date to pre-fill)
I have created a seperate piece of code to do this but it doesn't want to work. It may be because my knowledge of VB isn't what it was or it may be that I am completely barking up the wrong tree.
Hopefully someone can have a look and let me know where I am going wrong.

Code

Private Sub OpenCalRep(date1 As Date)
If date1 = Null Then
DoCmd.OpenForm "frmmaintenance", , , , acFormAdd
Forms!frmmaintenance.txtDate = Forms!frmcalsite.txtDate
Else
DoCmd.OpenReport "rptmaintenance", acViewPreview, , "Tables!tblmaintenance.txtdate" = "forms!frmcalmain.sf1.form!txtdate"
End If

End Sub

I realise that there is no counter to increment the subform name yet (SF1, SF2, etc) but I want to get the code to work for just the first box initially so I know that I'm heading in the right direction.

This code is the prefilled from the subform by using:

Private Sub SF1_Enter()
OpenCalRep (Forms!frmcalmain.SF1.Form!txtDate)
End Sub

I realise that there is no counter to increment the subform name yet (SF1, SF2, etc) but I want to get the code to work for just the first box initially so I know that I'm heading in the right direction.

Regards

Jason

View 14 Replies View Related

General :: Wrapping Up Application

Nov 14, 2013

I want to wrap up an Access 2013 desktop app so that the user only sees the splash screen. I can get rid of the Navigation pane, but not the Ribbon or the Quick Access toolbar. At this stage I do not want to split the db or prepare it for distribution. I don't really want to generate a custom ribbon, as I shall need the standard one for development.I'm sure this used to be easy back when I last used Access (97), but cannot believe that I cannot find it anywhere in 2013.

View 4 Replies View Related

Forms :: Attendance Tracking And Fees Calculating For Gym Database

Apr 11, 2013

I'm creating a Gym Database and need to be able to track attendance for specific classes. I need to have a system in place allowing me to do a register for attendance for each activity.

I also need to be able to calculate fees based on attendance. So if a person attended Gym 5 times in the month (£5 per session) and then Swimming 3 times in the month (£2 per session). My system should automatically calculate this based on the attendance tracking.

Also: In the booking stage, I need to have a field telling me how many spaces are left on each activity. Say for example I'm booking Person 99 in for Swimming and there is only 11 places left I need the field to display 11 places left. After that booking it should update saying 10 places left because Person 99 is booked in.

View 1 Replies View Related

Record Maintenance Across Forms

Jun 7, 2007

My database consists of several forms linked by open form buttons that function as "previous" and "next" navigators through this series of forms. Each time I switch from one form to the other, the record jumps back to the first record.

Question:
When entering a new record, how can I make it so that when I switch from the first form to subsequent forms, the record on the subsequent forms will match the record on the form prior to it without having to use the record navigation buttons at the bottom of the form.

View 5 Replies View Related

General :: Deploying Access Application

Jul 22, 2012

i have an access application with a navigation form to browse through different forms & reports.i want to know how can i use it over my lan network as an intranet website ?can i convert it simply to html interface or what ? i know about access runtime but if i want to deploy it into intranet ( i.e. browsing through web browser ) what r the different methods?

View 3 Replies View Related

General :: External Access To Application

Apr 8, 2015

I found the way to make my app absolutely (???) secure. But there is one problem I can't find a solution: how to prevent anyone to sneak in my app?Of course it is possible to hide the VBA but I found nothing about the Access objects.

View 13 Replies View Related

Yearly Planned Maintenance Report

Apr 4, 2007

Got a little system going whereby when a job is created it will display the date that the job is next due by.

I'm trying to work out how to create a qry that will display all due dates & not just the next one.

Here is how it should work.
If a job is created on the 1st of April 2007 & the type of job is MONTHLY then I want it to list the rest of the monthly orders that are planned for the year.

Here are the different PPM types that I'm using to calculate with
8784= Yearly
43848= 5 Yearly
2208= 3 Monthly
744= Monthly
168= Weekly

Has anyone done anything similar cause I can't see how it can be done?

This is what I'm using to create the next date due

NextDue: DateAdd("h",DLookUp("[PPMNextDue]","[tblPPMType]","[tblPPMType]![PPMID]=" & [PPMID]),[DateReported])

Here is my qry that the above code is in.
SELECT tblPPMType.PPMID, tblBuildings.PropertyName, tblPPMType.PPMType, tblTasks.DateReported, tblPPMType.PPMNextDue, DateAdd("h",DLookUp("[PPMNextDue]","[tblPPMType]","[tblPPMType]![PPMID]=" & [PPMID]),[DateReported]) AS NextDue, tblContracts.ConDescription
FROM tblContracts INNER JOIN (tblBuildings INNER JOIN (tblPPMType INNER JOIN tblTasks ON tblPPMType.PPMType = tblTasks.JobDetails) ON tblBuildings.ProID = tblTasks.BuildingID) ON tblContracts.ContID = tblTasks.ContractNo
ORDER BY tblPPMType.PPMType;


This is the result.

DateReported---------PPMNextDue--------NextDue
14/03/2007 14:35:34----8784----14/03/2008 14:35:34
15/03/2007 15:08:00----8784----15/03/2008 15:08:00
15/03/2007 10:07:11----8784----15/03/2008 10:07:11
14/03/2007 14:52:56----2208----14/06/2007 14:52:56
15/03/2007 15:10:21----2208----15/06/2007 15:10:21
15/03/2007 10:19:35----43848----15/03/2012 10:19:35
14/03/2007 14:54:13----43848----14/03/2012 14:54:13
14/03/2007 14:55:15----4416----14/09/2007 14:55:15
15/03/2007 22:36:27----744----15/04/2007 22:36:27
14/03/2007 14:56:30----744----14/04/2007 14:56:30
15/03/2007 20:34:27----744----15/04/2007 20:34:27
18/03/2007 22:38:41----744----18/04/2007 22:38:41
15/03/2007 13:39:02----744----15/04/2007 13:39:02
15/03/2007 10:58:55----168----22/03/2007 10:58:55
14/03/2007 14:59:21----168----21/03/2007 14:59:21


Any suggestions will be welcomed

thanks :)

View 2 Replies View Related

General :: Parameter Box Pops Up On Application Quit

Jul 17, 2013

When my database application is closed a parameter box pops up asking for parameter from text16 but only if the Navigation Pane is hidden.

Some information:

The application starts with a login screen that has a hidden text box (text16) that allows me to limit what users can access throughout the database by setting it as the query criteria.

If a form is open that is gathering its data from one of these querys and you try to close the application the parameter box opens which is simply annoying for my users who do not know about access.

The interesting thing about this is that if I unhide the Navigation Pane and close the application with one of these forms open it closes fine with no parameter box pop up.

The goal is to have the Navigation Pane hidden and the parameter box not pop up.

Added information if the navigation pane is hidden I can use a command button with a macro that closes all open forms then quits application and this does not cause the parameter box to pop up.

So another fix for my problem would be to disable the "X" close button at the top right of the application.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved