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 Replies
ADVERTISEMENT
May 2, 2007
Hello, I am in the process of trying to get my database so i can access over the web.
Currently over the Lan I have the main database located on the server, and have created a replication for the two clients. This works over the lan where i can open the original and sync etc etc. How can i get this to work over the web so I have the same functionability as the lan method but over the web. I thought of some kind of interface but im not sure on how to do this.
Thanks in advance
Craig Clarke
View 3 Replies
View Related
Jan 7, 2006
Hi, based on previous advice I had merged my customers and owners into one table and selected whether a client was a customer, owner or both via a lookup table.
This is working fine, however I must assign a rep to each owner, I'm not quite sure how to do this, I need to be able to assign a rep to an owner in the clients table, I must also make sure than a rep can not be assigned to someone who is just a customer obviously.
I have attached the database (http://jonroberts.redirectme.net/database.zip), hopefully that will make things more clear.
Thanks in advance.
View 2 Replies
View Related
May 31, 2005
Ok, I am getting to know MS Access much better than now that I am asked to design a MS Access database...
We have a small company of 20 users. The reason for the database creation is to keep track of the hardware & software inventory that we have. Sometimes, users borrow softwares or laptops and we want to keep track of it. My boss also wants to know how many workstations and how much memory we have in there kind of things. You know, basic inventory...
So, we have 3 servers, 20 workstations, 5 printers, licensed softwares, few hubs, and router... Nothing fancy, a small shop.
So to design this database, I read some MS Access database design guidelines... However, I am still not clear whether I have set it up right because I learned that design part is the toughest part. If the design is good, then rest should be easy... At least right?
So I am thinking about creating 2 tables. Why? Our inventory really is hardware and software, I think. I don't think we have other things...
One table I am thinking of creating is Hardware_Inventory and the other Software_Inventory since that is our goal to create an inventory to keep track of what we have, who has it, where is it, when did we purchase it, how much is it, and what is in the hardwares?
So I created in each table - fields, but I'm not sure whether this is done correctly. Again, I wanted to answer few things if someone were to look at the database: what is it, where is it, who has it, when did we purchase it, how much is it for soft and hardwares, and what is in the hardwares?
Note: Property_Code is going to be a key number or a property tag I will get to put on it and have it as a Primary Key.
Hardware_Inventory_Table:
Property_Code
Description
Make
Model
Model_Number
Year
Serial_Number
Purchase_Date
Purchase_Price
Warranty
Department
Location
On_Loan_To
Duration
Checkout_Date
Checkin_Date
Comment
Software_Inventory_Table:
Property_Code
Description
Vendor
Version
Product_Key
Year
Purchase_Date
Purchase_Price
Warrnaty
Department
Location
On_Loan_To
Duration
Checkout_Date
Checkin_Date
Comment
Then I was going to link the Year, Purchase_Date, Purchase_Price, Warranty, Department, Location, On_Loan_To, Duration, Checkout_Date, Checkin_Date, and Comment....
I need some expert advice whether I have it set up right in the design, whether I have chosen the correct fields, and whether I have made the correct link? Or anything that I need to address or re-design...
thank you,
carboncopy
View 4 Replies
View Related
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 1 Replies
View Related
Dec 25, 2006
I have a table -'client' with 5 fields,
id
name
address
email
mobile no
I want to see only those clients who has email id.
I know its simple but not so simple to a layman like me :)
Please help
View 3 Replies
View Related
Jul 29, 2005
I have a database with a list of clients, their enter and exit dates. I need to do a query that will count how many clients we have on a specific date. Keeping in mind that clients leave. I can do a query that will prompt user to enter a date. However, how would I count the total number of clients on that date? thanks a lot for any help!
View 3 Replies
View Related
Jul 3, 2013
I have a table that contains clients. There are a few select times when there will be one client organization but I will need to have two entries--say when one department has a separate contact & record of events than another department.
In most cases these separate departments can be treated as entirely separate clients however in some ways they should be counted as one--such as when counting the number of clients that we serve.
What is the best way that I can accomplish this?
My current idea is that when this situation arrises I have some type of command button that will create a new client record in the table, copy the information from the first record, then I can change it as need be.
I don't know if this is possible, how to do it, and how to set up queries that will recognize the two entries as one record. I don't even know if this is the best way to do it
View 2 Replies
View Related
Apr 11, 2014
I need to create a report from a query. I have created the query that pulls the below data from the relevant tables:
ClientName;invoiceAmount;InvoiceDate
Using the wizard I have created a basic report that shows the information in the query, but I need it to list all clients and all months - even if some months show no invoices sent.
Ideally it would show as follows (with an option for the relevant year to display):
______ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Dec
Client1
Client2
Client3
Client4
Do I need to create a separate tables for Month/Year and link these to the query? Or is there a simple function I can put into the query to achieve this? It seems a simple task, but after playing for a week I've got no where
View 9 Replies
View Related
Apr 9, 2013
I'm creating this database for a claims management company. Yesterday I learnt about making a many to one relationship between the claims and clients tables.
Turns out its more complicated than that. Since I'm dealing with claims, a person may add their partner as the second claimant. (usually the case in mortgages)
So where parties A and B are in a relationship:
person A may claim on their own
Person B may claim on their own
Person A may be the primary claimant and add person B
or conversely person B may be the primary claimant, adding person A.
The end goal is to automatically fill in a financial form (making use of a mail merge). So from what I know I think this means:
that grouping them as one contact is not going to work as I need them to be able to do a solo claim, and also I will not be able to easily change around who is the primary or secondary claimant, which will then carry over onto the mail merge.
So I think this means I need them as two separate contacts. However, I don't know how to create a link between them to easily add their partner to a claim.
Would this also mean I need a many to many relationship between clients and cases.
View 4 Replies
View Related
Jul 4, 2006
Hi all,I've been struggling with this for a few hours... I sure hope that the solution to my problem is complicated so I don't feel really dumb!I'm trying to design a database to eliminate the HOURS that my mom spends trying to format mailing labels in Word. She deals with about 50 clients at a time, and sometimes needs to print labels for just a selection of them, but not all. I'd like to design a form where she can select (using an option button or similar) the clients for whom she wants to print a label, and print them all at the same time (rather than printing one at a time, which I can handle on my own). Creating mailing labels will be the only function of the db so the info stored in it will be relatively simple.I have the Northwinds db installed, and I've found the sample Macro controlling the Where condition for the labels report. I understand how to make it work for a single selection from a combo box (ie: only print labels for customers from a specific country)I have my report set up so it shows a label for each client, pulling data directly from the main table. No troubles with formatting. **knocks on wood**My problems:1. I searched this site and found a link to the MS KB file that outlines how to print multiples of one label or skip used labels before starting to print (Q95806 - "How to Skip Used Mailing Labels and Print Duplicates"). I'd like to use this, but can't make it work.2. I can't figure out how to "link" the option button to the client name as it's listed in the form, and then tell the report to only print labels for the selected clients.I have very little coding experience but I can make some simple code work and am OK at customizing pre-written code to my own needs if it's well commented, so VB isn't entirely out as an option.I have a possible solution in mind that involves creating a query that makes a new table with only the selected clients, which is then used to make the labels report. I think I could make that work if I could just figure out how to select the clients in the first place.I apologize in advance if this has been taken care of elsewhere. I tried to find it, but had trouble coming up with the right search string!Thanks in advance,~ Mel ~p.s. I'm using Access 2000.
View 3 Replies
View Related
Sep 14, 2014
find only some clients that has only 4 types of products, but no other type of products.
Just to put it in a much easier way to understand. If I have to find only the client that did buy only 1 or more from the 4 products. Fridge, tv, dvd player, mobile phone. But I'm not interested in the clients that also did buy for example, laptop, pc, video cameras, etc. So if the client has only one of the 4 products, I want to list them all, did they buy another type of product too, then not.
How could I create a query that will show me only those clients?
View 4 Replies
View Related
Sep 10, 2013
I am using Access 2010. I've calculated the age of clients by creating a new field with Age: Year(Now())-Year([D O B]) but I cannot figure out how to use a parameter query to return the age of the clients between age 20 and 30, 30 and 40, 40 and 50 etc.
View 14 Replies
View Related
Sep 21, 2014
I have a report that has multiple clients on each page. In the report, some clients have data for a specific date while others do not.
I would like to be able to Save As PDF each page to a specified folder but only if that client has data in the report. I am currently doing this in Excel, but would like to move my data and reports over to Access. My Excel VBA code is:
Sub SaveAsPDF()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Range("B66").Value <> "" And _
ws.Name <> "Notes" And _
ws.Name <> "Lookups" Then
[code]...
Which says if B66 is empty then don't Save As PDF. Is this possible to do in Access?I'm very new to Access and have never used VBA in it before.I would like to be able to create a button in a form that when I click it will run this code.
View 1 Replies
View Related
Aug 30, 2013
Ok, not sure if this is even possible or where to even start..
I've got a form that has all the info for a client, eg..
Client First Name
Client Last Name
Client Hours
Client WE/CS/EE
Client Day And Times
Client Phone
Client Comments
Begin Date & End Date (2 boxs) on there for date input..
and what i'm trying to do is limit that any date entered between begin date and end date, it'll check and make sure there is only ever 20 clients on any 1 day..
i thought Datediff would be the way to go, but then again how do you get it to search each day and make sure theres only 20 clients on there..
View 1 Replies
View Related
Aug 5, 2015
I am printing statements for clients. Depending on certain criteria about the client, the format of the statement changes completely. This is just how the boss wants it, I have no control. I still want to generate all statements at one time (not separate reports).
I currently have this working using multiple subreports, and changing their Visibility property, only one being visible at any one time. This works, but it is very slow, I assume because I am basically making Access do triple the work (I have 3 subreports).
I pretty confident this is not the intended use of subreports. Is there a "correct" way to do what I am doing? I know I could just manipulate everything with VBA, but having subreports makes editing the different formats very easy.
View 10 Replies
View Related
Feb 4, 2014
I have a Client database table in Access. I now need to add a simple order table (related) to the client table. I have a client ID field set to autonumber in the client table. As I start to create the orders table I'm not sure how to link the two so that I'm not entering data twice and have assurance that they are tied together.
View 4 Replies
View Related
Apr 22, 2013
I am trying to build a database for the handling of events for our clients. I therefore do have four tables named "Client", "Invitation", "Invitation status" and "Events". The table invitation includes an own primary key and the primary keys from the tables "Invitation", "Invitations status" and "Events" as so called secondary keys. I have now built an ongoing form, based on the "Client" table.
This form has a list field which includes the upcoming events. All our clients are listed below this form (as it is an ongoing form). After the name of the client I do have a drop down field calles "status" (source is the table "Invitation status" where we can remark if the client is invited, has confirmed his attend and so on.
The problem is now as follows: I am able to put in the status of a specific client for an event. The result is saved in the table as wanted. I am also able to change the status and this will be saved in the table as well. What doesn't work is that if I want to change the event, the status doesn't change. This means that if a client hast the status invited for event X he has the status for all events, which shouldn't be. The aim would be that if I am changing the event, the status also has to change.
View 1 Replies
View Related
Jan 13, 2014
I am running a report based on a query for a bunch of people who take medication. It runs the report and puts page numbers in the bottom right. Works perfect but I want it to do page numbers per person rather than the whole report. Is that possible to do or would I need to run some code to do them all individually?
View 1 Replies
View Related
Mar 19, 2014
I'm new to Access. It is obviously a very powerful database program I've developed a data base of my agency's service purchases for a variety of clients. I have to generate a report totaling the monthly purchases and counting the number of unduplicated clients. We make multiple purchases for clients monthly. There must be a feature on this program that will sort through the client ID Numbers and count them (rejecting duplicates) in that one month or quarter or year. I've been exporting to excel, sorting by client ID and then counting each new ID number.
View 2 Replies
View Related
Jul 2, 2013
We have a split ACC2010 database, with the back end on our server and 5 front ends on 5 client PCs. I hadn't run a compact/repair on the back end for months. When today I tried, I got the 'database is locked' error. The lock file showed 'Admin' logged on at all 5 clients. The front-ends had been closed on all 5 clients. We do not have a user called 'Admin'. Because my issue occurs for all clients, it might be caused by some sort of programming error in the front end.A VBA bug (implicit comparison to a control in an If .. Then construct) caused this type of behaviour but was resolved in Access 2007.
View 12 Replies
View Related
Sep 17, 2014
I have a requirement to send a email to individual clients via my access database 2003 . I am using the email address of the client in the current open form . I then created a query using the id to filter that particular client, this query then becomes my record set.The content for the email is held in a .txt file , On my c drive . Every things appears fine however the fonts that I select in the .txt file are not being use in the actual email body. I created a word document with my preferred fonts and copied and pasted them into the .txt file but on sending the email the selected fonts do not appear.
I have attached a demo of what I am trying to do . To test enter your own email in the email address field of the form . Note the .txt file is on the C:/ drive.
View 4 Replies
View Related
Oct 12, 2007
Ok let me explainI have a list of 50 people who may have accessed events A,B,C at different times but what I want to do is to put a date in my form, run the quaery which will list all people who have Attended A,B or CWhen I do my normal query, I put the fields in, but if I put a date filter in Event A, it will not show up any person who may have attended event B but not Event A.I thought about running an append query but this would mean running the data several times with possible duplication of client names.Ideally I would like to have my report to showDate: 31/07/2006Name A B CK.Brown Y YJ Blogg Y YK Smith YK Ellum Y Ythen I can just use a count at the bottom :)The methods I have tired will filter event date A, but will not show J BloggIf I create another append for Event B, and append that data to a table, then I will have duplicaion of K Brown.. Any Help Appreciated.Last thing - when I run the append queriy and get my duplications, the fields where I had a Y/N option - if it was YES then I get a -1 instead of 1 ??? Why? and how do I make sure that when appending that the Y answer is a 1 not a -1
View 14 Replies
View Related
Apr 29, 2005
I need some help on a database that is set up for work use.
It's rather large and I have no technicial knowledge of access whatsoever so an answer in plain english would be appreciated.
I have attached a picture of the screen that i am having the problem with. The blank fields contain peoples names and addresses. On this page i have to click on "update service user" on the first user, the database opens a seperate page and i enter a few details, then i click to go back to this screen.
When I return back to the screen, the scroll bar is at the top of the list. This is OK when I am doing the first few letters of the alphabet (the users are listed alphabetically) but when i have too use the scroll bar and choose the letters later down the list, then click to update then return to the screen and the scroll barr is not where i left it...ie: it's at the top.
So what I am asking is, is there a way of freezing this scroll bar so it will stay there even when i have navigated away from the screen to update each user?
If someone could answer me this query then I would be most grateful as it's quite time consuming for me to use the scroll bar and find the next person that i need to update.
View 2 Replies
View Related
Mar 15, 2006
Hi, looking for help big time!! I am a novice at using MS Access and struggling like hell. I have been set a project at University that requires me to import data from Excel, sort the data (i.e the data imported will be for a whole year and I am only interested in looking at single months), use calculations on the data imported and display this graphically. Is this possible with Access?? Any help will be gladly received as Im desperate.:(
View 1 Replies
View Related
Sep 18, 2006
I have a multiple user access database on share drive with user-security level created. I created myself as administrator, and remove default Admin from Admin group. Removed permission from user group and joined workgroup file which I created as "MBS work group.mdw". I created shortcut on user's computer. I believe the syntax is correct
"C:Program FilesOffice 2003OFFICE11MSACCESS.EXE" /wrkgrp "\ServerNameMBS DatabaseMBS Work Group.mdw" "\ServerNameMBS DatabaseMBS.mdb"
Everything works fine. When I directly double click the database (MBS.mdb), it pops up a login box. However, when other user double clicks the database directly (not from shortcut) from their station, login window doesn't pop up. It allows them to access the database. I saw the work group file used default System.mdw
My question is how can I restrict them by double clicking the database without go through shortcut? Why my database security not protect user access without give user name and password. I tried by joined user’s work group file to MBS work group.mdw. It works, but I don’t want let user manually to do that one by one.
Is there anybody can help me go through this problem?
View 10 Replies
View Related
