Search results

Thanks Doc, no I want just 1 record per customer. If he has a specific invoice address, LabelID 7 then I want that one, otherwise just the first email address that the customer has. I guess it's a group by clause that I need.

Hi all, I need some help building a query that I need, but I can't get it to work. I have a customers table and a customers contact details table. Its a one to many relation. CustomerID - FK MediaTypeID - FK (its phone or email) LabelID - FK (its a label, like invoice address or mobile...

With regards to point 1,it's a typo from Micron. It should be Dim dbs as DAO.Database Dim rs as dao.recordset Set dbs = CurrentDb Set rs = db.openrecordset(...)

Ok, no I didn't try it yet, probably performance will be fine. My understanding was that part of the migration involves converting DAO to ADO to connect directly to the server and use the processing power of the server instead of the local frontend. Pulling only results over the network instead...

Thanks a lot for your advices. I guess I could create those queries and then retrieve the values using a recordset, but I guess you do mean pass-through queries right? Otherwise the workload would still be on the Access Frontend.

Hello all, I am in the process of migrating an Access database to a SQL Server backend. I'm pretty new to SQL Server so I'm learning along the way. I need to populate a dashboard with multiple recordcounts from the same table, so I'm looking for an efficient way of doing this. Let's say I...

We also use O365 in our office. The problem started about two days ago for us. Today I performed the normal manual office procedure within any Office application as described earlier and the problem was immediately solved. No need to uninstall anything, just perform a manual update and you're...

This article describes how to configure a TextBox properly to enter time values. https://www.experts-exchange.com/articles/23539/Entering-24-hour-time-with-input-mask-and-full-validation-in-Microsoft-Access.html Not sure if it helps for your specific needs, but interesting anyway

Ahh yes, you're right about that. Daniel Pineault provided a nice and simple workaround here: https://www.devhut.net/2018/04/22/access-using-split-in-a-query/ But I guess the left and instr functions mentioned earlier would be more efficient in this case.

Or use the Split function to return the first part of the result. StrFirstPart = Split("Block_id", "_")(0)

Also, take a look at this article from Daniel Pineault, he explains how to add conditional compilation to the code so you can actually switch between late binding and early binding. https://www.devhut.net/2017/02/16/vba-early-binding-and-late-binding-part-2/

Hi, take a look at Mztools, it's a very usefull plugin focused on the VBE editor.

The search string is a variable, the url is fixed. So it should be: "browser.co.uk/?q=" & Tempstr

Take a look at this thread: https://www.access-programmers.co.uk/forums/showpost.php?p=1487275&postcount=3

My understanding from this long post is that you need a Transaction type structure. Each tardy is registered and counts for +1. Each discipline is registered and counts for -7. That will easily show you what students have reached the threshold of 7, regardless of the day and when they received...

Thanks a lot, will do! Really nice to see how you work with those Maps API's, always impressive Screenshots. Thank you for posting!

Thanks Colin, yes I read that parallel thread as well. So do you use the ActiveX Microsoft WebBrowser control for displaying this static map? Or is this just the image being downloaded and refreshed? I have a form where I display a route on a map. We discussed it earlier when I was confronted...

Hi Colin, that Map is not a static image right? How did you implement the map part in that screenshot? Is it an Internet Explorer window? Thx, Hans

I think it's just a new icon that Microsoft implemented in its Office 365 suite. I also had a recent update and many icons seems to have changed, including the app icons itself. I think this is just the new cleaner house style. Not a bug or issue.

Recently I stumbled upon an improved version of ConcatRelated written by Gustav Brock, see this link: https://www.experts-exchange.com/articles/33612/Join-concat-values-from-one-field-from-a-table-or-query.html Looks quite nice actually.