Recent content by pullmyefinger

let's see what happens. Sorting problem solved already; I forgot about docmd.applyfilter. Thanks Bob, worked first time out..

1. been reading on here trying to find out what to use to solve a 3464 data type mismatch. I understand the error but have tried to fix it with 3-5 conversion functions including CInt, Val, Eval(Left(... etc. and nothing works. DoCmd.OpenReport "hieronly", , , "[hierarchy] = " & Chr$(34) &...

Perfect. If I wasn't so new to this I woulda had that idea in my toolbox. You never called yourself an expert like others have. You proved it with your answers. Thank You.

yeah, i tried the .visible=false coding and it didn't work either. last idea before I scrap the record navigation cmdbuttons. logic follows: since i can't hide or disable a control that has focus in access, i was reading about an event or property called Current or OnCurrent?? which is...

2003: I have a command button that has focus, can I hide it using "visible"?? I already tried .enabled=False and that doesn't work. How do I accomplish this or work around it? LostFocus Won't work.. How do I make variables "Global" so I don't have to keep redefining them in event procs...

ok, then what do I use in the Next Record and Previous Record buttons to get the correct, current record in the table serving the Form?? This needs to also update the correct number of records in the table after Deleting a record when I push the Delete command button..

All I wanted was to know how many records are in the table, including an updated number when any records are deleted. Someone told me there is a button wizard that does that for you but i don't have it and can't find it anywhere in 2003. This is one of the two button's code: Private Sub...

Sub CurrentFormRecord(frm As Form) Dim lngrecordnum As Long lngrecordnum = frm.CurrentRecord End Sub ======================================= The code above is supposedly a way to store the current record of a table tied to a Form??? 1. what the heck is (frm as Form) in the Sub? what...

No. No need to do that cuz they both worked fine prior to this and they don't seem to be "reserved words" or whatever Acc wants to call them. I replied earlier to someone else's post that I found and fixed the error myself.

======================================================== i get the moron of the week award. What happened is i made a copy of the edit form and called it delete. I just happened to look at the on open event for the del form and i deleted the "cancel as integer" part.. That solves that.

===================================================== ok, understand the learning part, but WHAT is causing the 2501 Error?? That's why I attached the db

thanks, but i commented out all that stuff and i still get the error so the buttons don't seem to be it.

do not have that wizard or add-in for whatever reason. besides, you don't learn anything by letting a wizard do it for you.

NEW: the command (next, prev record) buttons don't seem to be the issue. they were commented out and the form still won't Open from the menu OR manually. WHEN I try to manually run the form i get a message that basically says: The expression on open as the event property setting produced the...

I looked thru the help and found a way to specify how to enter a value for certain records to print in a report.. The suggestion was to use: DoCmd.OpenReport "somereport", , , "[somefieldname] = & Me.tbox (tbox is a textbox) I put in a text box, entered a value and ran the report...