Search results

thanks, i'll take a look - nothing else i searched for seemed to return me anything useful. mark

I want to add some security to my database, with three users:- (1) Full access with read/write/update/delete access with the ability to modify designs, queries, relationships etc. etc. (2) Normal Access - able to use forms to read/write/edit/append/update data in tables as well as run queries...

OK, I've not been able to get this to work, so have opted for a slight;ly less tidy method of having a permanent table with the data-types pre-defined and using a delete query to remove any data before using an append query to re-populate the table ready for the 'Delivered Amount' and 'Ordered...

The table is being created by the query: SELECT Order.[Order Number], Order.[Contract Number], Order.[Company Name], Order.[Contact Name], Order.[Date Required], Order.[Net Amount], "£0.00" AS [Delivered Amount], "£0.00" AS [Invoiced Amount] INTO [Print All Orders] FROM [Order]; I have...

How do I set an empty field as curreny with 2 decimal places within a make table or update query. This is the query I have at the moment: SELECT Order.[Order Number], Order.[Contract Number], Order.[Company Name], Order.[Contact Name], Order.[Date Required], Order.[Net Amount], "" AS...

I am currently developing a database to record a number of orders, delivery tickets and invoices which come into a company. To perform calculations etc. tables are deleted, appended and primery key violations occur etc. This is exactly what I want to happen as it ensures all dtaa remains...