Search results

Gentle reminder: "If you feel the urge to do this, I'd suggest leaving the tab style as 'Tabs' when in Design view, and set the Tab style =2 when you open the form. That way, when you are doing your development, the tabs are visible and things are easy to change. They would only disappear at...

AFAIK it can't be done with tab properties. You would have to set the tab style to none, and then roll-your-own buttons down the right hand side. If you feel the urge to do this, I'd suggest leaving the tab style as 'Tabs' when in Design view, and set the Tab style =2 when you open the form...

Before I make a suggestion, are the cribbage results always in the form "Suzie Bloggs 12/5+106"? And does (for example) Suzie Bloggs send in her results independently? Or does the host or team captain send in results for the top, say 5, people? What about location of the game or competition -...

Thanks for letting us know. Arrays are super duper.

No worries. If you do try the array technique, please post any improvements in runtime. I'm a total array fan, always keen to see if they can improve things.

When you transfer from one test SQL Server to a Prod version, then you (obviously) have to change the connection string. One pitfall when doing so is to use an IP address for the Production connection. In some circumstances, the IP address will need to be looked up in the domain controller...

And please note, I have no idea how to calculate the distance between 2 lat/long pairs, so the calcDist bit is all yours! Also, the array is in order of Lat, so you might not always have to search the whole 3000 restaurants every time. At some point in a search, the Lat of the Restaurant might...

All good, but for this to run fast, you need to utilize an array. Read through the biggest recordset from top to bottom (which is not slow if you are just reading once), and cycle through the in memory array over and over (which is fast) to find the shortest distance. You should be able to shave...

Well, there you go, isla has indeed done exactly that - used a provider that allows you to GET your own message log and parse out the messages. Fabulous, we are cooking with gas. I've started ploughing through that thread Isla, and there is light at the end of the tunnel. Thanks both.

Thanks DB, in fact the 3rd party I'm using doesn't allow you to poll using GET to pick up messages. But it may be the case that there are other SMS providers that do allow you to GET your messages. I'll have a look along those lines - it would be a far easier solution. Jack

Hi, I'm sending and receiving SMS from Access, and it works very well using email-to-SMS conversion provided by a 3rd party. I'm now moving to an environment where creating and reading emails from the vba will not be available. I've tested using a POST to an API (provided by same 3rd party) -...

Sorry Pat, I'm having trouble following your thinking, and I feel that you are using the word 'honest' a little too freely. Your questions are good ones, but we are straying away from Access and I think we should conclude our discussion in the forum. Our website has a contact for further...

;)

To your other points, yes, of course each user gets their own copy of the FE. The point of converting the BE to SQL Server is security. Yes, converting straight to SQL Server can slow an app down, but the apps I have worked with (quite a few!) have rarely suffered this way - I think...

If the customer's path to the cloud drops momentarily (one customer is in remote central Australia, and this happens frequently), then the Access app isn't aware of it. The cloud connection is resumed, or worst case the customer logs in again, and the app appears to them exactly as it was when...

At no time did I say or imply that we convert Access to a web app. I'm not trying to hide the fact that we develop in Access - we are proud of it. The app is in the cloud, it's an Access application which we take from the client, or build for the client, and implement in the cloud on a virtual...

We use the existing Access FE or build one for the client. If existing, we bypass any relinking routines in the startup, and use our own.

All that said, if we are not describing our offering correctly, then your comments are appreciated and we'll be taking them onboard - we don't pretend to have a monopoly on clarity, but we try. Jack

Well, I don't agree that it's misleading, because we take the Access app, and implement it in the cloud. That's what we do. The app is in the cloud. The data is in the cloud. You get a login and password and bob's your uncle. You have 25 users, then you get 25 logins. I guess it does gloss...

FYI, we (and presumably other people) can take your Access app and implement in the cloud with little change (we introduce a startup form). You can continue developing and pass code to us for release (we have Access team developer version management inhouse), see www.bluebridge.com.au. As others...