Search results for query: *

I have a number of routines whereby I allow a user to generate dynamic queries using a form. It then opens a specific report which displays the query results. When the form opens . . . if r.open(reportName, WinStyleMaximize + WinStyleHScroll + WinStyleVScroll) then create custom menu for...

Is this a multi-user app or single-user app.

Why not use the DataSearch method to specifiy your search criteria, and scroll through the table using DataSearchNext method? pushButton(var eventInfo Event) action(DataDearch) endmethod method pushButton(var eventInfo Event) action(DataSearchNext) endmethod When the find dialog box...

Check out PARADOX 9 Help | ObjectPal Reference "executeQBE example 2" for correct syntex and methodology for querying a foreign database.

The way I would handle this is two-fold: First, create a tableview that displays the matching records. While in design mode, right-click on each field object and select properties. Then select the tab "Run-Time" and make sure that the property tab stop is unchecked. The user will...

I am still getting my bearings with using VBA in Access. However, yesterday I came up with a quick routine that requires counting the number of records returned in a sql stmt. Since it works, you might find it useful in debugging your code: (This routine does not display the results table...

The ObjectPal Reference located in the pull-down menu under Help, is excellently written. It provides you with example code that you can cut and paste into your programs. In my opinion, the best reference book on the market for learning ObjectPal was: Title: Programming Paradox 5 for...

If this is a one-time event, you do not need to combined the two fields using object-pal. You can easily accomplish this by creating a query that will combine the two values, F1 (areaCode) and F2 (oldNumber), and insert same into a new field F3 (newNumber). First, add the third field to your...

This is rather odd. All of my reports converted from 4.5 to 9 without a problem.

Paradox's help refers to the keyboard editor in WordPerfect and Corel Presentations. You can, however, create customized menus using ObjectPal, to include KeyPhysical events (e.g., Ctrl+X for cut). Thanks to OGriofa for the auto-insert date tip.

Perhaps this will stop intermittent problem. Open the affected reports in design mode, and click on Page Setup under the File Menu option. Under page orientation, select Portrait and hit OK. Save report to save setting. The report will automatically default to portrait at run-time, but a...

Create a button on the form. Attach the following code to the push-button event: method pushButton(var eventInfo Event) //#formdata1 is the explicit name of the form. if #formdata1.editing then action(DataLookup) else msgStop("STOP", "Change from...

This code snippet should only be used if database is NOT shared. 1. Add pushbutton to form displaying your table. 2. Replace "ReferenceNo.value" with the name of your keyed field dot value. method pushButton(var eventInfo Event) var newRefNum Number refTbl Table endvar...

I should have mentioned that I also used double, then single quotes around the entire string. It was still rejected.

I am trying to create a string that contains the path of a file. The path sequence is H:\CIG-shared\technology\. . . Access returns error message saying unable to locate H:\CIG. I tried putting a '\' before the -, [] around the -, double and single quotes around the -, to no avail. Any...

Mark Sweetland's suggestion is correct. Write a procedure which assumes excel is already open. Of course, if it isn't, a run-time error occurs. However, the "on error" statement takes care of that. Dim obXLApp As Object Dim obXLWorkbook As Object On Error Resume Next...