Recent content by Vie

I'm wondering what brand and model of power conditioner/surge protector tek-tippers might recommend. I'm hoping not to have to spend more than 300 to 500 bucks but need sure quality.

This isn't really a big deal but it strikes me as unprofessional-looking. When I open a particular form from the switchboard a strSQL statement is programmatically assigned to the recordsource of the form's subform. Basically, a subset of records from a few different tables. The thing that...

mustangcoupe, No luck with that either but thanks for the suggestion. Vie

Thanks AceMan, I've done both of the first two -- guess I'll have to try the third. Oh, and it's Access 2003 running on XP. -Vie

Hi Aceman, Didn't work. If it is some sort of corruption, what do you think might help to resolve it? -Vie

Thanks, I'll give that a shot! Vie

Hi AceMan, Yeah, I think it might be too. I tried exporting the code, etc. to a new mdb file and that didn't help. Truth is, I just set up a new barebones system with an upgrade to Access 2003 (from 2002 - my old PC died of registry disease). Most things have been so much better but this one...

I apologize if I am wrong about this but I don't think you can set the alignment of particular columns in listboxes. Are subforms not an option? They have as many if not more capabilties than listboxes.

My form has a subform whose recordsource is set to an SQL statement when a command button is clicked (not doubleclick). The problem is the records don't appear in the subform on the first click -- actually they do sometimes but most of the time, it takes two, sometimes three clicks to get the...

PH, It worked! Thanks very much. I wouldn't have thought of of trying that. Have a star! -Vie

I hope this helps explain better: AfterUpdate rstFloors.Find "Floor = " & intFloorStart,,adSearchForward If Not rstFloors.EOF Then If MsgBox(msg, vbYesNo, "Floor already exists") = vbYes Then Me.tbxFloorStart = intNextFloor Else 'vbNo Me.tbxFloorStart = "" End if...

Thanks PH and Rick. Rick: You're right about not needing the Undo. vbNo works okay with the Cancel alone. PH: What might've been confusing is, in my first msg, vbYes worked fine when the code was in the AfterUpdate. vbNo worked too, in terms of changing the value of tbxFloorStart (tbx1)...

Well, that's better for vbNo. But it still doesn't work for vbYes. Same error. I tried putting Cancel, Undo, etc. in the vbYes If block and still the same error occurs.

Here's the code: rstFloors.Find "Floor = " & intFloorStart,,adSearchForward If Not rstFloors.EOF Then Cancel = True Me.tbxFloorStart.Undo If MsgBox(msg, vbYesNo, "Floor already exists") = vbYes Then Me.tbxFloorStart = intNextFloor Else 'vbNo...

Thanks for replying. I tried that but I get run-time error -2147325267 which says "The macro or function set to the BeforeUpdate or ValidationRule property of this field is preventing Microsoft Office Access from saving data in the field." Doesn't cancel = true, undo method only apply to...