Search results

Re: Scheduled run of Compact-Repair off hours - more Thanks Bob - do you have other ideas to keep our corruption occurrences to a minimum? We have had two corruptions within a week. Usually it runs about once ever 2 months. The most troubled DB has 20 users, 12 local, 6 at another site and...

There should be a way to run an "auto-marco" as in Excel that does the Compact and Repair that can be put on an XP-Scheduler to run nightly. If anyone has this process working let me know. Thx Russ Russell.Neuman @ LFG.com I will post one if I figure it out.

Re: removing a break point - solved in Jan 2011 I am not sure how to mark items solved in this forum. The solution was = delete the code and re-install the code. Russ

Re: removing a break point - SOLVED - werid solution SpeedGeezer - I did what you said and it worked! "using the following methodology: Remove the offending If is Null(coname....) end if staement completely. Save. Close and reopen. It should work now (without that test obviously). Now put...

I had some break points - I cleared them. But everytime I start the DB the code displays and stops in debug mode. :confused: I cannot get the code debug screen from appearing. Any ideas? Attached is what happens. Thx Russ

Re: selecting Sub-Form data from two inputs - resolved resolved cking for a null value and using the other table worked. Rus

I posted this in the query area no replys... :( I need my data to fill the sub-form come from one of two possible inputs based on plan-id. I am not clear on how to select the data to fill the sub-form. There is the main form with data from DB-A, then there is a sub-form that needs filled...

I need my data to fill the sub-form come from one of two possible inputs based on plan-id. I am not clear on how to select the data to fill the sub-form. There is the main form with data from DB-A, then there is a sub-form that needs filled with data from DB-B or DB-C, based on the key...

So far - So Good.. I am beta testing now. 10-15-10. Russ

On what event would this code be used? I thinking it would be multiple places? Before Update.. On Change ... On Update... On Exit.. On Click... Does that sound right? Thx Rus

Lock updating of One field on the form Bob -The is only one field on the form I need this rule in place for. The rest of the fields the users will be able to update normally. Russ

this code would be a new vb code module that this field would execute correct?

Is there a easy way to do this? I tried Lock but then the users can not add a record. I want them to be able to add but then lock them out of updating a field. Thx Russ

Bob - You are correct. The two to one works! I get to eat a little crow but get happy customers which pay my bills. Thx for the help. Russ

attached is the db with the example, no extra tables or fields just the basics. Rus

the forum squeezes out the extra space I have this fieldwithOnly1space: Replace([fieldwith2spaces],"bb","b") with the b being a space. Rus

fieldwithOnly1space: Replace([fieldwith2spaces]," "," ") I am trying this but it is not working any good ideas on fine tuning it? Thx Russ

Re: zip code formatting = Sovled IIF(Len(zip)=6, Left(zip,5),IIF(Len(zip)=9,Format(Zip,"@@@@@-@@@@"),Zip)) Thx for all the help. Russ

Re: zip code formatting - DIFFERENT but still bad Very interesting results. It is like there are invisible characters, sometimes. Take a look at the results. Maybe, it have to be some conversion to all CHAR then the length parameters. Rus

Re: zip code formatting - not there yet This is confusing why the - does not get carried forward. The 5 digit zips work great. The 9 digit zips sometimes carry the dash forward sometimes not? See the snapshots. Thx Russ