Recent content by Robbyp2001

Wow 'The_Doc_Man'. What a response! Many thanks Rob

Hello folks I wonder if anyone can advise me as to how to address the following problem: On a form I have to input a [StartDate] and an [EndDate] The underlying query then calculates the total number of days between these dates [DaysWorked]. This works so far. What I would like to do next...

Thank you so much Ridders. This works! A bit cheeky, I know, but do you have any idea how to make the combo box invisible by default but appear when 'clothing' is selected? If it's a difficult task, just ignore this. What you have given me is great. Rob

Good Morning Foks I have a form [MainForm] and a continuous subform [subForm1]. The subform is based on a table [Ordertbl], which contains a payment method field [Paymeth]. The payment method defaults to (1)"Cash" every time a new record is created by selecting one of the 'classification1'...

Many thanks for your insight Plog. I'll certainly look into your recommendations, however, with the exception of the possible future problem, the system is working very well. Perhaps more problems will become evident in the future though, so it's definitely worth looking at restructuring...

The Stock Table is [ItemClassLevel3ID]

Please see attached

Hello folks I would be grateful for any suggestions to solve the below problem. It's a fairly straightforward problem, but incredibly difficult to explain straightforwardly. I will try though. As part of a stock control database, there is a facility for parents to purchase school uniforms and...

Arnel, once again you have come to the rescue. Many thanks Rob

This problem has got me scratching my head. I would like the report to simply print without opening and I have a button on a form that orders 2 copies of a report to be printed. The report is an invoice for items purchased. Everything works well except that when I click the button, the...

That's it! Well done Arnel. Many thanks.

Unfortunately, this sets the [total] to null and I'm still locked into the record on the form.

Both versions seem to work well. The [total] is updated successfully and the [NewStock] goes blank. Strangely though, I cannot move to another record (it is a continuous form) to repeat the process, unless I exit the form and reopen it. Is there a way around this as the user would in all...

Fantastic Arnel. Works perfectly. Thank you so much. There is something that I forgot to mention and that is, once the process has finished and the number in [Total] has changed, the number in the [NewStock] should go blank. As it is the number remains there even after the form is closed...

Good Morning everyone I wonder if anyone will be kind enough to help with this problem. I have a form [AddNewStock] which is based on a table [ItemBalance]. [ItemBalance] holds information on each unique item, includimg [ItemID], [Name] and the numbers in stock [Total]. The form shows...