Recent content by kelfuego

Actually I have the form recordset being controlled by a list box. (the variety value doesn't change) When the user clicks on an item the fields are pulled based on that selection. This like I said is in a click event, not an update event. at here is the code: Private Sub list0_Click()...

Ok, to continue my grief on this subject--- I'm now getting a Run-time error '2115' error (the macro or function set to the beforeupdate or validationRule property for this field is preventing Access from savin the data to the field." Here's my code. Private Sub average() Dim varValue As...

Thanks again Kelly Johnson MCP Central City Concern

One other question, using this method I get an error message on records that do not have sales info --ie ltotal is null. how would I handle this problem using this function? Kelly Johnson MCP Central City Concern

Thank you so much for your help Kelly Johnson MCP Central City Concern

Whoops unfortunately I'm getting a run time error invalid use of a null. just a fyi In my table: My variety field is a text field My grade field is a integer my salesprice is a currency field Kelly Johnson MCP Central City Concern

Ok that helps a bit, but I'm still struggling with it. I created a test item to see if I could make it work here is what I have. Dim LTotal As Currency LTotal = DAvg("[salesprice]", "sold", "[variety]" = "bg-765" And "[grade]" = "64") test.Text = LTotal I plan to replace the variety...

Hello all, Hopefully someone might have an idea of how to help me. I have a form that track rare coins. The main form is used to track the number of coins graded at specific values (for a specific instance of one coin). I have a form that has been bound to the main table. the user chooses...

Thank you for your help. Kelly Johnson MCP Central City Concern

I right I'm in need of a bit of help. I am pretty weak with my vba skills and I'm hoping someone can spell out how to accomplish the task I wish to accomplish. Here's the scenario: I have an Access 2002 db table = tblcustomers CustomerNO field = primary key Lname = field I wish to populate...

Thank you both for the information you've shared with me. I didn't think to look in the sysvol folder---man I hate it when I miss the obvious. Mark, over the course of my career I have run into many many people who have been opposed to change and in a way I believe this to be human nature...

Mark, 1. It is another DC, but not on the same domain. I have a staff domain and a client domain that are kept completely separate. So no replication is not a possibility. 2. I do mean the GPMC (which I would love to use, but my boss does not want it loaded) So what I'm looking for is an...

Your second option appears to be more beneficial because of the error message that will be displayed. I could use the first, but if one of my associates is onsite and doesn't know or remember to expect to be logged off should something occur with the server it could cause confusion. Anyway...

how about creating a general user account (assuming your not giving general folder access to the domain user group) and then giving security and share rights to that folder only. Kelly Johnson MCP Central City Concern

So I am interested in backing up a group policy so that I can apply it to another server. Is it possible to do this without downloading and installing the group policy add-in from Microsoft? Kelly Johnson MCP Central City Concern