Search results

Can I show a Subform in datasheet view when master form is in datasheet view. It works ok whwn master form is in singlesheet. keith hawes

Is it possible to show a subform in datasheet view when the master form is in datasheet view. It works if Master form is in singlesheet view.

Thanks Neil I have found the buddy tab and have added you. Not sure how it works yet but the next time I have a problem I will try contacting you through the site. Regards Keith Hawes

Hi Neil What can I say "BRILLIANT" It seems with you I get what I want and need. I have been quite a few hours over the last few days trying to solve these problems. Does this site have a buddie type listing (Ive only just joined). If it does I would like to add you to mine (if you have no...

Hi Neil Thank you for your prompt reply. I did not know what a left join was as I am fairly new to access. I have since looked it up and it works great. I now have one further problem to solve. I have used an expression to take the “out stock” from the “in stock” and it works fine until there is...

Query Fixed Hi Neil Thank you for your prompt reply. I did not know what a left join was as I am fairly new to access. I have since looked it up and it works great. I now have one further problem to solve. I have used an expression to take the “out stock” from the “in stock” and it works fine...

Query does not return all stock. In basic form the database has 3 tables. One is “stock” another is “stock in” and the third is “stock out”. I want to run a query using all three tables so that I can take stock out away from stock in. The problem is the column stock in (in the query result)...