Search results

Very Confused!!! I'm new to a lot of this and just "feeling around in the dark" making changes to an access template! I've attached a copy of my (access 2003) database - (some information removed for confidentiality purposes) - can someone take a look and point me to where i'm going wrong...

Hi Folks, I'm working on an order management database for a small company and have an order details form which I hoped to list each product of the order. As each customer has a different price per product I have a combo (based on a query) to choose the product and display the unit price...

I am making a database for a small company who charge different amounts for their products depending on the customer - I'd like the products to be choosen from a list and that particular customers unit price to automatically appear! Currently I have a Customers table, a products table, a price...

Hi Folks, Trying to set an input mask to Capitalize the first letter of a surname but also to do this for ie MacDonald or O'Brian? How can i do this?? Thanks, Mary

Hi Everyone, I am creating a customer order database and have a table for customers with a billing address and one for orders with a delivery address. Most orders go to the billing address, however, the odd order may go else where so I would like to set the default delivery address for each...

Hi All, I've put an input mask into a table and would like to personalise the error message to give the user more information about how they should be entering the data correctly. I don't know where to start with this - can someone point me in the right direction?? Many Thanks, Mary

This should do the trick ... Firstly you need a field which is common to both tables ie businessref then you need to create a one to many relationship between the business and orders tables.

Hi All, I've put an input mask into a table and would like to personalise the error message to give the user more information about how they should be entering the data correctly. I don't know where to start with this - can someone point me in the right direction?? Many Thanks, Mary

Hi Folks, I'm looking to create an autonumber field which will work normally (ie increase 1 number at a time) but at the beginning of a new year I'd like it to automatically return to the number 1 again and start increasing 1 at a time again. Any help on this would be appreciated! Many...

Hi folks, I'm sure this is pretty simple to do but I'm stuck - please help if you can! I have a table with a date field and once the date is entered I would like it to automatically generate a reference number in the Ref No field which is the date as a number in reverse order ie 16th August...