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...
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
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...
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...
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...
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...
It was confusion about how to go about it. i figured it out though. just a matter of finding the right combination of things and linking the right fields. thanks. sorry it took me so long to reply.
Sorry, maybe i didn't explain my situation clearly. what i have is a form with information on it. there are three subforms on it that display company information. a drop down combo box is used to select the companies in the subforms. my problem is that i have multiple companies with the same...
hello,
here is my situation. i have several places on a form (currently subforms) that a combo box drop down list finds a record on my subform. my problem is that i need to view a company name, as well as a contact associated with that company. (there are multiple contacts per company).
i...
Hey guys, i've been watching your thread. i need the exact same thing on a form that i'm working on. i'm not good with vb code and i've gotten a little confused. where does your first line of code go? does it go under the OnFocus event? or does it all get grouped together? i'm confused...
How do i set these options and specify which way the toggle is defaulted to? is there a way to have the caption of the toggle button change when it is pressed? i'm not good with visual basic so any extra help would be greatly appreciated. thanks.
-kevin531
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.