Recent content by mgolla

Have you thought about creating a fake list box that is actually a sub form with conditional formatting? This would give the appearance of a list box but would allow you to change the highlight by changing the background color of the text box when it gets focus. HTH Mike [penguin]...

Julia, Check out JeremyNYC's FAQ about Access. He has some pretty good stuff in there including security. It might help you out a little bit. Here is his website http://www.ABCDataworks.com Just goto the Developer's Section HTH Mike [penguin] Dooobie...Doobie......Dooo Beware the penguins

I know in Access 2000 you can edit the Icon or choose from a list of icons but not sure if you can pick a custom Icon. Goto Tools->Customize and then select your toolbar. Right Click on the Icon you want to change and select Edit Button Image or Choose Button Image. I would think 2003 has...

To get the Full path name there are two options. Using DAO: CurrentDB.Name - This will display the full path and name of the db Using ADO: CurrentProject.Path - This will display just the path of the db HTH Mike [penguin] Dooobie...Doobie......Dooo Beware the penguins

Take a look at this application. I think you might like it. http://www.geocities.com/waddly/accory.html HTH Mike [penguin] Dooobie...Doobie......Dooo Beware the penguins

Use the Left statement to extract the first two characters to put into a different field. Example: MyStateField: Left([IDnum],2) HTH Mike [penguin] Dooobie...Doobie......Dooo Beware the penguins

Here is what I would do: 1) Have the text field hidden on the report 2) Add a label and place it where I want the text field displayed 3) Put this code in the On Format event of the report detail [code] Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Select Case...

Try moving it to the Before Update event: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.LastEdit = Now() End Sub HTH Mike [penguin] Dooobie...Doobie......Dooo Beware the penguins

What happens when you try to navigate? HTH Mike [penguin] Dooobie...Doobie......Dooo Beware the penguins

Have you tried this: Scaled Score: IIf(IsNull([SCALED_SCORE],0,Val([SCALED_SCORE])) Then <65 in criteria? HTH Mike [penguin] Dooobie...Doobie......Dooo

Here is what I would do: 1) Create an append query using the query you already built to select customers which have a past due balance of greater than $20.00 and show no credits (payments) for the last 45 days. 2) Add A couple of calculated fields to this append query like so: DebitField...

Ok, since you are using a form you can simply add some code to the form that will set the value of that field to the current date/time after updating any field on the form. Here is how: 1) Make sure to have a field that uses LastEdit as its control source. Make it hidden if you don't want...

Are you editing directly from the table or are you using a form? HTH Mike [penguin] Dooobie...Doobie......Dooo

Change this: To This: Reports!rpt_Work_Order_Completion_Summary.Filter = "FY=" & Me.txtFY & " AND QUARTER=" & Me.txtQuarter Make sure the txtFY & txtQuarter are numeric values otherwise you will need to add single quotes like this: Reports!rpt_Work_Order_Completion_Summary.Filter = "FY='" &...

Change this: to this: If strWHERESQL = "WHERE " Then strWHERESQL = " " End If HTH Mike [penguin] Dooobie...Doobie......Dooo