Search results

I agree with Aziz. Access is telling you the object is valid, but not the method or property. That means the method or property was added at a later date, possibly via a service pack or some other upgrade.

My wife gave me a list of things to do, and I gave her my hourly rates. And then she asked for a divorce... :)

Advice my great-grandfather passed down, about finding the right woman: - Get a woman that will be loyal in marriage. - Get a woman that can cook well. - Get a woman who is fun in bed. Make sure these 3 women never meet each other!

I think my problem is, when I open the MDB file, Access will try to look at the linked tables, and I will get an error at that point, which I will not be able to trap, since I haven't opened any Access objects, like a form. Hmm.

You don't even have any error trapping. We need to know which line created the error. Just before End Function put this code: And just after variable declarations at the top of your procedure put this: Now rerun and tell us which line gave you the error when you ran the code the 2nd time.

I agree with Wiklendth. The Between keyword may not include the dates you specify. This is called "all dates between such and such, exclusive".

Your problem is your data type is "Date", which stores both the date and time. I think there is another data type called "Time" which you might want, if you don't also want the date. Also keep in mind the Format function merely changes the display of the data, not the data itself, the...

I'm using ACC2000. (Don't ask me to upgrade to ACC2007, it's awful!!) I have an app that links some tables in from an ODBC source which uses a login name and password. When the user clicks a button I want to first check that the ODBC connection is available before I try to get data from the...

You people forgot a major one for managers: "Thou shalt not hire a database manager without at least a 4 year degree in computer science or the equivalent." You would not believe how common it is for a secretary to be doing database design. Not that secretaries are bad. But I don't want a...

I thought tab controls were an interactive visual element for forms only, not reports. Perhaps you are referring to a different control for reports.

Let me see if I can remember the details about combo boxes. Your combo box must be set to return the column (of the source query in the combo box) that you want to display. This value is put into the .Value and .Text properties. If you are returning column 1 in the cbx (the value "1") but...