Recent content by DjangMan

Just in case you didn't, have you tried putting the sub-report in the Report Footer vs a Group Footer? I'm assuming that the headers have been configured to print/repeat on all pages. One work around might be to put a global variable in the report header something like...

Good lord - yeah - I joined back in 2001.

If I recall correctly, by default, Admin cannot login without special permissions. I'd recommend heading to the Sage City forums. Looking at the last 10 questions posted - I think you're the most active user on this forum. :)

Typically we say that you clear out pending all records relating to that purchase order and then never use that purchase order again. Create a new PO if you still have more to receive on it. The PO tables are complicated and a mess to figure out. Googling "accpac POLINEZ error" will show you at...

Nice!

Blob fields are encrypted in the sense that the binary data of the file has been converted into a text equivalent. You'll have to write a utility to query the database and then process the contents of the field. BLOB fields don't work the same way as other SQL fields as you can't just get their...

It's hard to follow what you're trying to do but I suspect that you're trying to run a multi-step series of queries in one database call. Break down the calls into multiple steps. Your temp table will remain in place until you're ready to get rid of it. When you're running some SQL that...

Or maybe Luca got their program finished. ;)

Note that it won't do the window caption - they're doing some weird stuff there. The other thing to consider is to do your customization using Extender.

Dim modernizer As AccpacContainerObject Set modernizer = New AccpacContainerObject modernizer.ModernizeVBForm Me Sometimes you have to fiddle with a control's Load65Modernization property but the above does the bulk of the work.

There is, apparently, a VB6 only version of an expression evaluator that has been discontinued but the page says that you can contact them if you need it. https://www.aivosto.com/eval.html

I do have to say that I appreciate that the OP's question asks about moving a program written on an OS released 23 years ago to an OS released 15 years ago. :)

Is the underlying field a BLOB field? If so, I think those need to be handled differently.

Are you creating a DLL or an ActiveX control? Those types of projects cannot be run by themselves. Another program is expected to load the DLL or ActiveX control and make use of it. So Delphi is saying that you can't run your project. You can, however, tell Delphi to run another executable...

This one was super easy to Google. Dim FSO As FileSystemObject Dim TS As TextStream Dim TempS As String Dim Final As String Set FSO = New FileSystemObject Set TS = FSO.OpenTextFile(YourInputFilenameHere, ForReading) Do Until TS.AtEndOfStream TempS = TS.ReadLine 'use the Replace function...