Search results

Does anybody know where I can find an ldb viewer for 4.x version databases. I have downloaded a viewer, LDBView.Zip but it does not correctly identify the suspect state of the database in the database header. Any help would be appreciated. Duane

I have created a fairly complicated report which provides Delivery Ratings for a specified period based on very specific criteria. The report doesn't give me the output that I expected. I have examined the code in great detail, and it SHOULD work properly. I have stepped through the code...

How do I remove a filter from a DAO type recordset. I need to use Filter instead of FindFirst, Seek because I need to access the RecordCount property. I tried using: rst.Filter= "" No Luck I also tried rst.Filter = adFilterNone Not sure if that worked either I am using this inside a...

Can you close a recordset in a nested transaction, and still be able to roll it back if the main transaction is rolled back? In order to keep my database consistent when a user makes changes, I need to Undo all previous updates, and then Update with the new information. I capture the old data...

I am writing some transactions involving multiple recordsets and multiple tables. I have begun writing with the BeginTrans method of a Workspace object. I would like to group a number of recordset updates into one transaction, but I don't know how to confirm that all updates succeed before I...

Is there a limit to the number of form modules you can have in a single MDB? My current application has around 50 different form modules. I have been having serious memory problems when trying to write in the Editor. I have checked my system resources, and I have in excess of 40 Meg of...

I have a Search form which I have created that is activated on a form by a command buton. This form allows the User to pick a value from a Combo Box and then this value is used for the filter criteria on the form. This works great, but I would like to be able to re-use this form for all of my...

I have a Search form which I have created that is activated on a form by a command buton. This form allows the User to pick a value from a Combo Box and then this value is used for the filter criteria on the form. This works great, but I would like to be able to re-use this form for all of my...

I have finished the modifications based on the suggestions I was given in the previous message. It works like a charm. Thanks!!! Here is the new problem: The Products table has a Sub-Table linked to it that also has very important information that needs to be verified. Each Product can have...

I've been designing a Production Management system, and one of the important features is that Product specifications changed by data entry persons must be verified before they can be used in the system. The problem is that changes are constantly being made to product specifications. I need to...

I've run into a little problem with my database. Here is a description of the problem: First, I am unable to open my editor window from anywhere in the application except by creating a new module object. If I try to open it any other way, I get application must shut down error. Second, I...

Thank you for the help from my previous post, Bill. I have managed to get the procedure to work properly. I have been busy using this new knowledge to improve the application I have been working on. There is one little thing that I have still been having problems with. First of all, since I...

I need to move to a specific record in a recordset using the primary key of the table, (2 fields)based on values that I have extracted from a form. I have tried to use the SEEK, FIND and FILTER methods on the recordset object, but none of them seem to allow the use of variables. Here is an...