Search results

I have a simple ordering database set up with product codes and their descriptions, etc. in one table (and the 'product code' field as the primary key) and then a separate table for the orders raised. When a product becomes obsolete, I would like to be able to prevent anyone from raising a new...

Hi, I have a data entry form that, when completed, I need to send as a report via automatic email. I have created a report that pulls the relevant information and I know I can use 'Send Object' in the 'Before Update' event to send it. However, I need to change the 'To' email address based on...

Hi, I'm currently creating a database for product orders (for us to use to place an order to buy something from a supplier). As part of this, there is a data entry form for the shift supervisor to complete to create an order. However, we have a situation where one shift leader may not...

Hi, I have created a data entry form and one of the things I would like to do is to have an Excel file open automatically if the value in one of the data entry form fields is above a certain criteria (this will then trigger the data entry person that they need to complete another file, which...

Hi, I am very new to Access and am struggling as to whether the following is possible: We have a situation where we need to enter a range of pallet numbers into a form, but then have the table behind the form store the numbers in the range individually. For example, the data entry may be...