This sure sounds like a classic student project; are you sure it's not? You're using a lot of structures that look like they're right out of documentation --- and with about twice as much code as you actually need.
Anyhow, here's the way I usually do this sort of thing, along with a few of my...
Can't tell if Mute101 is still working on this or not, but I'm going to look at the code and see what I can see. I'm heading out to a client site right now and won't have Internet access, but I've printed the code and will look at it.
Art Cabot
Strickland Technical Services, Inc.
Augusta GA
That's one of those irritating messages that usually just means "I can't figure this out, so I'm giving up and going home!"
Let me see how you're retrieving the values and putting them into the SQL...
Art Cabot
Strickland Technical Services, Inc.
Augusta GA
No, I've never seen it do what the client describes, and I can't see how it ever could've done it, at least as written here. I've already started re-writing it, but I just wanted to make sure I wasn't missing something obvious.
Art Cabot
Strickland Technical Services, Inc.
Augusta GA
1. I did not write the original code.
2. The client insists that it used to show multiple events for a given date.
3. Supposedly nothing has been done to this section, but the client can't remember when it stopped showing multiple events.
4. The events are in a pipe-delimited text file...
Have you made sure that there's something to link TO in all your tables? Just as in a query, if you link to a field that's null, you'll lose that item because you can't link a null.
Look at all your tables, or try to build a query using the same fields you're linking in your form/subform. If...
Not really enough information...
What's the specific error message and number? Are you willing to put a sample of the table and the form in an mdb and e-mail it?
The command from the macros drop-down is OpenQuery.
Or, you could use "RunCode", then create a function that just lists all your queries as in:
Function CleanUp()
doCmd.OpenQuery "QueryName1"
doCmd.OpenQuery "QueryName2"
End Function
Then call the function as...
Your question was
I've been called in to fix an events calendar that supposedly used to show multiple events on a given day. However, it doesn't look like the code I inherited could EVER have done that because of the indexing method used. Am I missing something? The first two elements in each...
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.