Search results

hi scottgem i am using the current dsum net stock=nz(DSum("QuauntityOut","IntStockControl","Transtype='issued'"))-(nz(DSum("QuauntityOut","IntStockControl","Transtype='returned'"))) any pointers on where i need to add the criteria clause?

Hi My problem was not with the combox box it was with the actual record as the combo box was a qucik search in the header of the form. as soon as users put the focus on the main form they could scroll the records and it was causing problems. I like your sample - thanks The sample i used...

Hi Could someone help with showing me how to sync a DSUM to a record as i am currently summing all the records instead of the ones i need? Thanks

i did search and could not find the answer - which is why i posted. But thanks for your help 'Searching the forum is a great way to discover and learn the answers to your Access programming questions. Your question has been asked and answered in about a thousand threads'. not sure how a...

answer below The answer to disabling the scrolling of the mouse: Import the module 'modMouseHook' from the attached sample db. Add a copy of the 'MouseHook.dll' to the same folder as your db or to your windows dll library. Add the attached to the form you want to stop the mouse scrolling on...

Can anyone tell me how i disbale mosue wheel scrolling in a form? Thanks

I would like to do an in stock query on the database. I have 109 products, however only 91 have had transactions against them in the transactions table.. I would like the query to report the 91 records stock take and show the rest as zero stock. this table as # ordered, # received, #...

db attached Please find attached sample DB. If you go to frmlperiod. This is where i would like to be able to select from the combo box then lock the record and clear the combo ready for use again. thinking ahead the combox is going to get populated quite quickly and a cascading combox box...

I replaced the DSUM with the following in the 2nd stock control sub form net stock=Sum(IIf([transtype]="issued",[QuauntityOut],0))-(Sum(IIf([transtype]="returned",[QuauntityOut],0))) which does work?? how would i sync the DSUM with the record? All getting a bit advanced now. Although i have...

Hi If you could help that would be great. I have a main form which has two sub forms: Main form has the following calculated fields: 1. Units in stock=[Products Subform].[Form]![UnitsInStock]-[stockcontrolsubform].[form]![netstock] 2. Units on order=[Products Subform].[Form]![UnitsOnOrder]...

Hi I have a combo box to select a record on a form. I would like then record to lock once it is selected via the combox box and the combo box to clear. If a records is slected again from the combo box it will then show the new record and lock it again. The problem is users are sometimes...

Hi If you could help that would be great. I have a main form which has two sub forms: Main form has the following calculated fields: 1. Units in stock=[Products Subform].[Form]![UnitsInStock]-[stockcontrolsubform].[form]![netstock] 2. Units on order=[Products Subform].[Form]![UnitsOnOrder]...

Hi Ihave the following code Private Sub QuauntityOut_Enter() If IsNull(Me![EmployeeID]) Then MsgBox "You must enter an employee and transaction type before you can book stock in or out" Me.EmployeeID.SetFocus End If End Sub I would like to add another control that If IsNull after the...

Thanks it all works now - a neat tool - thanks again for the help. The link master field were empty as the main form was unbound it was just to show the subform in a nicer way. Thanks again for keep replying till i solved the problem!

Hi Its funny because the subform sorts the fields - it is only when it is attached to an unbound form that it looses the sorting? Thanks

Hi I have heard of this alot - basing forms etc on queries but not sure how to do that? Do i just create the query as i would the subform e.g. using the same fields and then let access create the link? Thanks

Hi What i meant was - am i going about it the right way before i spend time working out the IF calcualtion? The IF calc is what i need help with? Sorry for the confusion. Many Thanks

Hi I have a datasheet subform on an unbound form. but the data on the subform will not sort in ascending order. I have used the ORDER BY in the table and form but it still will not do it?? Thanks

Hi If you could help that would be great. I have a main form which has two sub forms: Main form has: Units in stock=[Products Subform].[Form]![UnitsOnHand] Units on order=[Products Subform].[Form]![UnitsOnOrder] 1st Subform - Products Subform has the following hidden controls. Units on...

I have the db alreadys set up so i am going to do what you say, however i would like to add a hidden text box on the sub form. I have added trasn type control, with Stock In, Stock Out. What i would like it to do is work out. (like you said) add up all the stock in, add up all the stock out...