Search results

Yes, it will be more accurate to view the results over a greater time period than one full tank to the next. I have all of my reports triggering from a form where I can enter date ranges, different vehicle id's etc. I figured if I can get help with the correct code or method to get the correct...

Thanks for any help you can give, lark tilly. There's no rush here. I'm self-employed, so there's no boss breathing down my neck or anything. I've been doing it all long hand for quite some time and this is going to be a major convenience and hopefully get things running more smoothly.

Ultimately multiple vehicles. I did not include that trying to keep it simple. There is a table called "trucks" with autonumber key field "vehicleID" and several other descriptive fields and would be linked to table "tblAllExpenses" on vehicleID. Any help appreciated and thanks for the quick...

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

Thanks everyone, so much for your ideas and assistance. Sorry that I hadn't responded back a little sooner. I have a couple fires that have come up that need to be put out before I can get back to messing with this. As soon as I get the oportunity, (in 2 or 3 days) I'll give the suggestions a...

Thanks for the reply, Cogent1. Unfortunately that's not the problem. The support page that you directed me to is referring to the problems that occur when you install Access 97 on a machine that had/has Access 2000. My machine has only had Access 2000 installed on it...no other versions...

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

Thanks for your reply, David. I am just trying to clean things up. I was able to eliminate seeing the database window when using command buttons to close current form and open next form by using the echo settings and thought that this would be possible when opening a preview of a report as...

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

Rich, No would be the answer to your question but it looks like I owe you an apology. Apparently when I searched the archives, I must have had a particular forum selected to search in or something because it only resulted in 7 or 8 hits. I went back and searched again and made sure to search...

I appreciate your help and if the solution was/is in the archive and I just didn't find it, I apologize. I have the following code in my form. When I run the compiler, it comes back with the error "User defined type not defined" and highlights "rctOriginal As adhTypeRect" Option Compare...

Thanks Rich, but the archives here is where I found the article mentioned in the first place. I have read every post that included the word "resolution". I supposedly have the correct code but don't know if I am calling it correctly from the form.

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

Make sure that you are changing the page setup while the report is in design mode. Then save it.

Hello Ela, I'm using Access2K. Don't know if this will help, but what I have done when the item that I need is not in the list is have the subform open by using the NotOnList event. Here is the code that I am using... Private Sub cboItemname_NotInList(NewData As String, Response As Integer)...

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

Thanks SimonC for the advice. It is similar to the advice Jen gave and what she used in the sample database that she sent me. I'm not going to have time in the next day or so to try it out, but I am sure that between the two, I'll be successful in what I have been trying to achieve. I have...

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