Search results

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...

Greetings, I am working on a form which needs to prompt the user to enter data based on specific information. Part of the data looks to see If Me.Code = "220" And Me.LocationOfOffense = "14" Or Me.LocationOfOffense = "19" And IsNull(Me.PremisesEntered) Then Cancel = True MsgBox...

You could create a pop-up form with the help data on it for that subject. Then either create a button for help, or have set the on double-click property for the label open up the form. DoCmd.OpenForm, Formname Peter Paul

It will allow me to add records when I view the subform in form view. It will not allow me to add records when the subform is viewed on the main form though....... I just looked at it again and it is sending an ODBC error about some fields which are null. Are null fields not allowed in the...

Greetings, I have attempted to upsize an Access database to SQL, and thought that I was realatively successful. I had problems with five tables, but thought I had figured out a work-around. But....... Here is the problem. Five tables upsized without any problem. These tables power subforms...

In a database, when the user logs in I have a query which looks to see what reports the user needs to write, (based on their logon,) and then shows a pop-up form with those reports listed. Until today, I had it working so that if there were no outstanding reports, that the form would cancel. I...