Search results
-
Query Expression to autofill given other criteria
Haha, nothing like a messy string of code to get the job done. :D Glad you got it working. :) -
Query Expression to autofill given other criteria
Tried using DLookUp()? Yeah, I feel your pain. I know there have been plenty of times where I wish I could just pull fields from a secondary query. You can use a DLookUp() function to call information from another query if you need it, it's just a bit more of a pain to do. Have you had a... -
Query Expression to autofill given other criteria
No worries :) Company security policies are fun, right? lol -
Query Expression to autofill given other criteria
Give this a try... So based on what you've told me, I put together a real quick model database that I think addresses your problem. I'm not sure if this is exactly how you have it set up, but I think it's close. You'll notice I eliminated the Month and Year columns from the grades table, and... -
Query Expression to autofill given other criteria
Yeah, just reread your post and I'm pretty sure I'm answering the wrong question, haha. :o Sorry. Hope it helps a little at least. -
Query Expression to autofill given other criteria
This may not completely solve your problem but... Whether this actually helps you or not depends on whether you're trying to simply display the date info on your form, or store that info to a table. If you want to just display a numeric representation in separate fields on your form, you can... -
Need multiple record columns on one report page
That's kinda what I'm thinking, with DLookups. Now that it's not end of the day Friday, things are looking a little more clear, hehe. Hooray for the weekend. :D -
Need multiple record columns on one report page
Firstly, I want to apologize if this has been answered already - I didn't see it if it has. What I'm looking to do is create a report with three columns of data, from three separate records within the same table. Basically, I'm trying to clone a form we've been using to record customer service... -
Error accessing file. Network connection may have been lost
woo! back in action! Thank you so much for the tip, seshima. Thanks to you I had sufficient reason for IT to upgrade me from Office 2000 to 2003, hehe... :D Of course, this caused a whole other set of issues trying to upgrade (is everyone's IT dept like this? lol), but I think we've got most... -
Opening a file for editing
aw, swell! :eek: NEATO!!! Muchas gracias! This is uber-helpful. -
Opening a file for editing
I feel your pain, Jed. I'm having the same problem trying to access Office2000 format mdb's w/ Access2003. What's the deal here? Is this a new "security" feature or what? :confused: