Search results

Hi, I absolutely agree that these forums are a place for discussion, not advertising. That said, all of a sudden I am on the other side of the fence - my company is now hosting Access/SQL applications in the cloud, yahoo at long last! Folk are posting now and again on that very issue, and I'd...

Sent you some more details in a conversation ....

Nope, remoteapp was not supported well enough when I was developing my solution (in fact I got the impression that it was unworkable), and so I gave it the el dumpo and I use ParallelRAS. Best decision. In short, my VM hosting eliminates the AD, gateway, domain controllers, fees, licensing and...

Well, do you know what I think? I think the product has attributes other than manufacturer and code. And one of them hasn't been completed when you entered the new product, so the query (using INNERs) doesn't pick up the product. Possible? Jack

Hi, yes I'm back! Unfortunately, my info on this subject is rather mixed. First, MS calculators seem to me to be a little pessimistic, but taking a 'suck it and see' approach might turn out expensive if a user is logging in frequently or the data drag is high. Sorry I haven't got any...

Apologies: strWHERE = "1=1" strWHERE = strWHERE & IIf(Len(Me.Criteria1) = 0, "", " AND Field1 = '" & Me.Criteria1 & "'") strWHERE = strWHERE & IIf(Len(Me.Criteria2) = 0, "", " AND Field2 = '" & Me.Criteria2 & "'") Jack

Hiya, So much good advice here, so not sure if this little snippet helps, but one way to remove the mother of all if statements is: Start your filter criteria with something that is always true, so that you don't have to do much parsing. I use "1=1". A typical criteria statement for your filter...

Hiya, " Then they attempt to use the front end on the server side, which is not allowed, though somehow a few have found a way to run it anyway (working on that)." Users, eh, who needs 'em. If you have something like the following in your Autoexec or splash screen, it keeps users from opening...

Hokie dokie, 3 things to check. First, if you have Name Autocorrect on (it's very handy while you are developing), turn it off at this stage. It looks to me like your database was unsuccessfully trying to autocorrect names within your recordsources during the migration. So turn off all the Name...

Hi, I ran a free Azure database for a month, then it was low cost after the free period expired. I'm in Sydney, connected to an Azure database located in the US. Response time was about the same as refreshing a browser page - about 2 seconds. Databases that I've converted in this way run without...

If you are 6-8 individuals using separate computers with no local network connecting them, then you are a company format that I am seeing more and more of. Sorry, 'of which I am seeing more and more'. Where would you put a central SQL server in your case? If you have a shared Dropbox folder so...

Hi, Thanks very much to all. I have worked around the problem by: 1) Use Regasm with the /regfile switch to generate the registry entries 2) sifted through the registry entries to determine how to late bind. That is, skip the tlb and load the object using CreateObject 3) trial and error to find...

No, I made no changes. I noticed it after unregistering the dll, moving the assembly (that is, the dlls and tlb) to a different folder, and re-registering. The assembly was supplied, so not sure how the tlb was built. I've raised the issue with the developer; he can unregister the dll, move...

Hi, Accdb (365) says "MISSING" reference, so I uncheck it, and browse for it, compile, and app works. Close the app, re-open and it says missing again. But the file isn't missing, it's right there! This happens no matter what I do: unregister / reregister DLL, move everything to different...

Woohoo, that is very cool! I can use this for the time being, although I have to ensure xlsx is supported in future, so the search continues. Thanks very much. Jack

Hi, I checked your link, and maybe you're right, it might be the simplest option. I've downloaded the SDK - can you advise how to reference it in VBA? Thanks, Jack

Hi Isaac, Your comment has been very helpful, but I don't know how to implement the .Net solutions that I've found. NPIO and ClosedXml look like the most likely candidates, but their DLLs don't seem available to VBA. The trouble is, I have no VS skills so even if I build the DLL, which I did for...

Thanks DBGuy and all for your attention and suggestions. Jack

LibreOffice. Hmm, that's a new track altogether but I'll have a look at it, thanks arnelgp

Isaac, yep may have to go down that route but I have no .Net skills so trying to avoid it if possible. Mind you, if you were correct about there being a readymade COM dll, I'd be doing it like a shot, but I haven't located one yet. arnelgp, true, exporting it as csv may be my answer, but there...