Recent content by MichaelJ

I am having a similar issue in that nothing runs as scheduled. Once I was able to make it run after restarting the scheduler via the control panel, but I am unable to replicate the test. After researching the problem it appears to be related to the latest security patch (KB841873) that fixes a...

On one of your command buttons that opens a report add this code in the OnClick event right after the DoCmd that opens the report: me.visible = false Then on the OnClose event of the report add: Forms!Nameof2ndReportform.visible = true I am still curious as to why the form won't disable the...

Sharon, I may be missing something here but if your primary goal is to remove the min and max buttons did you try setting the min/max property of the form to none and leave the popup/modal properties as no? Mike

Try this in the format property of the field. #;#;0;0[Red] Mike

We run in to similar issues with saving new shortcuts placed on the desktop and next time you logon the icon is not there and has not been saved. It may be that this is related to the roaming vs the local profile and how they log on the system. But regardless, is there a reason that you need to...

This will work but is a little crude at this point. The default value property can only be 255 characters even if it is a memo field it will probably truncate beyond that limit. Try calling this procedure from a command button. Create a test table Table1 with a MyMemo memo field and then set a...

OK, if I understand this correctly, when the user first views the record there will be some default value in the memo field. Then the user needs to edit or modify that value in some manner and add additional information. Then the edited value now becomes the new default value for future records?

Could you elaborate a little more for me. Is the field going to be blank and you will ask the user to select a value based on some criteria? Or will the field contain a default value and then you want the user to deleted it and add a new value? Mike

Here is what I think you want to do. Create a form as a dialog box with an unbound combo box field and a command button next to the field marked display vendors. This form will be opened from a switchbord button as a menu selection to display a specific vendor's records. The command button on...

Why would someone be requesting a page total of what appears to be unrelated data from a grouping standpoint, since you already are totalling grouped data and total data for the report? Maybe the answer is to page break by the grouping and that gives them an automatic page total. Mike

Working with subforms can get real challenging! I am assuming that your Master and Child field links are established in the subform control and the subform is the source object for the subform control and that all other data related to the record is being displayed properly on the subform...

This is a quick way to do it. Create a command button and then place the following code in the OnClick event. Screen.PreviousControl.SetFocus SendKeys "+{F2}" This is using the Windows SendKeys statement and represents pressing the shift and F2 keys simultaneously when a field...

Sorry, made a typo, it should read: Forms! (should have an S at the end of form, as in plural, and the code is all one line) Mike

Try this out. For the subform containing the command button that you want to have as the default, in properties of the button control set its default property to YES and the other button on the same form to No. On the subform that you do not want to have any default buttons, change their...

My understanding is that the jet engine only removes deleted objects when you compact the database. Prior to compaction, the objects (tables, queries, etc.) you delete are hidden and marked for deletion and the space they occupied is not available until after you run the compact utility. This...