Recent content by dallnsn

Hi MagicMan, The data source of the subform is based on a query, described below SELECT DISTINCTROW Description, NbrRequested - NbrDispatched AS Due, NbrDispatched AS Dispatch, tblOrderItem.OrderNbr, tblItem.StockHolding FROM tblOrderItem, tblItem, tblCustomer, tblOrder WHERE...

Hi MagicMan, Thanks for the reply. I have changed those details you suggested, The form looks best in data sheet and I have bound the entry to the table, however, I can't enter any figures in there. I have allowed additions, deletions, and yes to data entry, however, the figures are right...

Hi there, The subform contains 3 data items. Description for a title of a book. Once a book has been ordered and there is no stock, that figure goes over to due - how many books are due to the customer. Dispatch is once items are received in stock, how many items are dispatched to the...

Hi Everyone, Please excuse my inability to work with Access, but I am trying. I have a subform in my database that pulls data from an access query. I have 3 fields on the subform, Product Description, Due and Dispatch. Its a order entry subform. The problem is, just say there was 4...

Thankyou, I had just missed out on a simple little & symbol in my programming, and after your help. IT WORKS IT WORKS.. Thankyou RICH

Thanks for your quick reply, but I am still getting the same error. Here is a paste If Me.Dispatch > Me.StockHolding Then strMessage = "Warning: The recorded stock holding of " & Me.Description " is" & & Me.StockHolding strTitle = "Alert"

Hi Everyone, I am having trouble in VBA putting two different derived fields into a string. The coding I am using is calling details from a subform, and I have enclosed what I am trying to do below. strMessage = "Warning: The recorded stock holding of" & Me.Description "is" & Me.StockHolding...

Hi Everyone, I am having trouble in VBA putting two different derived fields into a string. The coding I am using is calling details from a subform, and I have enclosed what I am trying to do below. strMessage = "Warning: The recorded stock holding of" & Me.Description "is" &...

Thanks for the reply. I have a module that will wipe all existing data, and re-populate the tables with data. What I want to know, is how do I use the On click event to call the Reset Data Module, run it from the command button placed on my form. If that makes any sense.

Hi Everyone, I have a small problem, I have to design an access application using VBA. All tables have been given to me, and a module that once clicked, will reset all table data back to its original state as a means of testing. My rather simple question is in VBA how do I utilise this...