Recent content by SparklyPrincess6969

Hmmm. What happens if you change the filter condition to [Forms]![CDLExamCONT]![Badge]?

You may want to have an AfterUpdate event for that Badge textbox that runs the VBA command Try that and see if it works. Is CDLExam a table or a query, by the way?

I am philosophically opposed to disabling "Show All Commands" in Options, because i believe organizations should have a non-hierarchical culture of pervasive trust and transparency that gives every user full opportunity to learn and innovate, and I am also really lazy. :) Nevertheless! my...

Yeah, you don't need to be doing this kind of validation on the level of a table, and I don't think you actually can anyway.

If you try opening up the subform on its own, ie without the main form being open, is it editable?

Sorry for late reply, I was in a meeting. Ok, I think I'm starting to see what you're driving at. If, for example, Query1 contains: Expr 2027024001 2027029014 1111111111 and Sheet2 contains APN | (some other fields) 2004001015 | (values) 1111111111 | (more values) you want...

I wrote something that should do it, here's the basic elements: 1. Firstly I have tblCategories, this contains ID | CategoryName | From | To where From and To means the lower and upper bounds of the category, I put 9999999 to mean "infinity" 2. First we figure out which category each line...

I took a look at your example - it seems just concatenating Mapbook, Page and Parcel doesn't give you something that matches any of the Sheet2.APN, that's why the join isn't working and Query2 is coming up blank. So what it looks like you need is a function that will take Mapbook, Page and...

I saw this one on Conan, by some comic who was guesting. It is very long and I have paraphrased it. A moth walks into a podiatrist's office. The podiatrist says "What's the problem?" The moth replies "Aw Doc, I don't know where to begin...I've got problems up to here. First there's my wife, I...

I've solved this before by using rowsources that automatically change to apply a filter when the user clicks a combo box to edit it, and then change again after the edit is made. I would do this in the following way: 1. When you make the combo box, set the query up so it includes everyone, i.e...

The query did in fact use UNION ALL to begin with, but it's good to know what that actually does so thanks anyway. Oh boy howdy, does it ever. There are some really fundamental design flaws which would take ages to adequately fix while either preserving or recreating their current...

Hi everyone, My client's database has a form whose datasource is a maze of dozens of interlinked queries, and naturally the thing is crushingly slow to run. (I didn't design this thing!) Now one particular bottleneck I think I've discovered, is a Union query which stacks ten separate queries...

You could try Now() returns the current date and time. I believe (-3) on its own will work because Access assumes you mean hours, however you might have to end up playing around with the DateDiff function.

(I'm not 100% on what you're trying to do here - are you directly assigning values to these three textboxes on the report based on the last record in the recordset Rev?) Anyway, there doesn't appear to be any filter for the specification number on the "Set Rev = etc" line - you might try adding...

I get paid money to develop Access applications, a fact which still occasionally mystifies me. I generally spend a lot of time fixing messes made by people who are too busy making productive contributions to society to design well-structured databases. Lurking this forum and sponging off its...