Search results

Jack - I had a similar problem. Thanks fopr your explanation; your solution is perfect!

THANK YOU OPM Coordinator - it worked like a charm!!! Everybody - have a great weekend.

Hi - Thanks for the response. However, the code I used worked during my testing. My specific concern is where and how do I hard code in the integers that I want to make it work for the delay and the display of the hourglass. Thanks.

I have the following code: Option Explicit Function Wait (Delay As Integer, DispHrglass As Integer) Dim DelayEnd As Double DoCmd.Hourglass DispHrglass DelayEnd = DateAdd("s", Delay, Now) While DateDiff("s", Now, DelayEnd)>0 Wend DoCmd.Hourglass False End Function This function work when I test...

Hi Rich - Yes, it is an option and I may be left with it but I really was interested in automating the entire process. Thanks for your speedy help. I appreciate it.

I want to compact a series of databases. Currently, I use a combo box and set it to run a macro to open and compress each database (run app command with a path as follows: "c:\programs\msoffice\msaccess.exe" "c:\documents\dbname.mdb"/compact Currently, I have to individually select each...

Hi - In addition to grouping by client, select under the group properties that you want to keep each group on its own page (the group properties are in the grouping/sorting tool and it is the last entry ("keep together"). Hope this helps.

Sorry folks - operator error on my part. All I had to do was close the second form and, then, when I reopened it with the Main form it would be "clean".

Thanks for your help but your suggestion did not work. Maybe the problem is my explanation - the main form allows the user to select among three (3) choices. Once the user makes a selection, the second form allows him/her to use a combo box to run one of several reports. This second form also...

I hope my title adequately conveys the gist of my question. I have a form that merely takes the user to a second form from which the user can perform designated tasks. The second form has a "go back" button that returns the user to the Main introductory form. When I "go back" and then go...

I found a way to show percentage increases/decreases in reports and am passing it along: Create a text box and insert in it the following (no quotes): "=(IIf([CurrentAmount]=0,([BaseAmount]*-1),IIf([BaseAmount]=0,([CurrentAmount]*1),([CurrentAmount]-[BaseAmount])/[BaseAmount])))" I hope this...