Recent content by kousotsu

Or to deselect all, just set me.myListBox.Value = Null

I don't know about highlighting them: I would have a text list (in a label.caption or textbox.value) that displays current selections, a button to bring up the form that allows reselection with validation based on current selections kept (a checkbox asking if you're keeping current values =...

i'm going to be pulling my standard IT gag: stay late working on DB maintenance and unplug everyone's machines while the cleaning people work. Then, the rest of the IT monkeys will place bets on how long it takes the Moo-sers to figure it out (another good betting category is always the # of...

or you can use CurrentDb.Execute <strSQL> instead. this is tricky though because it will silently pass incorrect values unless you have some validation built in. using DoCmd.SetWarnings opens you up to a program fault that takes away all your warnings if you forget to set it back to "True."

if you submit a .zip with your sample db, it might be easier to get help. just by looking at the code isn't necessarily the best way to get a solution - there might be an easier method by querying, etc..

Rtm? While the forums are great for help, there are some of your questions that are easily answered by searching through the Access help files. The reading isn't all that intensive, and you seem like a smart enough cookie to catch on. I would recommend diving into the VBA help (using code in...

Huzzah! Boy did that suck. The forums went down (at least on my end), and it was just today that I was able to get to Ken's response. THREE CHEERS FOR KEN! Man, what a bitch that was. I don't know how many iterations i tried of that godforsaken thing, but I must have missed that one (the...

Jim waddled obstreperously

Broken Queries Just go into the queries and delete that particular element (fldOHMi) as it's unused in the scope of my problems; I just forgot to delete it myself.

Example File The file contains the basic basics of the database on which I'm working. I can't believe I just cut it down from over 4MB to less than 1MB! ^_^ Anyhow, the report is in there. If any of you can get the damned thing to work, just let me know here or shoot me an email to...

Ken's attempt Syntax Error, but thanks for trying ^_^

I'm probably just missing something simple, but I'm having a problem using DLookUp. I have a report which is bound to a particular query returning counted values by three criteria: Vendor, Area, and Month. From a seperate query (or pair of, depending on which way is quicker for the system)...

73|-| |-|4xx0|2z \\/4y If you absolutely have to have your numbers sequentially, you first need to build unbound forms and write your code so that updates don't happen if things are not as you want them... it's not an easy task most times. If you have records that you need to delete from the...

English Police Pat, I'm surprised at you: "presidence?" Though I suppose an item with higher PRECEDENCE would preside over others of descending rank, it's not even really a word. o_O Just a random attack of the Spelling and Grammar Police. ^_^

Minor Rant While that's true, I think it's just a matter of my knowing that language better than I know VBA/Access. I know VB well enough to be dangerous to myself and others, but I'm thoroughly versed in web languages. That's really what I do, but work is work and has been pretty lean...