Recent content by alvinmcg

I want to create a report to display the results of two similar but different queries. We have an application to track permits. I have a report that lists all applications. When a CO is issued for a structure, that triggers a new process for closure. I could simply create the two separate...

if recordstatus("Modified") then dmPut("projects","updated",today()) endif This code has been added to the depart event for each of the eight pages to this form. I just tested the form again by adding information to several of these child tables and none of them resulted in updating the...

I have added the code to each page of my multipage form hoping that any change which may be made on that page would automatically force the update. This works great but only on the page which includes information to the master record. Updating any of the child tables does not cause an update...

OK, I have confirmed my settings were set to beginner and changed it to advanced. However, and I know this is basic, how do I attach the code to the "depart event for the record of the master and any detail tables." Do I attach the code to the Form, Page, Notebook, Notepage or one of the many...

Thank you for your suggestion. Can you explain "the depart event for the record of the master and any detail tables"? I do not see a "depart" event when looking in "Object Explorer." I added your code to the "canDepart" event on the Notebook. I did substitute the name of the table in the...

I need to automatically add the current date to a record if the record is updated. I have seen some terrific wizardry in this forum but nothing I have tried has worked. Specifically, I have added a date field "updated" to my table. If the record is changed in any way, I want the current date...

I am beginning to convert a database which was created in Paradox. However, in importing the paradox tables, some give me an error which says: "Index or Primary Key can not contain a null value." I have looked at the original paradox table and none of the records have a "null" value in the...

I prefer to work on my PC with a greater number of pixels displayed. However, the balance of my coworkers work in the 800x600 world. The forms I generate in 1024x768 appear too large on the 800x600 screens. Is there a way to automatically adjust the form to fit the users screen settings? Alvin

I ended up doing as suggested... Delete ALL *.VAL and *.X* and *.Y* files and then recreating the validity checks, and referential integrity. The problem is gone and I am thrilled.

I have run into a serious problem and our IT folks (who do not like Paradox) have been unable to find a solution. I have an "application" that includes 27 tables. Last week, there appears to have been some sort of network problem and now the master table VAL file has been corrupted. However...

Yes, I believe I do. However, currently the tables are unavailable as the VAL files have been corrupted. Our IT department is restoring same from a backup. The lookup field is an inspector's name. Each project has only one assigned inspector. Could this referential integrity cause the type...

I am having a problem with my current project. This is in Paradox 8 and in use on a network. I have several lookup tables for key fields. One in particular appears to be causing a lock on the master records and we get the following error: This record in LOOKUP TABLE.DB is already locked by...

I am not certain I understand. I have a tabbed form which includes many fields from a variety of linked tables. However, none of these includes a MRO for that specific table. However, this table is the master table upon which all other tables are related. I appreciate any advice. Please let...

In a tabbed form, it has been suggested that a table view such as is discussed above, would be useful to view projects. I can not get this to work as described. I add a table view to a tabbed page. However, when I attampt to "define table", the desired table is not available. I can...

Thank you Bystander. I tried your fix but got an error message when checking the syntex. ERROR: UNKNOWN METHOD NAME We are using Version 8, if that helps. ********************* Var Web string EndVar Web = self.value Startwebbrowser(Web) ********************* Thank you for your advice. Alvin