Search results

Hi - I'm really hoping someone can help. I've created a database we use here in a small company. We have a master database which holds tables storing the information. Each employee then has a "user" database, each of these users has the same forms, reports, queries, linked tables and modules...

Hello All Firstly I'm using Access 2013 DESKTOP version for this database. I've created a database that everyone in our company uses. I need to be able to run some sales reports including a breakdown of sales for the month by business area, this needs to display in the form of a pie chart...

Hello all .... blimey I've nearly done it, I've nearly created a database that will help everyone work together. What a steep learning curve. However this morning I've discovered a hitch! Bother! I've based it on the Northwind example but have completely redesigned to fit with our needs here...

Thanks guys for your help, I ended up using an IIF statement but had to convert the field to text as it could only deal with either all text or all currency. IIF statement I used was - Direct Price: IIF([Control1]="0","P.O.A.",[Control1] could also have used IIF([Control1] Is Null...

Should say that the field has been set to currency.

Hi Guys I've been put in charge of creating a database specific to our company which has been brilliant and a very steep learning curve!! But a brilliant challenge!! We've just added in our product list from which I run a report to print off a price list for our customers. I have one slight...

That's brilliant, thanks for your help.

Hi I'm in the middle of creating a new database that will assist in the running of our company. I have a form for adding new products, one of my fields is a concatenate of 2 other fields within the same form this works brilliantly picking up the invoice description from a product name field and...

Hi I'm creating a new database to cover the sales side of our business, similar to the Northwind idea. But I don't want everyone to have access to all the forms and tables, only the ones relevant to their job. Is it possible to secure a database so that on opening each person logs in using a...