Search results

Hi. I hope this is a quick one! I've made a split database for the company I work for. We have started using it and I decided to make some changes in order to streamline the forms, so did so on a local copy of the front end, with my data tables coming from a copy of the tables as linked data...

Ah, yes of course, I can put the text box in the parent form and set the control source to the code above. It doesn't need to be in the footer of the subform. It works!

Hi. Apologies if my lack of experience is making this a more painful experience than it should be! ProductID is a foreign key within tblInventory. This code appears to work: =DCount("*","[tblInventory]","[ProductID] =" & Nz([ProductID],0)) (although only if the Allow Additions property of...

Thank you. I hear you regarding the not even getting a null.

Thank you :)

Thank you. I really don't want to sound obtuse, but I can't get this to work quite as I'd like. If I understand this at all, I think this section should work on its own: Dim i As Long Dim rs As DAO.Recordset Set rs = Me.RecordsetClone With rs If Not (.BOF And...

Thank you for the reply. It's not working on mine. I get the inventory count on the main form if the count is not zero. If I go directly to a product with no inventory, the text box is empty. If I go to a product with no stock from a product with stock, the text box retains the value from...

Hello and thank you. This works insofar as it gives a count of the records in the subform if there are records. But it doesn't seem to return a value when n = 0 (or null, or something other than null, as described above!).

Hi, Thanks once again for your input. I partially understand this, I think. the source table is called tblInventory. I'd like to count all the inventory entries with a given product ID, but I'm not sure how to write this in code. I've tried: = DCount("*", "[tblInventory]", "[InventoryID] ="...

@theDBguy apologies, didn't read your response carefully enough. I'm using a text box with the control source =count("[InventoryID]"). As I said, this works where there are entries in the subform, but not where there are none. If there were a simple way of testing for the subform being empty...

I'm not exactly sure how to use the Nz funciton. I'm trying to use it on a text box within the subform footer using something like: =Nz([txtRecordCount], 0) I thought this should return the value in the box txtRecordCount, or zero if that control is null. The correct value is returned if...

Hi. Thanks both for taking time to answer my query - I very much appreciate it. @gemma-the-husky - your suggestion works on my subform but I don't really want the user to be able to add items directly or the new record line to show, so I might try to use Nz and see how that goes. Pete

Hi all, Hope this is a quickie. I have a subform that may contain quantities of stock, or no records. I need to take an average value from this subform. I'd like to return a count of the number of lines in the subform because if there are no records, I can't obtain an average. Doing a count...

Brilliant, thanks Minty. 10 points to Ravenclaw! ;)

Hello everyone. A quick one, I hope. I have a calculation in a form that should give me the discount percentage of an item calculated from list price and arbitrary "one-off" price input by the user. The control the value is to be displayed in is a "general number", set to 2 decimal places...

It is not under another popup. It's not giving me an error, I just can't see the popup. I tested it with the debugger, with didn't show any issues, then removed the debugger whereupon the programme crashed and now it works! The wonders of Access....

Thanks GTH. No the issue is the popup not opening, or at least appearing to open if set to popup but not modal. I have plenty of popups in my DB and this seems to be an aspect of Access which I have had some issues with. My frustration is that a similar search works, but this particular popup...

If the search result form is set to popup "yes" but modal "no", it doesn't open, or at least if it does open I can't see it. If it's set to popup "yes" and modal "yes" then it opens, but as you say, I can't click anywhere else (I did know about this being a property of modal, I was merely...

Hello! I wonder if anyone can answer the following: I've got a search facility on my Welcome screen. I wish the search term entered by the user to trigger the opening of a popup form, which contains a listbox of results; the user can click on the required result, shutting down the popup form...

Thank you! This seems to work. I hadn't noticed the Move Data function within Database Tools (most references to SP lists I've seen so far only mention export of a single table). As there are only 2 users currently, but both require use of the whole database, I don't think I can have two...