Search results

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.

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!!

I am trying to work with the DLookUp function and have a similar problem as a previous post http://www.access-programmers.co.uk/forums/showthread.php?p=954468. However my problem is the timing. By using the following code: DLookUp("[Student ID Num]","[Current Students]","[Current...