Recent content by dsmaj

Damn...thanks for the info :)

Yeah.... Yeah, tried using that method already...I guess my questions should really specify that I'm looking to do this WITHOUT actually having to open the form in order to access its properties. Since I've got about 20 forms, and all of their modal properties need to be set/unset at the same...

Is there a way I can set the modal and popup properties of a form that is NOT currently opened from code? I want to do something like Forms!frm_Initiative.modal = True while frm_Initiative is not currently loaded. Thanks in advance, Sam

Perfect Thanks rich...that works perfectly. Sam

I've got a report with a bunch of code in the Detail_Print section which calls on values of certain bound text-boxes on the report in order to determine whether to set certain labels to visible or not. Everything works fine, unless the query doesn't return any rows, in which case I get a...

Hey thanks for the interest Rich....I've solved the problem. As it turns out, it must have been some sort of bizzare quirk in access. I just copied all the controls of my Report to a new Report, and it works now. This has worked in the past for me with corrupt forms as well. Thanks, Sam

Like the example above....should I be able to do Me!lblTitle.Caption = "Whatever" OR Me!txtTitle.value = "Whatever..." in the on open even of a Report? Or even within some other routine within a Report? As it stands, I can't do any of that, and I'm trying to determine if this is some kind...

Same prob. I'm getting "Can't assign value to this object" To confirm though...I SHOULD be able to modify controls on a report from code in the same way that I modify controls on forms from code, is that right? Any ideas? Sam

I'm having a wierd problem trying to modify either labels or textboxes on my reports. It's acting as if I'm not aloud to modify control properties at run-time from code. Is this an Access restriction on reports, or is something else going on? I'm just getting runtime errors when I try to run...

Hah, that post actually made me laugh in real life..."ha ha funny..." Anyhow, I probably wasn't very clear--I'm actually only running the query on searches and insert/append queries...not for _every_ string. Thanks for the input though, Pat. Have a good weekend, Sam

Thanks Thanks for the replies. I couldn't find that post you're talking about Pat, however coding my own function was simple enough. However, are there any negative performance issues with using the replace() function? Would it be better for me to manually parse my input string character by...

I'd like to know too... Apologies for bringing this post back from the dead, but I would like to know how to allow for DOUBLE quotations marks in an SQL string as well....anyone? Thanks, Sam

Am I blind, or is there no way to change the background color of a command button? Sam

Hey Kodo, I was thinking that as well. However, as the smaller listbox only obscures SOME of the larger search results listbox, I was hoping I wouldn't have to make the whole thing invisible each time the user presses the toggle button for the smaller listbox. Thanks for the reply, Sam

I'm trying to conditionally display a multi-select listbox ontop of a search results listbox depending on the value of a toggle button. The listbox that the toggle button spawns is much smaller and only covers a portion of the searchresults listbox. The listbox displays fine, however, if I try...