Search results for query: *

I have a spreadsheet that I populate via VFP9. When I am in the spreadsheet sometimes I filter the table and forget to turn the filter off. When I add data via VFP, sometimes the data insertion gets 'misplaced' because of the filter. I know how to turn the filter off programmatically but I am...

Hi all, I am creating a calendar entry via VFP 9.0. I cannot figure out how to set the reminder to none. oObject = oOutlook.CreateItem(1) oObject.ReminderMinutesBeforeStart can only accept integers. Does anyone know of a way to set that property to NONE? Thanks,

Hi all, This is just a fact finding question to see if anyone knows if this is possible. Can MSSql 2016 read VFP Tables. I was asked this question during a job interview. Thanks!

Hi all, this is a shot in the dark. Does anyone use ADS 12 and xBase++. Thanks

Hi All, been out of the coding world for a while now back into it! I have a container with a 7 button command group. The buttons are vertically placed. When I arrow down and get the the 7th button, i want to reposition to the first button when I press the down arrow on the 7th button, but...

I am embarrassed to admit but I do not know what "Variant" means in this statement oExcel.WorkSheets.Add( [Before as Variant], [After as Variant], [Count as Variant].... I want to add a worksheet after the one I already have. Is the Before a logical? or an Excel constant? Thanks!

Hi all, At work we have a critical Billing application (Access 2000) that stopped working in Access 2000. And by stop working I mean ODBC errors where popping up when opening the database. It might have been to mangled ODBC connections that were trying to connect to 3 VFP tables. We repaired...

Hi all, The company I work for is sun-setting Visual Foxpro and all related applications created with it. Now I need to switch them over to Visual Basic. I am looking for recommendations for books that cover syntax of that language in that Visual Studio IDE. 2013 or 2105 . Thanks in advanced.

Hi all! I'm in the early stages of trying to import a financial file that is in XML into VFP9. I am using this code from a prior post to open the xml file and view the data. * Read the XML file into a memory variable lcXML = FILETOSTR(GETFILE()) loXML = CREATEOBJECT("XMLAdapter") *...

Hi all, on a scale of 1 to 100, 100 being a Python expert, I am a 1. I inherited a bunch of Python scripts and now I have to change one. This is the current code. It checks the length of the PropID and if it is 10, then it is a good ID. if len(str(self.propid)) == 10...

Hi all, I have a project that needs to generate a letter for client information. I am using VFP 9 and Word 2013 The letter format is as follows: Date Salutation Body Account Information ( 2-3 lines ) varying between 1 and 30 accounts Closing Signature Graphic Signature block I know the Body...

Hi all, i've based the following code on this previous thread: thread184-1716941 PUBLIC gnConnect gnConnect = SQLCONNECT("AccountOperations") SET MULTILOCKS ON **setup empty cursor ?SQLEXEC( gnConnect, "select * from JML_dbCamsAssets where 1=0", "csr_dbCamsAssets" ) ** get the data for...

Hi all, I've been asked if there is a setting available so that you only have to enter your password once on this screen instead of every time you want to add a digital signature. TIA Josh

SQL 2008R2 I'm very new to this so excuse my lack of knowledge. I'm trying to see when all the table were last updated. I run this. use AccountOperations select object_name([object_id]), last_user_seek, last_user_scan, last_user_lookup, Last_user_update from sys.dm_db_index_usage_stats where...

We have 1 client that cannot get passed our password/decrypt routine. The other 40 clients can. This client is using our VFP9 software on a virtual machine( win 7 ). We are using the FFC\_crypt.vcx class that was loaded with VFP9. Here is a snippet of that code in the _crypt class. Declare...

Hi all I have a 10 tab page-frame and I would like to have 10 separate data-sessions. This is for ease of use because I have so many tables open but each tab does not use them. I just would like to open the tables that are used in each tab so the filters, pointer and relationships do not cross...

Hi all, Sometimes when I have the debugger open with Trace, Watch and Local windows active my code will stop when there is no breakpoint set. I've cleared all breakpoints, I've opened the Breakpoint dialog and made sure there is no breakpoints set at all. I've deleted my foxuser.dbf. I've...

Hi all, The application I am working is has its own system menu not the default VFP one. Question is, when I am in the DEBUGGER tracing code and I click FIX is there anyway to reset the menu back to the VFP default one automatically. Like a trigger or something. I am so focused on fixing...

Hi all! I have a question about MSComCt2.Ocx. I am using the calendar on my main form. I was recently sitting on a form that is 2 levels deep from the main form when all of a sudden my error handler kicks in stating that the SELCHANGE() method fired! The error was Error #3 'file in use'...

Hi all, I have a grid with 8 columns. The left most column is static with LockColumns = 1 and LockColumnsLeft = 1. Because of the size of the form not all columns can be displayed at once. Columns 2-6 are displayed but 7 & 8 are in the scrollable area on the right side of the grid. My...