Search results

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...

Archimedes was right... Eureka! ^_^... as usual, you guys |20xx0|2z my |30xx0|2z... Thanks again. God, how I wish I was just programming this in PHP like I originally wanted to. **sigh**

Yes, they do, but then they refuse to Sum by "Points", but rather continue to separate them by the irrelevant parts of "beginTime." I got a crosstab query/by month report with dcx's suggestion that seems to work, but I will need to rebuild the query/report as each month goes by. Here's what I...

I know I shouldn't have to ask this question, but I've obviously blotted this from my head somehow o_O: I have a formatted date imported from Excel (Longest date possible: dd/mmmm/yyyy, hh:mm:sss - formatted likewise) upon which I need to operate solely by month. I asked to be able to strip...

Just what the doctor ordered You guys really are the best - don't let anyone tell you otherwise. ^_^ KK: That's the application, exactly. I've built the trimming/forestry part already (got them on the bandwagon, finally, for normalization), but this Y14 complaints bit has been a runaround...

A little less confused I'm actually a 27 year old American Mutt with a penchant for learning and language. I do my best not to mangle the English language - gotta represent, y'know ^_^. As far as the DB goes, I've *tried* to address the issue I'm having with my superiors; however, there is...