Search results for query: *

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

I can't figure out how to stop Access from moving the focus to the next control on a form after a sub executes. Basically, I'm trying to validate the value the user has just entered in tbx1 before they can move to tbx2. The values are integers and the textboxes are unbound (they just collect...

Thanks lupins46. I'm not using DoCmd cause these are multiple instances of the same form but your suggestion helped. I realized that the form object has the move method too. frm.Move Left:=1, Top:=1 Thanks again.

How can I, in code, cause each new instance of a popup form to appear on screen slightly offset from the previous instance?

I'm hoping someone has some suggestions for this latest problem of mine. One the things the database I'm developing will do is to keep track of tenants living in various apartment buildings. The tenants can move from one apartment to another in the same building or to another building included...

mo2783, I thought that would work too and I tried it earlier (and now again at your suggestion) but it didn't work. Of everything I tried, only: rst2.Update "TenantID", Null worked. But thanks for the input. It's always good to know more than one way to do things and to test out all...