Search results

Walk through the code as written and explain to yourself what each step is doing. If you come to the conclusion that it isn't doing anything at all, I suspect you may be correct. Why would you create a clone of a record to edit it? Why not simply edit it directly.

But more importantly do you know and/or have learned what your error was, so you can avoid it in the future? I notice Chatty didn't mention the real cause of your problem, which was the position of your where clause, it simply repositioned it in the sample output.

Your Where clause needs to go before the Group By And I'm pretty sure the Distinct keyword is redundant because you are already grouping. Edit : And Access isn't case sensitive, so no need to UCase() the search terms.

@nector What does setting a local variable called Cancel achieve in the code above? What are you checking for in the If ... Then expression? And why do the lookup again, you already know that it exists if you reach that point in the code I already know the answer, I just wondered if you did.

@GPGeorge I'll have to find an example. I'm sure I've made it work somewhere. Probably be tomorrow as I need to sign off shortly

If you requery the Recordset not the form it will normally stay put where it was. (An often overlooked method) If not simply store the unique ID before opening the edit form, then requery, then use the rs.bookmark and find first method to get you back where you were.

The normal route would be a pop up single form that is opened modally/dialog on top the of the main list, and then returns you to where you where after is opened. I have lots of them but they are are proprietary to the clients app, and difficult to take pictures of without munging a ton of the...

If you return a snapshot recordset of any multi table joined query (of any sizeable recordset) it is always significantly quicker in my experience. It's for this reason (we use Azure hosted SQL Server) we frequently use a "display only" list version of the data then a single record edit form as...

Ah - that's a different kettle of fish altogether... You may need to build something that can replicate that functionality, It is certainly slower on non-access backends, so I suspect when it is an Access data-source it can employ some ninja smoke and mirrors to speed things up. What...

To do find and replace on a sizeable recordset pass the process to the Server, either using a stored procedure or a pass through query, depending on the complexity involved. The difference in speed should be significant. Assuming it a text field, make sure that it is also indexed.

Possibly, although SQL server is a lot more tolerant of somewhat ambiguous joins, and still often allows updating when Access wouldn't, in my experience. To be fair all my tables have a unique key specified, so it's never really an issue.

A SQL View will almost certainly be quicker than joining the tables in access. You can then query the view locally and if you are using an up to date SQL Driver (Version 18 is the latest one and would be recommended) it should work at least as quickly as your old access query did. In addition...

We use a iDrive account. It has a cost associated with it, but is operated as a Scheduled Incremental back up, with recovery possible to any point in time in the history available. It appear to be quick and painless to operate, I have approx. 115GB of files backed up in total. You can also...

I don't think you would be successful with this type of thinking, and very awkward to program. If someone wants 5, 11 or 100 or a 1000 you should have a uniform price structure. The fact you apparently don't want people bulk buying, would tend to indicate you shouldn't be offering any sort of...

The current stock won't be correct for each line if you requery the data, as it's based on the entire record set. You would have to store it at the time of the record being entered, which is pointless, as presumably it's only accurate at that point in time. What is the actual purpose of this -...

This makes absolutely no sense. Why would the average price for three be more average price for two.

There is a huge amount of unnecessary code in that routine, that could all be replaced with Me.CurrentStock = DSum("StockBalance","QrySmartInvoiceResidualBalancePOS","[ProductID] = " & Me.ProductID

Can't you use Nz() to make it a bit more versbose? Nz(BasicSalary,0) + Nz(AdditionalAllowance,0) etc. etc.

Your invoice number is text so you need to escape it with single quotes: =DMax("PmtDate", "InvoicePmt", "InvoiceNo = '" & [Invoice] & "'")

Good luck with that. :eek: Also bear in mind there isn't a Access web version so if you still need to develop Access you need a PC with it installed, or the Runtime for it to run a existing app.