Search results

So if everything works 100 and 10% when then db is is open using the shift button. Then I mean EVERYTHING is working 100 and 10%. The issue here is why is it not working consistently when I don't hold down shift. Am I not clear enough. I even added a loop to requery the listbox 100 times or a...

Oh my word. Can we stop arguing about side-issues. When I open the db using the shift button everything works 100% but not if I open it wiout the shift button like the User would do it. If you read that in my OP then you would not have asked about the code not being run...so let's just try and...

No, no - as I said everything works perfectly when I have the db "open normally"

Hi all, I searched for posts on the above topic but could not find an answer specific to my issue. I use currentdb.execute to insert a value into a listbox and then update the listbox using me.notelist.rowsource = me.notelist.rowsource Me.NoteList.Requery If IsNull(Me.CurNote) = True Then...

Thanks ArnelGP provided enough for me to go on

Thanks that helped a bit. Gosh this code is confusing - very little notes.

Hi all, I'm working on a app created by an unknow developer. In the one form (unbound) there is a list box being populted from the sub below. But I can't seem to find the table or query it is refering to. I would appreciate some advice on where to look for it. Do I need to post extra info...

Hi gsrajan - did you come right with your project?

I would also vote for VScode

=> VS Code (for anything) - I agree => Visual Studio (for .NET) - I agree => Dreamweaver (for anything) - Not using it => Eclipse (for anything)) - Not using it => PHP Storm (for PHP) - I like Notepad++ => PY Charm (for Python) - Yes => Notepad (rarely)

No problem. I've totally thinking out the box. So I've created an almost emply shell Access db whos sole function it is to on open: 1. Link to the Pervasive DB 2. Export the tables to MySQL 3. Open the Website where all the magic happens (well the FPDF report are generated) 4. Close (All without...

Heehee - I agree - Yes I'm running P10 on my machine. Not sure if the version (11 & 12) will be diffrent but you have to pay for them - and just to test - not so sure. Surely the connection side should have been sorted in version 10 and only cometic changes done later on....who knows. Seems like...

Still but how do I get the data in (or connect to it) hosted in the Pervasive db?

https://social.msdn.microsoft.com/Forums/office/en-US/7d92d874-e248-4e1c-82b9-2b88f568f8d4/how-to-run-access-program-with-vba-in-a-web-browser Very intresting indeed! The only reason I'm looking at Access is to open it (in the background) and all it does is run code to export the tables to...

Haha - I agree but the Access is my idea as a Workaround. This is the background: In the Client's country there is a major Payroll Service provider who is using Pervasive SQL as a backend. This Client wants me to develop a frontend (I want to make it a web interface) that connects to the...

YEAH, but what does it say under the two columns? there's 2 columns, isn't there? See attached - does that help?

What I'm going to do now as a workaround is link the Pervasive tables to Access and then "on open" I run code to export the tables to mysql and then I use PHP to connect "normally". The downside is that the data will not be live. But for this Client I have to create a "report writer" which...

I think I have because when I run phpinfo I can see ODBC under the PDO tab (along with mysql etc)

Thanks for the replies. I'll spend some like looking at this link: https://boraqavysuwa.cf/1562.php You suggested.

Thanks - I tried option 3 - and I must say I tried a lot of similar ones but it keeps failing with "Could not find database file." Not sure where I'm going wrong. <?php $dbName = "C:\Users\Private\Desktop\PSQL2MySQL.mdb"; if (!file_exists($dbName)) { die("Could not find database...