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 Replies
ADVERTISEMENT
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
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
Apr 30, 2013
I want to create a country info database. For example, Qatar (country) and the Driving info required when driving in qatar and the visa info required.
I would like a form with drop down options and when i selected which country and then driving or visa, at the bottom it would display the specific info based on my selection in a memo field lets say.
View 1 Replies
View Related
Sep 22, 2013
I have a combo box in a sub form with three values, rate1, rate2, and rate3. I have another three fields in the sub form rate1, rate2, and rate3. The rates are dependent on the item. When I select the rate from the combo box I want a cost field to update on change to the relevant rate. I tried this to no avail:
Code:
txtCost = DLookup(cboRate.Value, "tblItem", "ItemID=" & ItemID)
View 5 Replies
View Related
Apr 24, 2006
Hi,
Im using square bracketed parameters in my query designs for user prompts. Now I want a similar feature to tell the query what field I want it to show. Is there a way of doing this please? - or does the fact I need to do imply a db design flaw?
View 2 Replies
View Related
Apr 14, 2008
I have a field on a report which I am struggling to produce the right query for.
I have a table - tblTillDept which consists of a 4 fields. The first is the PK, which is the number of a till department. The second - fourth fields are names of 3 different branches of the small garden centre I am writing the database for. The values in these fields are the names of the corresponding departments. Not every branch has exactly the same name for each field.
Prior to the report being is run, a small form, frmCentre pops up asking the user to select the Centre they are printing the labels for. They select the name of the branch from a combo box (cboCentre) bound to a field list of tblTillDept. When the report is formatted, the intention is that the value of this combo box selects the field from which the value for the department is taken. I can see that I need to set the control source of this property to some sort of query, but I can't quite work out how to do it.
I've uploaded the database, written in Access 2000, here (http://www.moppy.co.uk/plants.mdb) as it's too big to post as an attachment.
View 1 Replies
View Related
May 2, 2014
How to determine if a field within a table is a primary key or part of a compound key using ADO?
View 1 Replies
View Related
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
Jul 11, 2007
Hi
My name is Dana and this is my first post here .
I am a DB newbie , i started to teach my self MS Access with a small project as a start .
I made a simple client data table where there are country and city fields + phone , fax , etc etc ... .
I made 2 tables 1 for the countries and 1 for the cities .
I know that it is a very familiar question :o
How can we do the following
when you select a country in the client table , only cities of this country show up in the city combo box .
I found some answers here and there , but as a newbie , the codes where difficult to understand .
I attached my source file and i will be thankful if someone could help and to give me a simple explanation of the codes concept .
I just want to add the codes in the table not in a form , i found some answers by adding codes to a Form :confused: . Because as i know i can export only tables and queries to sql.
View 7 Replies
View Related
Feb 21, 2007
Hi All!!
I need help with the code for a combobox. The thing is that I've created a form where the user has to select the country, then the state and finally the city. What I need is that once the user selects the country, the combobox of the state shows only the states of that country and then the combobox of the city shows only the cities of the chosen state. I'd appreciate all the help given. Andrew.
View 1 Replies
View Related
Dec 13, 2012
I have a form (Create Guest). Employees can add guests and fill in the details. There is a label Country that Employees can fill in manually.
The problem now is that this is very fault sensitive (people type: "The Netherlands", "Holland" or "Netherlands" for example while this is one country).
How do I create a country drop-down list so that employees won't have to type the country in manually. I don't think adding all the countries in the world in my table is a good solution.
View 10 Replies
View Related
May 28, 2014
I have a table that consist of pricing for different types of products:
Table name: Costs
ID TYPE EastNew EastRenew WestNew WestRenew
1 500 4100 1000 4400 900
2 501 4100 1000 4400 900
3 600 3400 900 4600 1200
4 700 3700 1300 4900 3300
I have a form that consist of many fields that the user needs to manually input data. 3 fields on that form are the criteria i need to determine which pricing to use back on the table. The first field, which name is LTYPE, is a combobox that the user needs to choose as its type (i.e 500,501,600,700). The second field, which name is EastCoast, is a checkbox (Yes/No) that tells me if it's East Coast (East = yes and West = No). The third field, which name is NewRenewal, is a combobox that the user chooses NEW or Renewal).
Example 1, if the user chooses type 501, checkbox is YES for East, Product is NEW. Then the pricing is $4,100
Example 2, if the user chooses type 700, checkbox is unchecked for NO (which is West), Product is Renewal. Then pricing is $3,300
I would like the unbound field to auto determine the pricing based on the 3 criterias chosen. I read around the forums that Dlookup would be the function for this, however, i tried many times but it did not work.
View 6 Replies
View Related
May 1, 2013
i have created tables as provinces, districts and sub-districts in my other forms say member i have create a look up wizard to the provinces, districts and sub districts. every province has multiple cities and every districts has multiple sub-districts my question is how to set properties so that if i select a specific province all its districts should appear in district field and districts of other provinces should be filtered. a good example is on some websites when we select a specific country all its cities or states appear in city field and if we change our option to some other country city drop box also changes to the cities of that respective country...
View 2 Replies
View Related
Mar 23, 2008
Hoi, Well, this is my 1st EVER database and whatever I've learnt is either from here or 'on-the-way'..It's a Libr4ry Database for a college assignment.Basically, I'm a DBA and also an employee at the library.Nurseries come to us/me to hire books for their students/children/whatever.In my DB you canAdd Authors (of books)Add Books Add copies of booksAdd NurseriesDelete authorsdelete booksdelete nurseriesLoan booksReserve booksReturn booksview all authors reportview all booksview all nurseriesview current loansview current reservationsI've attached my DB, have a little play around say what you think about it..I know at the moment there are a few issues: Adding a copy of a book is annoying because you have to add the book first and then go into an other form and add it as many times as you have it. On Loan report you can't see whether or not the book has been returned Authors_ID are stupidly HIGH and i have no idea why? Autonumber 1,2,3-100? No! 1,2,3,4120032,4120033,4120034 etc! Books can be loaned MANY times Reservations can be made MANY times with the same book Can't view the stock level on a book (haven't done this yet) RETURN table doesn't show necessary data such as names of book and nursery just their ID's which can cause confusion RETURN table 'returned?' combo box shows 0/1 instead of Yes/No although Yes/No are in the drop down box it'sself.. LOAN Table 'date due back' textbox shows '#error' when there isn't a date entered in the Loan date textbox..That list isn't conclusive :' )I'll probably find loads more thing wrong with it..But, if you could..just gimme your feedback and what COULD be improved.. and what's sh-t and what's not etc.Database password is my username.Cheers for all the help with it guys/guyesses!:D:DEDIT: if problems opening .zip, rename it too whatever.rar.
View 11 Replies
View Related
Aug 28, 2006
Hello all,
I am talking to a potential customer about doing some contract work using access. This would be my first contract using access and I was just curious what some of you are charging as your rate. I'm a strong developer but my experience has been in a full-time position so I'm not sure what contractors would get paid.
Any help would be appreciated!
View 6 Replies
View Related
Jun 18, 2007
Hey guys,
I have a form that works out the cost of products from £ to € by calcuation where the user puts in the current exchange rate into an unbound text field.
i was wondering is this is at all possible:
to get the current exchange rate automatically off the internet from some kind of website
i would love to hear suggestions.. what kind of problems i am likley to encounter or if any one has attempted or succesfully managed to do this or something similar.
View 4 Replies
View Related
Sep 17, 2005
I've got a question about MS Access.
I've got a table with different customers and different rates that they offer for certain products. The problem is that different customers deal in different currencies. The currencies are one of three; Euro's, Pounds or Dollars.
I would like to create a query that would convert each customers rates to the same currency (pound).
The information is divided into 2 different tables. A customer table and a product table. I've created a form that is based on the customer table and features the product table as a sub-form.
What I would like to do is have an option that would enable me to enter the current exchange rates (as they are constantly changing) which would be used to convert the individual rates depending on the currency used by customers.
Form fields as follows
- cust_id
- cust_name
- company_name
- company_add1
- company_add2
- company_pc
- company_country
sub-form
- prod_id
- prod_name
- currency
- prod_rate
- convert
I'm sure this is possible, but my knowledge on this matter is limitted.
Thanks in advance for any advice given.
View 1 Replies
View Related
Sep 27, 2007
Hi All.
In my employee's table I have EmployeeName, Rate, Date and I need create query to calculate Rate for each eployee between Date if ration during this period of time was diferent.
Thanks.
View 1 Replies
View Related
Feb 10, 2005
I was wondering if it would be possible to type in a description eg.(Days, nights, O.T.,ect.) and have excell automatically insert the rate I specify into another cell.
View 1 Replies
View Related
Nov 13, 2007
I would like suggestions on how to "properly" set up the tables and relationships required to do the following.
We have a customers table that can contain a Country, ShipCountry, and BillToCountry. All 3 countries could in theory be different. I want all 3 to store the CountryID from the Country lookup. I am trying top avoid a circular reference or any data contention issues. What is the proper method to do this?
Thanks very much in advance!
View 4 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
Jan 13, 2006
Hi,
I have a query in which I try to calculate field values depending on the currency and foreign exchange rates.
I have a currency field with the amount value and a combo box where I select the currency for that amount which can be (USD, Euro, BRL, or INR). I have got also another 4 fields with each of currency foreign exchange rates.
I am trying to obtain in a new calculated field of Price in Euros if the amount I have in the 1st field is not already in Euros.
Say:
Field 1 Field 2 Field 3
amount currency F/rate
2000 in USD or Euro or BRL or INR 0.8754
depending what is selected
in combo box.
Field 3
Result
field1 * field 3 in Euro depending currency selected in field 2
Can anyone help, plese?
thank you
dfuas
View 10 Replies
View Related
Feb 16, 2008
I have created a table for customer bills, and a table for customer profiles which contains rates associated with them specifically. The problem is that after a new rate change has been imposed I want to be able to look at an old bill, via a report, and have it reflect the "old" rate within proper historical context. I'm looking for suggestions on how to best manage ongoing rate changes while maintaining a billing rate history in my reports?
View 6 Replies
View Related
Jul 9, 2015
I have a tblShowCosts and in that has the Event ID and the Show tax rate. In my tblShowSales I want access to take the subtotal and times it by that shows tax. Not sure how to tell access if the Show name = such-and-such then times it by the Tax Rate.
View 14 Replies
View Related
May 18, 2015
I am setting up a time tracking database which will track employees maintenance times. Several employees spend X number of hours each day maintaining machines from different categories, such as mowing, snow removal, etc.
I am trying to figure out if it is possible to set the tables up in a way which will not require adding an employees wage rate to every time tracking (listed in the time tracking table below) record. To somehow have the table pull data from the most recent wage record for that particular employee. As employees get raises I would like to retain the old rate in the time tracking table along with the new rate for current data.
The way I have the tables setup right now are as follows.
Employee table
EmployeeIDFirstNameLastNameAddress, Phone, etc
Maintenance Categories table
MaintIDMaintName
Wage table
WageIDEmployeeIDDateEffectiveCurrentWage
Time Tracking table
TimeTrackingIDEmployeeID (lookup from employee table)MaintID (lookup from maintenance table)WageID (lookup from the wage table)DateOfMaintenanceStartTimeEndTime
All of the tables have relationships in the time tracking table.
View 3 Replies
View Related
