Search results

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...

Thank you. I haven't tried importing to Sharepoint from Excel, but that's worth a try.

I had a quick test of this by exporting a couple of tables as lists, where Opportunity had a field ContactID (secondary key from Contacts table). If relationships have been deleted from within Access before export, the option to make a Lookup field is not available, apparently. It is possible...

Apologies, but I don't understand this reply. I have relationships within my existing database, for example Organisation > Department > Contact > Opportunity > Quote. If I export from Access to Sharepoint, some, but not all of the tables are being created as lists in SP. Those that are...

Thanks both. SQL server may be possible for us, however in the short term I'd like to see if I can make this work. Regarding the number of records - my current largest table has around 1100 records. It's a customer/quotation type database and is unlikely to reach 20k for one table in the near...

Thanks for the quick reply and the link. I assume the relationships are reestablished within Access?

Thanks both for your replies. Minty - I will take a look through those related threads. Nautical Gent - as I'm just starting down this route I'm not sure what other issues I'm going to encounter. However, it is troubling me that I'm duplicating data within Sharepoint. As far as I can see...

Hello all, I have a split database, the back end of which I'd like to have sitting on Sharepoint, so as to be accessible to two users remotely. I've managed to export Sharepoint lists from my Database but I have hit a snag. Access seems to only create sharepoint lists for a subset of all...

Appreciated. I merely want to use it a means of capturing a snapshot - so the ID fields (for example) would be a foreign key in the destination table.