Search results for query: *

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

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

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

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

hello, how do i make a toggle button that when depressed, allows one to enter data. When not depressed, locks the fields and doesn't allow data to be entered? -Kevin531

hello, i have a form that one can enter and edit data on. what i want is to be able to have a drop down list for companys that gives their information.(address, phone number ect.) this way completing the form will be easier, there are many companies to choose from. now what i want is to be...

i Have a database that has been secured through access so that there are user levels of security. my problem is that when i do this it locks the original database and creates a shortcut to run it though. Now the original database is locked, and i can't backup the database. is there anyway to...

i have a table that has the fields miles, date of maintenance, and unit number. there are multiple entries for each unit number. when i view a report i only want the report to display the most current date as well as the miles entered on that date for each unit number. i don't want all the...