Search results

Hello, I would like a simple search form to return a set of results based on what I enter in a text box on another form. The query underlying the results form has criteria such as: Like "*" & [Forms]![frmSearch].[Form]![txtSearchString] & "*" so that if I enter "fred" in the box...

Thank you, Minty. I think we have an older PC that hasn't yet been updated. I'll check with that and/or roll back my version of Windows, if that is possible.

More confusing behaviour from the database now: This morning I got into work and fired it up to discuss the issue with my boss. In my Contacts form I have a subform with a button alongside each data entry with the following code underlying it: DoCmd.OpenForm "frmOpportunity", , ...

Thank you both for your continued patience. Access is behaving quite strangely for me as I think I have demonstrated - now it's changing between "property not found" and "no current record" and I'm not seeing a pattern of why. Taking the example that Minty gave, if I force the form to open to...

Sorry, to clarify my earlier reply, opening the form DIRECTLY from the panel on the left hand side works without error.

I have a form with a subform in it. The overarching form is for a customer "opportunity", the subform lists the quotes we've made to date. Clicking a button on the subform adjacent to a quote takes me to a detailed overview of that quote. The error flashes up, but the data appear to load...

I've just opened a version of the FE from 16-02-2022. I deleted all the linked tables and re-linked them using the tables that I saved on the same day. Both files are local. I'm getting the error again, exactly as I did initially with the newest version. Going into design view also causes the...

Hi jdraw, Thanks for taking the time to answer. I can't with real data as it's confidential. If I can put together a smaller version of the db with mock data, I will. Pete

Hi Minty, What I mean is that versions in April/early May were working, without showing any error. The errors first appeared while I was making changes to a stable version. When I ran out of ideas on how to sort the issues out I went back to a previous version and that gave an error....and...

Hi Minty, I'll check the office updates now. Yes, I've copied the back end from our remote server to my computer and I'm still getting the same issue when I link to those files.

Thanks for your reply. It's a couple of actions that I do that trigger the error, but the data display ok as far as I can see. I've already done the relinking as you suggest, so pretty sure it's not that. All databases open directly from FE, yes. Pete

Hi The_Doc_Man, Many thanks for your reply. That is exactly what I meant initially, but I've just been in touch with him and it seems that he is also seeing the same behaviour, but less frequently than I do. After a bit of further testing, I can also add that the error can be "no current...

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