Search results

Newbie question...Using Access 2000 in XP. I have searched here and in other forums and found this discussed, but never resolved. I am trying to run a report that will display the vehicle's mpg. Each time fuel is purchased, the user enters total $ amount, cost per unit, odometer reading, and...

I posted this a while back and didn't get any response. Is there anyone that can help with this? Is my question making sense? I think that I need to COMPLETELY UNINSTALL Access 2000 and then reinstall. The reason that I am doing this is to hopefully correct what seems to be corruption. When...

I have made a form that uses a bitmap image as it's background. I have the image stretched to fit form and embedded as opposed to linked. The form only has 3 command buttons on it and a few text boxes. When the form is opened, it flickers between the image and the detail section background...

I have a form with a command button to open a preview of a report. When the command button is clicked on, the form is set to visible=false. When the button is clicked on, what actualy happens is: the form disappears, the database window becomes visible (the list of tables, forms, queries etc...

Has anyone gotten the VBA code to work that Ken Getz published online in his article “Screen Resolution, Resolved!” It is supposed to solve the problem of transferring a database to computers with different resolution settings, but I can’t get it to work. Would anyone be willing to take a look...

Access 2K. I have a form w/ a combo box. The combo box has the following for the NotInList event. Private Sub cboStorecategory_NotInList(NewData As String, Response As Integer) Dim Result Dim Msg As String Dim CR As String CR = Chr$(13) If NewData = "" Then Exit Sub Msg = "The...

I'm using Access2K. I have a Datasheet that is a subform. I have used the conditional format feature to change the color of one of the columns if the conditions are met. If I open the subform by itself the formatting, after about one second changes the data to the appropriate colors. If I...

I know that there is a simple answer, I just can’t find it. This is the second post regarding this, the first got no replies. Maybe the way that I asked the question was poorly stated or too confusing. Please take a look at the tables and relationships that I...

Newbie needs help. I have spent way to much time on this when I know that one of you experts out there can resolve this for me in less than a minute. I have created three tables as follows: [tblStores].[store] [tblStorecategories].[storecategory] [tblStoreindex].[storeindexid]...

OK. I have been working on this quite a while and can't seem to get it. I checked out the archives here and tried almost everything that had been suggested in the past with no luck. Maybe it makes a difference because my subforms are not visible. I have designed a form that contains 2...