Search results

Hi there, thanks for the reply. I fully understand that mysqli is for mysql only I was merely telling you what I'm using now. I however want to connect either to Acess tables or to Pervasive - I've Googled the topic a lot before coming here, so I would have liked a solution more than telling me...

Hi all, I'm using the following connection string to connect to the "P000Lap" Pervasive database from within Access tdfLinked.Connect = "ODBC;DSN=P000Lap;DBQ=P000Lap" However I would like to connect to it from PhP. At the moment I'm connecting to a MySQL database from PhP but would also like...

Thanks - So Python seems to be a good call and from what I hear not to difficult get the basics Cheers

Hi guys, My goal this year is to learn a new language, but a more "modern" one that would be in demand for a possible career. VBA tend to be seen as "old school" compared to the new web focused languages. Someone suggested Python as a good option but I want to know from my fellow VBA Developers...

Thanks - Maybe someone will still post some sample code but so far I created the link "manually" as described and then when to look at the Win Reg and created a similar entry in code then deleted the entry and the ODBC link in the MySQL Driver and then ran my code and it created the link very...

Hi there, Thanks for the ref but Google is also my friend - haha. So far I could easily get the samples of the connections strings I'm suppose to use but I can't seem to find code that will simply show me how to create the link. At the moment I'm looking at writing code to inter the whole thing...

Hi all, I've been starting to move my tables over to MySQL and everything is working fine so far. The only question I have is around the steps I follow: 1. I installed the MySQL ODBC drives 2. Then I use the above ODBC to create the connection the the MySQL db 3. Then from within Access I link...

All good - Coding will do that to you :) I'm off to bed now

Thanks for the above - is there no way to combine it in a single update query? Else it will have to do and in anyway much better than what I had :)

Thanks for the speedy reply. Field is [ID] not [ID Num] sorry seems like I put the Data type to close to the field name. Even when changing that I get the following error: The SELECT steement included a reserved word or an argument name that is misspelled or misisng or the puntuation is...

Hi there, sorry I thought I was clear enough. I have a table with multiple 'SinceDate' for each 'ID' row So I need to flag the Max 'SinceDate' for each 'ID' I attached a database file where I do that using no less than 3 queries and one temp table - madness :) PS: Hold down shift on open

Hi all, I've seen the answer to my question on a few places but just can't seem to implement it on mine. Maybe I'm missing something when changing their fields to mine, so I'll give my table and field names if someone can help please Table: Career Fields: CareerID AutoNum and PK ID...

I don't want to go the accdb route due to the menus/ribbon. 2007 is the last version with the original "2003-look" menus. But I might be forced to do that and create custom menus which will be a lot of work. Will decide. Hope for a RT solution...

Hi all, I have numinous Clients running my Access (mdb format) for many years. However I'm now battling with a Client running Office 365 64 bit. The Access 2007 Run-time I normally ship with my app works fine but as soon as the Client re-boot I have to either re-install 2007 RT or run a "repair"...

Have a look at the solution above

Nope - :( But at least I have a working solution

Great advice but not without hiccups: My system is also 32 so my msg.exe file is in the same place but inspite of providing the full path: Shell "C:\Windows\System32\msg.exe * test" I once again got file not found So I copied the file to root and tried Shell "C:\msg.exe * test" And it...

Personally I like your idea more as it is one box to close. I might give them both options (with a tickbox in the Global Settings to choose between the 2). The Access thing is still a mystery - might be a setting inside Access Options which is different.

Yes that is what the Client wants. This is Birthday reminders so it might be 1 or 2 messages per week - so VERY low traffic. But they want to see it like that instead of having to go into or log into any system. At the same time the messages are triggered a separate SMS is also going to the...

On my side it works in the Cmd window yes but not inside Access in any way. I still find this strange. No words at this moment...see screenshot in case you spot something