Search results

Wait, I'm confused... The relationships are all there in the queries, and appear to still be there if I add new tables to a query. So does it matter if I can't see them in the Relationships view? In the past, it seemed like certain queries wouldn't work if I hadn't added a table to the...

Hey, don't rag on the raven (although deservedly - sorry, isladogs, couldn't resist)! Without Raven, we'd have no sun, moon, or stars. We'd still have Access, though! I tried the copy paste idea from a post I found yesterday. It fixed the problem, but didn't carry over the relationships, so I...

Thanks, 'dog. I think I'm doing that correctly; tried a few cycles of decompile, compact, & repair. No luck.

I didn't see a PANIC forum, so hopefully "General" is the appropriate place for this. Was working on my project yesterday & had a snafu with a tech who was mucking around in my "WORKING_DONT_TOUCH" folder while I had things open. After chewing his bum and fixing the project he had set up...

Thanks, also, Doc_Man. The parts about str() adding a space for positive numbers were covered in the thread I attempted to cite, but I can't post links yet, so I need to make more replies. So here I am, replying!! I'm afraid I'm not understanding your comments about cstr() behavior for Boolean...

Yes, thank you both. I'm having some forum errors for not having made enough posts. I'd better get busy trying to be helpful. isladogs, I had initially tried to pull the link but received an error message, which is why I replaced it with the name of the thread. I don't think it will even let...

I have a question about a specific behavior of the CSTR() function. I was using STR() to convert integer fields to text before concatenating the converted fields, a text field, and some new text with "&". However, this added a space before the text numeral that I couldn't have in my export...

Thanks all, To answer more fully, I have updated my original post with the sequence of tables & queries. My database currently contains 518 records in Sample_Gradation_Intervals and 284 records in Sample_Intervals. The queries mostly chain off of Sample_Gradation_Intervals, so they each contain...

Thanks for the quick reply, arnelgp. Unfortunately, one of the things I've also tried is breaking it down into pieces. I've had it as ONLY the Previous_Pass subquery, and it is still weirdly slow. The preceeding query has three subqueries as well, could that be part of the problem? It loads very...

Hello kind forum users, I have a query in a new database I'm developing that persists in being slow, in spite of all I've tried to address it. I've gone through the "100 Tips for Faster Microsoft Access Databases", "The Twenty-Something Rules For Access Development", and all of Allen Browne's...

Hi everyone, I've been lurking a long time looking for fixes and tips, and finally have a question to post that I couldn't figure out on my own. Thanks for the great resource!