Recent content by kevin531

It's in there. I've experimented more and found that if i cut and paste the SQL into a new query that it doesn't work then either. i think what i may not be understanding well is the tops command. what this query does is finds the latest date, then finds the miles that associate with that...

hello, my question is this, i have a piece of sql that works under "cars" but not "tractors" i've simley cut and pasted. i've checked and everything seems correct. the error i get is: syntax error in join expression. it errors out to a comma in the first line of the...

something of mine. it was an expression. -kevin531

Sorry, i figured it out. i had to remove the equals sign to get it to work. i also had to remove the sumation that was there. but it works now. thanks.

pdldavis, sorry it took me so long to get back to you. the weekend and all. i've followed your suggestion and it makes sense. however, when i try to enter: "=Between [Forms]![forcast form]![txtStartDate] And [Forms]![forcast form]![txtEndDate]" i get an error. it says that...

is it possible to filter a calculted control in a report? what i have is a maintenance forcast. i when the report is run i only want it to produce records within the next week. what i would filter by is the calculated fields. is this possible? any advise would be great. thanks. -kevin531

yes, correct file. yes single mdb. does problem this have anything do to with transfering from office xp to office 2000? -kevin531

i did what pdldavis suggested and checked to make sure the text box was named differently from the control source. thats what made it work. i changed it back to the original name to see if it mattered and it does. i get "#error" when the names are the same. thanks.

When i burn my database to cd only six out of the 30 macros copy over. The macro folder is there but inside the macro all the data is erased. I tried burning it at a slower speed thinking it was burning the macros to quick and skipping over some of the macros, but that is not the case. nothing...

hey guys, that worked. it was a circlular referance. thanks. kevin531

Hello, i have a report that has "unit #", "date of maintenance", and "mileage". what i want the report to do is forcast the next time vehichles will need serviced. i want to simply add 3000 to the miles control. i've tried doing this everyway i can think of but...

Sorry, i just tried that and it didn't work. -Kevin531

hello, i have an active x calendar control that when a date is selected, if populates a field. what i want it to do is when the calendar control pops up, i want it do display the current date. if it does this then the user wouldn't have to select the month and year to keep it updated. i've...

thanks. i got it to work. it was a problem with my where condition. thanks again, -Kevin531

i'm having a problem with the a report. it has three subforms on it and here is what i want it to do: on my form when i select the "print preview button" (a button with a macro i created) i get promted for a parameter. if i enter a parameter, it works and i get the desired results...