Recent content by Peter Paul

Greetings friends, I have a problem that I am sure is simple for you, but is evading me right now. I am trying to create a database for someone who reads meters on a monthly basis. The readings are related to the meter, and have the month associated with the reading. I created a query so that...

Hello and sorry to bother you all. I have a query which is based on a between statement of dates. Between [Enter Beginning Date] and Date() The other column is a count field, which sums the total number of records between the two dates. My question is, how do I display on the report or in...

Did not help Thanks for the thread, but it did not seem to answer the problem. Any other help would be much appreciated. Peter Paul

Greetings all, I have a user who is trying to run an Access database. On everyone elses machine, the application runs fine. When this particular user, on his machine, runs the application on one form we get into trouble. The form is a tabbed form, and only occurs on one of about five fields...

Greetings all, I have a question for you to which I am sure you already know the answer. I have a '97 database application in which I specify the workgroup in the shortcut. "C:\Microsoft Office\blah, blah, blah" /wrkgrp "\\pwrmorahq1\cirs$\cimes\system.mdw" We are now loading Office XP on...

Try This: If Me.TotalEquity <= 0 Then Me.TotalEquity.forecolor = vbRed Else Me.TotalEquity.Forecolor = vbGreen End If I think that this will work for you. Good luck, Peter Paul

Another neat option is one I got from the following website http://www.candace-tripp.com/_pages/HTML/default_HTML.asp. ' This code was modified from code I got from Candace L. Tripp ctripp1@ earthlink.net Dim ctl As Control Dim strSQL As String ' Return Control object...

Try Forms![FormName]![SubFormName].Form![FieldName or ControlName] "Forms!" and ".Form!" are literal. Good luck, Peter

If the data from your combo box comes from a table, then you can run the data through a query to sort it ascending. Then use the query to get the data, and assign the control source as the field you wish to store the data in. Hope it helps, Peter

If you are just trying to get the report into a better format to send you might try Snapshot viewer. It is a free program from Microsoft which will allow you to take snapshots of the reports, and save them to be viewed as they were formatted in Access. Hope it helps, Peter

How big is this thing? Can you send it to me? Peter

Right you are Rich, thanks. Peter

With your disclaimer, I am hoping that this will work for you. set the Visible property for the text box to False In the After Update property of the check box put in If True Then Me.[Textboxnamehere].Visible = True Else Me.[Texboxnamehere].Visible = False End If I think that will...

I suspect the problem you are having is that you are inserting new objects over the existing objects. If you want to modify the text in the object, either EDIT | OBJECT, or you can right-click to get into edit mode. The problem is that when the INSERT OBJECT splash-screen appears, you are only...

Another thought, something I have been using to help with remote users, but which works equally as well with folks on the LAN. I have set up some of my remote users with Terminal Services. That way the data processing is done on the server, and only the screen shots and key stroke changes are...