Search results for query: *

Chriss you are correct that the model.xlsx is blank in my example code (I cannot attach an .xlsx file). The real spreadsheet has data in it that I want to copy to the second spreadsheet. Because I made Excel visible, I see that the range in the model gets selected and copied (dotted line...

...PRIVATE poExcel,poModel,poWorkBook,pnRow poExcel = CREATEOBJECT("Excel.Application") poExcel.Visible = .T. poModel = .NULL. poWorkBook = .NULL. * lcModel = 'd:\model.xlsx' IF FILE(lcModel) poModel = poExcel.Workbooks.Open(lcModel) ELSE poModel= poExcel.Workbooks.Add()...

Visual ProMatrix (VPME) is no longer around. It was a great framework that scaled well to a SQL backend. Mark

I agree with all you say regarding the split date in the database. Fortunately, the month is derived from a pulldown on a form. Your comment regarding the index makes sense and I do have more code in the where clause that will limit the number of records I am processing that will be Rushmore...

I have a table emphours which has two fields, month and year. The month is stored as "January", "February"... The year is stored as a 4 digit numerical value. I want to use the two fields and make a date from them so I can use it in a where clause of a query similar to below. where...

Century rollover docu

Combo your solution worked like a champ. I did not try the other ones but conceptually they should work also. Thanks everyone... Happy New Year!

I am trying to count the number of rows in a different sheet containing a value. In sheet 2 I have sales dates in column "A". In sheet 1 I want to count the number of sales for 2024. So I wanted to use YEAR() around the range which does not seem to work. I then tried using the range containg...

Has anyone gotten around the QuickBooks 64 bit versions (2022+) and their 64 bit SDK's (QBFC15_)? Desktop versions of Quickbooks versions 2022+ are now 64 bit. Their SDK's since QBFC15 are also 64 bit. This is explained in the following post in more detail...

In the date field you can intercept the key that has been pressed in the keypress event. For instance you can check for a "T" or a "t" being pressed and set the value to DATE(). Similarly, you can catch the keypress and if the "+" or "-" keys are pressed you can add or subtract a day from the...

I currently have 4 POTS lines hooked to a Dialogic 4 port modem. The setup is used for employees to clock in/out. Software running on a PC answers the call and prompts the caller for their employee number, etc. The POTS lines are supplied by the Cable company (COX) and are getting more...

Thank you Chris and Mike for your suggestions. The name collision was caused by a poor naming convention on my part. The all caps G_ prefixed names are from #DEFINE statements that correspond to columns in a spreadsheet used as input (example shown below). Unfortunately, the spreadsheet...

You hit the nail on the head. That is exactly what was happening. Good catch. Should have realized it was a pre compile directive that was causing the grief. Thanx

...= lnP_Oth_Amt The cursor was created from an actual table as shown below. PROCEDURE CreateCursor LOCAL laGMS, lnIxMax DIMENSION laGMS[1] * SELECT 0 USE GMS NOUPDATE lnIxMax = AFIELDS(laGMS, 'GMS') USE CREATE CURSOR gms FROM ARRAY laGMS RETURN So what or why has the compiler interpreted...

Chriss I used the underlying cursor of the employee table which was filtered to the selected employer as the driving table in a subsequent select used for the report. Originally I was expecting that the filtered cursor could be used. As you and Tamar pointed out the filtered technique will not...

Thanx for the input Tamar and Chriss. I am going to redo my thinking and set the controlsource of the two combobox's to a public variable and use those values to build the report cursor rather than rely on the underlying cursors used for the combobox's themselves. Again, Thanx for the input...

...on the form to create a report. Before displaying the report another cursor for the report is run using the filtered employee cursor. SELECT * FROM FilteredEmployee LEFT JOIN Employer ON EMPLOYER.ID = FilteredEmployee.EmployerID I was expecting that the FilteredEmployee cursor would only...

Skip thanx for your example. There is more to the problem then was presented and if I were getting the data table from a database I think your solution would be the way to go. One sheet containing the data from all investments and one summary page like you illustrated. Sorry for the confusion...

Tried that but EXCEL pops up "There's a problem with this formula...." when I add the greater than sign.

Tried the following wanting the minimum date value from column A but only if the Investment in column B is > 0. 'BP-101' is the sheet name, "A:A" is the "Check Date" column, "B:B" is the "Investment" column. =minfs('BP-101'!A:A,'BP-101'!B:B,0) Couple of problems. Assuming...