Search results

That's odd. How does your Macro differ from my #6?

Yes, exactly correct. You cannot (without a lot of jiggery pokery) edit your Releases table from your Receipt form... hopefully the reasons for that are self-evident. :D The code I gave above was assuming that Receipts and Releases were in the same table... why are they separate? You should...

No problem. Can you give a couple of examples of what would and wouldn't fit within an example filter set? Something like "If I set the dates to Between 1/1/2013 And 12/31/2013, the valid program titles are Cheetah Racing, Porcupine Petting, and Elephant Wrestling. Tiger Baiting ended in 2012...

You're so close, you have the right theory here but not the trick of it. The trick is to build your WHERE clause as a string variable, piecing it together with AND or OR as makes sense. That's where your IF statements get used. Then, at the end of all that concatenation, you run the IF you've...

Good luck dragging them kicking and screaming into the late 20th Century! :p

I think you're close but no cigar. http://support.microsoft.com/kb/113352. TryWHERE (((dVehicle.LeadID)=Forms![frmHome]![frmToDo].Form![txtLeadID])); Your other option is to use the Expression Builder > Loaded Forms to double-check yourself.

All three of those functions usually work quite fine from a bound form. Are you having to manually/programatically change the recordsource for each function?

I agree with jdraw, it will be worth splitting that data into a temporary table even if you don't end up importing it permanently.

[code] tags are here on the forum, they make code snippets easier to read (see reply #8 for an example). ...okay, let's back up a step. What is the difference between the Receipt and the Release tables? Do you have a form at all that's based on the Release table?

That usually means that formRelease doesn't have tblReceipt in its recordsource/query. Does that sound accurate? Post the SQL behind the old query that works. If formRelease isn't based directly on tblReceipt, post the SQL of that query too. Use [code] tags for readability please.

Wayne I'm sorry you wasted your time. This user was just spamposting until they could post links.

Do your records have a datestamp, like DateCreated or DateEntered?

Since you can only delete a file when it's not open, I agree with namliam. How would you expect Access to stop this?? What you need is a Windows folder-level permission change.

Oh please. You're both desert death cults. The Bible/Torah is chock FULL of murderers who kill in YHWH's name, including YHWH Himself. Jesus you can argue is different, but even he cursed the fig tree for no reason.

If it doesn't work, post a stripped version of your database (.accdb is fine, though I'm in 2010 not 2013) and we'll see if somebody can figure it out. That's really odd.

Yes, but Count(SkillList.CandidateID))>1 will return people if they have 2 of the 17 skills you want. My version looks for how many skills you are asking for today, and returns only those people who have all of them.

Yeah, .Filter is going to be the way to go. It'll keep him from having to close/reopen all the time.

Subforms. You need to have the Primary Key of your Companies table as a Foreign Key in your Contacts table.

Screencapture and crop? I am not sure there's any way to 'extract' them officially... http://stackoverflow.com/questions/10792426/access-export-images-from-image-controls-in-forms has some theories, and you may find others by googling 'extract access PictureData'.

*shrug* Storage is cheap, and this way his PK doesn't have to be linked to EVERY query to get the membership number. He's going to want to index it and put unique constraints on it anyway, so that saves nothing. Access is a toy database, but even it can handle 20 bytes per record.