Search results for query: *

Than you all very much for you help.. checking for AllowEdits worked perfectly for my needs. --Toby-- Novice Programmer; Expert Hack sapere aude: Dare to be wise

Is there a way to detect if acFormReadOnly or other such parameters were used when opening a form? Novice Programmer; Expert Hack sapere aude: Dare to be wise

Thank you very much SBendBuckeye.. your answer was very clear and explained a lot to me. --Toby-- Novice Programmer; Expert Hack sapere aude: Dare to be wise

Hello, I'm tring to understand how Modules work, (as I under stand it so far, it's where you store procedures and Functions to be called by various forms) What I have having troubles understanding is how to pass control to and from.. (let's say a function). I want a button the check the...

Okay, here's the pseudo-code as well as an explained summery: Set clone Bookmark current recordset Move clone to the previous record. If it is not the BOF, then Save values to be copied over. Close clone --Not sure why reset the Recordset? Paste saved values into unbound textboxes. end...

Is there a way to detect if acFormReadOnly or other such parameters were used when opening a form? --Toby Kliem-- Novice Programmer; Expert Hack sapere aude: Dare to be wise

Hello, I'm working at learning VB for Access and I've run into a snag with my current project. The code below is executed in the ON CURRENT event for a form where the RecordClone retrieves a value from the previous recordset and then enters the number into an unbound textbox. This part works...

I whole-heartedly agree that C Vigil's post should be moved to the FAQ section. His wording is clear, consise and extremely detailed. All I have to say, C Vigil, is "Thank you." You've have done all us budding programmers a great service. :) --Toby Kliem-- Novice Programer Expert...

Ah ok, I believe I understand what you are talking about, however I'm still not too familiar with working with VBA and recordsets. What would the code for setting a filter in a recordset look like? Would that be similar to what the code for a Goto Record command button would look like? Thank...

Hi there, I'm tring to clone a field where the previous field may be filtered out. If I turn off the filter this script works perfectly, however I need to restrict the form to only the relevant records. This is the filter I'm using, [Forms]![frmDepartment]![deptID] And this is the recordclone...

That makes sense. Then is there a way in VBA to temperarily disable the link criteria then re-enable it? --Toby Kliem-- sapere aude: Dare to be wise

Thank you Robert, I just found out about the RecordsetClone method tonight and I'm reading like mad to learn how it works. Let me see if I can clarify what I posted. I call the subform using a filter and need to retrieve data from a record that is being blocked. In this case, would it be...

Hi, I need help typing up an Event in VBA code which would retrieve the value from the same field in a previous record. Right now I'm using this in the Control Source of a subform to look up the previous data...

This was exactly what I was looking for. The second example was the key actually. Thanks again. --Toby-- sapere aude: Dare to be wise