Search results

I would set up seperate reports for each condition. Then set up a macro to run and export each report

I don't know if my answer will help, but I had / have this problem and made a temp solution. I made a second password protected DB and only allowed a couple of users access that I felt were qualified (it also helps to grab the NT user ID and date stamp on logon in a hidden tables just so you...

I use the below code and grab the NT user ID while at it Option Compare Database 'Masterform LastEditedBy code 'Benjamin Linville Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Public Function GetNTUser() As String...

More tagging along for a response, but is there a line a code (to place with a form button) that will open a build query window? I know I would find that useful, only fear would be someone switching to a delete / update / append query. Probally best to have a pop up stating not to save as well.

I am not sure how to get it to you, but I have an Access 2000 form (VB written) that does this for you. You just select the db path and it will tell you the CPU id and the NT log in id

Well. ok - responses are still welcom, but I made a temp fix. I checked one of my other (more complex) DB on the same server that is running the same code for tagging changes. It had 4 boxes (referances) checked (vs. 5 including the one titled missing) I unchecked the "missing" referance and...

I know I am missing a referance, as soon as I compile, it gives me the error of "Can't find project or libary" It then brings up the Availible References window with 5 checked, the last checked being "MISSING: DatesLibV3a.mde" It looks like it is looking in C:\WINNT\System32\ What I do not...

Thanks, but that failed on FORMAT with the "unable to find project or libary" again. I removed the format and just used now - it then fails on the top........ ********************** Public Function GetNTUser() As String On Error GoTo Err_GetNTUser Dim strUserName As String strUserName =...

Well, it failed again (on date in the compiler) I changed to 'Now' and it failed on 'Time' ***************** Private Sub Save_Click() Me.LastEditedBy.Value = GetNTUser & " " & Now & " " & Time On Error GoTo Err_Save_Click ***************** I tried to compile and it brought up a referances...

Used for either - you add what you wish for the send to option - I use it for internal use but I place the external address in (not the short name for internal apps)

OK, thanks, I'll try the now, but why does it work for a few days then fail? I reload the DB from backup and it works then fails in a few days / weeks - this just seems realy odd

Mailing For mailing I use a seperate command button in the hyperlink I put mailto:USER@COMP.com?subject= SUBJECT.

I do...... Option Compare Database 'Masterform LastEditedBy code 'Benjamin Linville Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Public Function GetNTUser() As String On Error GoTo Err_GetNTUser Dim strUserName As...

OK, I have a DB that has a small amount of VBA. Bassically, I have a form that is used for data entry with a save command button, this button updates a hidden field that records the users log in id and a date stamp. I use this code on most of my DB and it just works. Anyhow - It works on this...