Recent content by nhorton79

Hi All. We track clients through Access (inhouse CRM/job management) and have discussed adding market segmentation to our clients. Our database is actually through linked MySQL tables, not an Access database so just using Access for the forms, queries etc. I imagine it would be easy to sort...

Try putting a : Debug.Print Response.Content inside the GeoCodeFromPlaceID function after the line Set Response = MapsClient.Execute(Request) I just tried this from my home computer and it came up with "This IP, site or mobile application is not authorized to use this API key. Request...

Would need to know. Is it happening on that particular line or just within that function? What are you running his on? Windows? Mac?

Link to my code under Sample Databases: Google Maps API Autocomplete | Access World Forums (access-programmers.co.uk) As I have had plenty of assistance from everyone here over the years. I thought I had better post this for everyone to share. I've been playing around with including an...

As I have had plenty of assistance from everyone here over the years. I thought I had better post this for everyone to share. I've been playing around with including an autocomplete address form, like you see here: Place Autocomplete Address Form | Maps JavaScript API | Google for Developers I...

Don't know whether this is of any interest for everyone in the forums, however, I have found this for hashing and verifying password hashes created using BCrypt. https://github.com/as08/ClassicASP.Bcrypt I was able to register the DLL to a TLB by navigating to...

Sorry if my question was a little vague. Just reread it again. Users usually just use calculator in windows to get the figure to enter but want to find a way for them to just input directly into the field. So trusting their input anyway. I can get it to work by msgbox or printing to immediate...

Hi All, Wanting to have a textbox be able to perform calculations prior to saving. We are often working with square meterage of products in our quantity textbox (txtQty). So would like for users to be able to enter a calculation and have this evaluate prior to updating. e.g. typing in 10*4/10...

Okay. I see what you did there. The tabcontrol doesn't hold the subform, the subform just sits on top and appears to be within the tabcontrol. Genius! And now I also see how to filte rmultiple Master/Child fields too. Now I just need to work on ensuring that the order comboboxes based on the...

Hi DBguy, this is exactly what I was trying to achieve. I've quickly added your population of the txtItemTypeID to the load event of the from which ensure that on first load it shows the correct items. However, I am still trying to determine what else you have done. Is that single line ...

Hi All, I want to be able to have a list of items display on multiple tabs on a form, but each list of items to be filtered to the type of tab. I have created a test form with a tabcontrol on it and managed to get the tab names (captions) defined from the records in a table. I want them...

Thanks MajP! I had been thinking to use the internal methods with the dictionary, but better as your method shows to create my own methods to add, remove etc. I’ve got it working now. I could post final code but took directly from MajP’s examples and just changed a few names for dictionary...

Seems fine working as an Integer...(?)

I’m wanting to use this in a POST request to an API using VBA-Web and VBA-Json. I need to have multiple LineItems to post to XeroAPI. I’d tried using a UDT for the LineItems but vba didn’t like these in the class.

Hi All, I have a class 'LineItem': Option Explicit ' Member variables Private m_LineItemID As String Private m_Description As String Private m_Quantity As Double Private m_UnitAmount As Double Private m_AccountCode As String Private m_TaxType As String ' Properties Property Get...