Search results

My report creates an invoice for account customers. On my invoice i would like it to automatically say when payment is due. Payment is due on the last day of the month in question. So if we are in March it should say payment due 31st March. What criteria expression would i need to implement this...

Thank you for your advice but unfortunately i'm not that amazing at this! Can you please elaborate further on your advice so a dumb ass like me can understand!! Thanks a million for the tips.

I use a combo box to look up stock records on my form. I may have nearly 300 stock records but prehaps only 100 will be in stock. There is a value on these records called 'CurrentStockLevel'. If CurrentStockLevel is 1 or more i would like its record on the combo box to show in a different colour...

I have a combo box that looks up tyre records on my field. So if i select Tyre A from the combo box Tyre A's prices and stock levels come up. However it would be really useful if on selecting the tyre from the combo box it would be in a differnt colour if that tyre was in stock. So for any tyres...

How do i set up a password window to implement this......how do i assign lots of passwords so each user can have there own?? Thanks for any help again!

To change data on my field i would like the person to have to type in a password. EG if they wanted to change the cost price in the 'costprice' field from £10 to £12 they would type in £12 and then have to type the password for it to go through. Is there any way of implementing this? Any tips...

Is it possible to display a message on my field when the user tabs in that they may be about to make changes to the data. I don't want to lock the fields in case data needs editing but i don't want them to actually change stuff by mistake without realising it. I know i can attach a message box...

I have created a subform based on a query that details customer payments, so i have Invoice No-Date-Amount and then if it is Due and then if they have paid. The last two being Yes/No boxes. However on my account page where the subform is i can't tick whether or not they have paid because it...

I want to set up my form simular to how the example Northwind database is set up. In my invoice form i want a subform of products, that i can select from exactely how they do in the northwind one. So if i want several products i can just click to a new line with the new product. If i just have...

In my quote form i have a lookup box that looks up brokers from the broker table. I have also created a field using a combo box that automatically enteres the fax number of the broker on my quote form from selecting the broker in the lookup table. Now i want to create a report that names the...

I have a 'quote form' and a 'new case form'. Before a new case a quote must be done. This quote is given a reference number. If it becomes a new case i select the refernce number from a lookup on my new case form. This then finds the correct record in my quote form. However certain fields i want...

Sometimes certain invoices are for trade customers who recieve a 5% discount off the total price. Is there any way of making this happen using a check box..so when it is not checked the invoice stays the same and when it is selected the 5% discount comes into play? I can manage to get this...

I am creating a stock control system using access for a college project. When i tab out of one of my fields (CostPrice) other fields are automatically updated (SellingPrice and SellingPriceVAT). This is by using a simple formmula in visual basic (eg SellingPrice = 25 / 100 * COst Price etc etc)...