Search results for query: *

Hi, I have an application that generates an Excel spreadsheet of varying length as a solid body with "Rows to repeat at top" marked as a header for multiple pages. It needs a number of current page and total amount of pages printed. Now, I know about a standard Excel header/footer feature in...

Hi, I need my multy-user application to check certain database's records regularly (and possibly to react to their changing) regardless of whether the user is actively working with the app on his side or not or even if it's hanging in the background buried under other programs on desktop...

Hi, I have two separate forms, each one with a grid. One of them in its AfterRowColChange does issue a Seek() on other's grid's table and makes that one refresh. So that while you choose between records in the active form, another is supposed to auto-update. It actually happens, and I can see...

Hi, In my app, I once needed to make a calling form disappear for the time of child form being active and reappear when that one was killed. So I wrote IF TYPE("ParentForm")="O" ParentForm.Hide ENDIF in the child form's Init, and then a similar one with "show" in its Destroy. And it worked...

Hi, I need to perform a certain operation on all objects that a form contains (and no, SetAll method won't suffice). For this, I created a following method: PROCEDURE recurfunc PARAMETERS targetname as String PRIVATE member as Object && ( the operation itself ) IF...

Hi, I have an application where I need the form to display a grid consisting of fields from several tables AND some additional fields that don't exist in any physical tables and only make sense in this particular form (and, sadly, they *can't* be simulated by calculated fields). The idea is, I...

Hello, I have an application that several people should be able to access at the same time to enter and modify data. After several attempts at buffering in various modes, and not really satisfied with results, I decided to go the longer way. The form used to enter data uses some dummy table in...

Hi, I have a sheet with a button with following script on it: Range("SourceRange").Copy ActiveSheet.Unprotect Range("TargetRange").PasteSpecial (xlPasteValues) ActiveSheet.ProtectI found that half of time the code throws a "1004: PasteSpecial method of Range class failed" error. After some...

Hi, I have an Excel application that uses macros, and it has to be ran on several people's PCs in my company. I used to set Macro Security to "Low" on them all in order for macros to be working, but I feel guilty about that :). So, alternate ways. I used SelfCert.exe to create my own digital...

Hi, I have a workbook that has certain actions programmed for Workbook_Open, Workbook_BeforeClose and Workbook_BeforeSave events. That works okay. But now I copied the whole module into a new workbook where I want similar functionality, but in that one these events don't work. Placing debug...

Hi, I have a form with a button that evokes another form and after that one is closed, must refresh itself. Simply making the code like DO FORM FormName thisform.Refresh doesn't work, or, more precisely, Refresh is called immediately after opening the child form, not after it ends its work. I...

Hi, I have a multi-sheet table with combo boxes that have xxx_Change() subs defined. Sometimes these subs launch by themselves (for example, it may happen during startup when control's contents is being initialized, etc.) when the sheet with a related control isn't the currently selected sheet...

Hi. I'm sorry if this is not a correct place to ask, but I'm really at loss. Here's the situation. There are two computers (A and B) that have to work with the same Excel application. The application has VBA macros that use strings with native regional (Lithuanian, if it matters) letters...

Hi, I have a need for a combo box whose list of possible values is populated dynamically, depending on other controls' values. In the end I chose to do it with RowSourceType=1 and RowSourse as a string (I also tried arrays, but it didn't go well). It looks like this: m_list="" SCAN FOR...

Hi. VFP's normal report structure implies that any group starts with header, where common characteristics are listed, detail band, and a footer, for totals and summaries. Where I live, though, accountants favor the different layout, where totals go first: TOTAL: SUM(xyz) of them, X...

Hi, I have a sheet with a fragment that looks like this: A: B: line1: +--BIG--+ cellB1 line2: | MERGED| cellB2 line3: +--Cell-+ cellB3 line4: =sum(B1:B3) Now, if I *manually* select the whole line 3, copy it, and then do "Insert Copied Cells" on the same...

Hi, I'm trying to debug a form, and the code that needs attention is called from grid's AfterRowColChange event handler. When I put a breakpoint there, though, it doesn't let me see the action I'm trying to monitor. Once the grid gets the focus, AfterRowColChange breakpoint immediately happens...

Hi, In my app, I have to print certain reports on standard forms. Some fields on those forms don't fit in a single line, so they have to be divided. The problem is that when I spread the field in report to occupy several lines, they don't fit into prefabricated blanks, making the report look...

Hi, I have a function that must fill an array that is passed to it with values. Online help states that , from which I concluded that using arrays as parameters is possible. So I have the following code: Dim ChildRow(30) As Integer Call ChildArray(RowForm, ChildRow()) ... Public Sub...

Hi, I've got a task involving printing on various cards that don't have much to do with few paper sizes taken from US standards that VFP's Print Setup dialog offers in its Size list. Is there a way to set report's size manually in mm?