Search results for query: *

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...

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 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...

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 have a form with a rudimentary link to data on the web. execute( "start http://www.ci.savannah.ga.us/spr/siteplan.nsf/EnterProjectNum?OpenForm" ) This works fine on my machine but does not execute on the others using the form. They get the error message: Error occurred while...

I have a small application and need to run monthly queries/reports on the data. I have created a QBE query and have entered the month beginning and ending dates to collect the data I need for each month. There must be a way to have Paradox ask, when the query is run, for these two dates and...

I would like to add a field to a table/form which includes a link to a website. How/can I set up such a link that will work by simply clicking on the link? Alvin

I have some queries which are based on the prior month. How can I setup my query to ask me to enter data or can this be automated to select the prior calendar month? alvinmcg

I have some reports which are on larger format pages. Each time I want to run the report, I must go into the printer setup and reselect the correct paper tray. Is there a shortcut so this is automatic? Happy Thanksgiving alvinmcg

I am attempting to develop a new "application" in Paradox8. I am creating a query and want/need the contents of a memo field to display in the answer table. When I select the field with a "check" and attempt to run the query, I get an error message which states "Blob...