Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How Could This EVER Have Worked?
Got it working. This forum was a big help! Art Cabot Strickland Technical Services, Inc. Augusta GA -
Run-time error '2001'
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...- artcabot
- Post #8
- Forum: Microsoft: Access Forms
-
Run-time error '2001'
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- artcabot
- Post #7
- Forum: Microsoft: Access Forms
-
INFORMATION NOT VISIBLE IN SUBFORM
Let me know what you find... Art Cabot Strickland Technical Services, Inc. Augusta GA- artcabot
- Post #4
- Forum: Microsoft: Access Forms
-
Run-time error '2001'
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- artcabot
- Post #3
- Forum: Microsoft: Access Forms
-
How Could This EVER Have Worked?
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 -
DATA IS NOT DISPLAYED!
zip and send to acabot@stricklandtechnical.com Art Cabot Strickland Technical Services, Inc. Augusta GA- artcabot
- Post #4
- Forum: Microsoft: Access Forms
-
How Could This EVER Have Worked?
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... -
INFORMATION NOT VISIBLE IN SUBFORM
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...- artcabot
- Post #2
- Forum: Microsoft: Access Forms
-
DATA IS NOT DISPLAYED!
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?- artcabot
- Post #2
- Forum: Microsoft: Access Forms
-
having trouble causing macro to run append query, help
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...- artcabot
- Post #2
- Forum: Microsoft: Access Forms
-
How Could This EVER Have Worked?
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...
