Recent content by stressedbrian

Hello folks, I have created a new form and within this I have created a drop down combo box from a small table (sep to the main table). First it was updating the main table with the i.d number of the small table field rather than the field in the combo box, I sorted this by making the combo...

Hello there, I have created a report to produce labels (21 on an A4 sheet) for customers orders ready for delivery. Some customers have more than one product boxed seperately for delivery and if this is the case I want multiple labels for them. What I want to do is that if a certain field...

The control Source reads: =DateAdd("d",33,[StartDate]) for some reason think it is now working am I correct in saying this should add 31 days (4 weeks 3 days) onto my start date?

So am I correct in saying then that I can't have use the dateadd function in a field in a table if the source field for the dateadd is blank or can I just not use it generally in atable?? I have tried using a report instead but the expression still doesn't work when put in the control source...

Hi thanks for that, is there any way of making it a bit more simple than that for example; I have read a few articles on the DateAdd function I have tried using this as the line in the Defaultvalue in the properties of my new field with the different date but its not working says 'TypeMismatch'...

Hi there, I have a table of customers and dates when their orders were placed. Is their a way of having a field within said table that shows the order date plus 3 weeks (ie when the order is due for delivery). It would be good if this can be done automatically as soon as the first date is...

Hello there, I am needing some help with barcodes and our access database 2003. We are a small company and process approx 15000 orders a year to individual companies. When an order is ready a mailing lable is printed and it is updated as complete on the database. Using a customers name or...