Recent content by jparks2010

So, I have a problem. I am working with a database that has many relationships but after a set time I want it to split the tables and archive the old data. I have been researching ways to do this because for this case the end user cannot do it as they dont know how. For preview my database is...

Hey everyone, I am not sure how to go about setting the default value of a lookup column within a macro. I want it to set the default value of a field in a separate table when the macro runs. Any guidance is sincerely appreciated thanks. James:)

This question is gonna sound kinda crazy but is it possible to hide the navigation pane within a macro. (Like the Autoexec macro) the one that starts at the beginning of the database. Before anything else. It can only hids cause it will need to be viewed later just not right away.

thanks I got it spelled correctly and all the records updated to reflect the new spelling

Hey all I have a spelling error in my lookup column. So I would like to change the spelling and have it automatically correct the spelling on all the records with the misspelled value. I am using Access 2007. Suggestions anybody!!

here is a link to the sample database. It is simplified for obvious reasons. http://studentweb.stcloudstate.edu/paja0901/testbed.zip.

I have strict orders not to post it because the information is not public. It is confidential information. So I do not believe posting the DB is something that I can do. Sorry!

is there a way to use the expression DLookUp on the table itself rather than the form

it does that is why I am unsure why the code doesnt update the field in the destination table rather than leave it blank.

just tried it. same result. I was wondering if that is still pointing to the form. is there a way to directly point it to the table.

The code I have looks like this Private Sub Student_ID_AfterUpdate() Me.Student_ID = DLookup("[Student ID Num]", "[Current Students]", "[Student name] = '" & [Student name] & "'") End Sub However it doesnt update the table itself like I need. Is this what you were refering to or something...

hey i am just a little confused as to how that would work for me please explain. What is the syntax used.

Thats all it took. Thanks. I do have one more question. How do I make it lookup the value in the Current Students table and then write the value to the Daily Contact Info table. Right now it is not recording the value just displaying it on the form. Can you tell me what property needs to be...

K so here is the formatting following the guidelines with the .Text property DLookUp("[Student ID Num]","[Current Students]","[Current Students]![Student name] = '[Student name].Text'") I am not entirely sure what the error was. But at one point it displayed #error! without much explanation...

I tried to leave out the .Text property and it came up saying error. When I reformatted it, no results came up. Is it possible I still have the formatting wrong. I am working with Access 2007.