Search results

Well I guess it isn't really a problem having the two seperated. But I would prefer to have them together. In my mind and for the limited time I have to work with the site right now. So having them together is the prefered meathod to me. Also I have been getting jerked around by the two I do...

Ok, I have just taken over a webdeveloping project for some of my friends who are starting an online magazine. Anyway, the person that was originally doing this for some reason has the domain registered at a place that doesn't host the site but points to a host. I don't like this idea at all. I...

Nevermind i just worked it out. Thanks a bunch.

Well Jon thanks for the quick response. Now I am curious as to which txtbox's After update do I put it on. So far it doesn't do anything at all. I have what you said in the after update in textbox1. Thanks again.

Ok, I know I'm going to sound retarded here, but with all this I'm doing for a search function I can't seem to figure out something I know is just simple as hell. It's killing me. Anyway I need to take a value that is entered in one text box, and add it to one that was entered in another text...

Alright everything is working on that. Now I just have to work on my calculation, but that is not difficult matter. At least I don't think it is. Thank you all for the help you provided.

I follow the norm. I will work with it in a little to see what I can, and I will check on everything you said to see if any of that works. Thanks for the patience

Well I tried the different things. Moved the code into the On Change of the combo box and I recieve this error now. Run-time error 2471 The expression you entered as a query parameter produced this error: 'The object doesn't contain the Automation object "RetentionField." My code is the same...

ok, that would work the best I think. I will work on that and get back to here when I need to work on this calculation if I can't figure it out. Thanks.

because I need the retention to make a calculation for another bit of information. I am not sure if I could do that if it was a column in the combo box. If thats possible then I can do it that way.

Private Sub txtRetention_Change() Me.txtRetention = DLookup("[RetentionField]", "[tblRecordMgmt]", "[RecSerNameField] = ' " & Me.cmbRecSerName.Column(0) & " ' ") End Sub This is what I have in my code. It no longer gives me the error, but it doesn't do anything else either. This...

I still get the #Error. I can't seem to get it to work no matter what I try.

OK I've modified it a little because I didn't understand why I did that. So here is what I have now. =DLookUp("[RetentionField]","tblRecordMgmt","tblRecordMgmt.[RecSerNameField] = Forms![frmAdditions]![RecSerName]") It still gives me the #Error though.

Ok, I have a Record Series Name, and with each name there is a corrosponding Retention. Now what I would like to do is lookup the retention based on the name that was selected in the combo box. I am pretty sure DLookup does this, but when I do it i am always getting a #Error in my retention...

I thank you Pat. I thought this as well, but my mentor project supervisor or whatever is pretty set in her ways. Hopefully I can convince her to see it the way I did.

For lack of response I have to wonder. Is this even possible? or does it have severe logic problems to it?

First let me give a little background on what I am trying to do. I have a form where I enter in data on a publication that my company releases for my department. On that from I have a subform that holds all of the record management data. Now I have a table that holds all the things important...

An easy way to do this would be to first delete your relationships and then change primary key to number. save it. then change it back into autonumber. Then re do your relationships. should take like 5 minutes.

Can I write code that tells Access to run as a certain user depending on the windows login? I know the API calls to get the Windows user name. Can I have it check and see if, for example, "Staff" is logged in to Windows, then run the DB as "Peon", and if "Admin" is logged in to Windows, then run...

I don't know much about using ADO in VBA, but I am pretty sure that in VB you are able to do something along those lines. I think it depends on how it's bound to the table/query or whatever. Someone might be able to answer this better than myself.:confused: