Search results for query: *

Hi all, I've run into a weird issue with an image on a form. In the report form the image looks like this: But when the form is output to either a PDF or a printed file, it looks like this: The globe shaped logo looks TERRIBLE. I've tried making different sizes for the logo, different...

Hi All, I know there was some talk about this a few months back, but can't seem to find it. I've begun to discover the difference between ChatGPT and OpenAI API. Anyway, I have an application that has some contact management built into it that I've been using for yonks. It centers around...

I occasionally get this message popping up (I'm of course using grids on a form which use dynamicbackcolor property to highlight records for this appearance: The appearance is what I expect, so this "error message" doesn't seem to have any impact or issue. Is there some way to suppress this...

Hi All, Ok, I'm having a serious brain seizure moment with COPY TO. No matter what I do, when I send the file to a filename using COPY TO (Such as COPY TO MyFile2024.XLS XL5) the result is myfile2024.xls in the directory the file is written to. Am I missing some switch or setting for this? Is...

Hi All, In VFP there is a "Print when" conditional when outputting to a a printed report. I'm looking for something/some way similar to do this in Excel (Office 365 but as PC application, not browser based). Is this possible? There are some rows I only want to print (to PDF or to printed...

Hi All, Long time without a question, but I'm working on something new... So I have used named ranges to provide for source data in dropdown lists. And I like to do them dynamically, so as I add to list data, it appears without having to redefine fixed ranges. But now I have something a...

I've been trying to figure this issue out for ages (maybe even a couple of years), but I just pegged the cause of the behavior, now I have no idea how (or if) there is a remedy. I'm using multiple monitors. When my running EXE is in the "Default Monitor" the mouse wheel on grids works fine (to...

Having a very stupid moment. I can't seem to figure out what seems obvious. I have a table (CUSTOMER). I have an index on CUSTOMER, so if set the index to CUSTNAME and then say: SEEK "Some Company" If would find "Some Company" if it matches. But if it is actually "The Some Company", it won't...

Hi All, I have a small problem I'm trying to solve with SELECT. I thought I should be able to sum while issuing a select. When I issue the following command: SELECT EXPENSETYPE, EXPENSEPURPOSE, SUM(expenseconvertedto) AS EXPACCUM FROM EXPENSEDETAIL WHERE EXPENSEID = 81 So my intent here is...

Hi all, I just experienced an odd issue. I have an app that I've been running for months, and it works fine on the desktop, but on my laptop, when I run the report, (which prints to a PDF), the PDF is cut off at the right about about 1 inch of the normal visible text. It's very odd. The...

Hi All, A few months ago I created a report for one of my tables (it's expense report, some may remember when I worked through this). It was all working fine, and suddenly I started to get a message when trying to run it saying "expenseid_a is not a field" (paraphrasing, I don't remember the...

I just noticed an odd behavior in my mouse and VFP. I have several grids on a form. When I am working in development mode (i.e. I'm running the app within VFP), the mouse wheel works as expected. (If I am over a grid, and I move the mouse wheel, the grid moves along with it, up and down)...

Hi All, I rarely use the VFP Menu systems, but I do find the POPUP menu capability really useful. I have a POPUP menu that I'm using for things like Copy, Paste, Undo, Redo, etc. One thing I noticed is that the "skip for" allows for "disabling" options. So to that I have two questions: 1) Is...

Hi All, Is it possible to have a image popup when you hover over a cell. The images should be stored on a hidden page in the same workbook (images on a page, and hiding it I can do). But I wanted something like a VLOOKUP to find the image based on a cell in the row and then present the image...

Hi all, I have a Excel sheet that has a bunch of data in columns in it. I am wanting to create a sort of "header interface" that doesn't need the selecting of the filter button on the columns (which I already have there). Instead I want a field that says something like: Pick a type: And next...

Hi All, I'm having some difficulty getting my head around an "experiment" I'm trying to run. (This is just for some idea I have related to a thought experiment I'm working on and thought that I could generate a data set based on it, but I'm stuck on how to actually make it work). The idea is...

Hi All, I'm having a stupid moment. I am trying to implement a slight delay on an event in a ribbon bar button. When the mouse enters the button, there is a "Help Text" window that appears (you can see this in something like Word if you hover on any button, it pops up a little bit of...

Hi all, I've discovered one other annoyance with the new report writer. When I make a call with REPORT FORM <report.frx> PREVIEW or TO PRINTER, I get a series of artifacts on the screen: .T. .NULL. LISTENER.VCX LISTENER.VCX LISTENER.VCX End of locate scope. .F. .T. .T. .T. With forms, and data...

Hi All, Thanks heaps for al the help in getting me going in the report writer. I have everything working in it that I wanted, but there is one more small thing I'm hoping to fix. Our default printer is Acrobat (which we have installed on the machines, so no issues about it, we just set the...

Hi All, I haven't had to use the VFP 9 report writer until now, and the last time I used the report writer was almost 15 years ago with VFP 6 or 7 (don't remember). I see there is a lot that has changed, and it's gained in power and capability. Unfortunately, my VFP 9 docs are in storage in...