Search results

ah. not that im going to be able to help you, but the problem does lie in the fact that in adding the new value for the combo there is no explicit record reference in the add form, as it is new? edit: Banana, how would you do this with queries or whatever. While i was proud of my solution, Im...

i believe thats what im looking for, wonder why i couldnt find it. THANKS!

Private Sub comContinue_Click() Dim temp As Variant On Error GoTo Err_comContinue_Click temp = SysCmd(acSysCmdSetStatus, "Filling table...") With DoCmd .RunCommand acCmdSaveRecord .RunSQL "UPDATE [tbl Modifications] SET [EntryStatus]=(1) WHERE [keyID]=...

well rainman, i can't be totally sure, but in short - yes for now;) . hey, how did that linking form from a new record business you were looking at the other day work for you?

i was hoping to find this sample database by PaulReed that is referenced. it looks to be exactly what im struggling to write myself, is this one of those 'presitehack' references i keep encountering? i'll keep looking for my own explanation..

unless we're in the same office, i get the impression that egotism and obtusity is par for the course.

:D :) Me too! well im forcing the analysts to rename all files to reference the processes. so if they want the record for abcd.efg.pdf, well, its abcd.efg. which is how you search for a record to edit it, print it off, or just look at it. the 10:45 you reference wasn't me. i think this...

Bellingham eh? I grew up in Seattle myself. (im in ohio now, dont ask) I see what your saying about turkeys but the reality is a. only two documents will ever be required until congress authorizes changing the budget allocation process for contract modification, which is unlikely to happen...

hmmm. i see what your saying. with what im working on the only way to search for a document, is to find the corrisponding record, and all documents must be stored in the same folder. I still don't see the need for a child for the the two required documents (there will never be more than two)...

its always a pleasure to see your voice. still. why would 1|Bob|C:reqdoc1|C:reqdoc2|----------|----------| 2|Lob|C:reqdoc3|----------|C:supdoc1|----------| 3|Law|C:reqdoc4|C:reqdoc5|C:supdoc2|C:supdoc3| resultin([database value] = "'" & [a crap] &"'") also, masochist that i am. i would like...

eats normalization for breakfast eh. i think we have different notions of value added.

Of course it would, but the people in the surrounding cubes are starting to stare...

im working on a database for archival, and i planned to give the option for additional documentation. I was just going to put a checkbox to reveal a few more controls which write to corrisponding fields on my table. Does it really add value to use a child table?

one of these days i swear im going to remember the ampersand and quotations BEFORE i cuss and swear for three days

i've been looking over the access security setup. One of the reasons i liked the idea of coding permissions by username was that I could avoid forcing my users to adopt yet another username and password. Most people here now keep a list of 25 or so different logins and if i can do this without...

not secure MDB thank you doc man, in all honesty i was hoping that you would be the one to respond to this one. I had seen some negativity towards access's built in security and thus was shying away from it - I'll check it out.

i believe the proper response here is to recommend you search for 'audit trail'

just an idea, but could you build a table with a field for each report/form/whatever that you would like to monitor, and then tack a bit of code into each (maybe the onopenevent?) which would add 1 to the existing value?

i thought i would post my plans, before implimentation because a. you guys usually recommend scrapping my idea and b. im not sure exactly how to go about implimenting it. Now for the details. I've built a database for the purpose of processtracking and document archival. This doesn't need to...

A man in a hot air balloon realized he was lost. He reduced altitude and spotted a woman below. He descended a bit more and shouted, "Excuse me, can you help me? I promised a friend I would meet him an hour ago, but I don't know where I am." The woman below replied, "You are in a hot air...