Search results

Mike...thanks for the tip!

Ok, solved the problem by putting the Me.Undo command in the beforeupdate field, preceded by a message telling the user changes are not allowed...

Rich...my form has something like 30 memo fields...i really don't want to have to go into each field to make that setting (I have 6 other forms just like it), i was wanting to do something to the form property itself but nothing seems to have any impact on those darn memo fields...

I have a form that has lots of memo fields, I want to make it read only...the snapshot view doesn't protect the memo fields, nor does turning off the edit, add, options as properties in the form...any suggestions how to allow viewer to see them, expand them, etc., but not modify??????

Ok, borrowing from the sample code put up by Microsoft to do this, eg password protect a form or report, I keep getting nowhere...now I'm getting "type mismatch" error...here's what I've done... 1. I've created a new module which I've called "KeyCode" containing the following: Public Function...

I have a table that has about 30 memo fields (sigh)...any suggestions about designing a report that would accomodate so many memo fields and make it easy to skip over blank ones?

Well, i checked the references and it let's me check some, but on others it says "Can't perform requested operation"; when i go to "run" it says "Unexpected error [3219]"

Sigh...I'm using the 97 version...and now when i try and run it i get "Unexpected error (2121)... [This message has been edited by Randix (edited 03-25-2001).]

I was interested in password protecting a form, so I went to this link... http://support.microsoft.com/support/kb/a rticles/Q179/3/71.ASP?LN=EN-US&SD=gn&FR=0&qry=q179371&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97 I substituted my form for the Northwind example, and I copied and pasted the code to...

wearing out my welcome... Can someone direct me how to accomplish a very simple task...namely... If I have an opening form, how do I prompt someone to logon, retain that data as a public variable, and be able to refer to it as a condition during that session of accessing whatever...?

Ok, gawd decided s/he has caused me enuf grief on this one...i figured it out...thanks for the outlet in any event!

Ok, when I'm accessing a table that is not joined and i add.. Private Sub Form Current() If [Control] = "X" Then Me.AllowEdits = False Else Me.AllowEdits = True End If End Sub where "Control" refers to a field in the table that the form is oriented to, I have no problem and it works...

KevinM...thank you very much, your suggestion was perfect. Steve

Rich...thank you for your response...I did set it to "no" and it's still displaying the blank record when you keep paging down...would there be another setting that would supercede the form setting, or would it have anything to do with the fact that i have two tables joined in this form? Ok, in...

1. I have a form and if you click on one button on the form it runs a macro that opens up another form and the macro has the following condition: [contract]![Project_Name]<>"" 2. When the other form is opened, it does it on a query that contains the following code: SELECT contract.*,audit.*...

If I'm allowing a user to access the records of a table in a form, but want the ability to "turn" on or off particular records, eg so they are "read" only to the user (eg particular records of a table whose status I want to easily change from time to time), what's the easist way to do that? I...