I am building a database for use in a law office.
Our practice covers a number of venues and we see a few thousand cases per year.
Two of those venues (jurisdictions) use the same format for their case numbers and quite frequently we see different cases
in these venues using the same case number.
Ideally I would like the case number to be indexed no duplicates for obvious reasons as human error is a factor when data entry is concerned.
However, these two venues create a problem with that.
Is there a macro solution to overcome this issue? Or, can
the index be linked to the venue field as well as the case number field with an "if / then" statement?
Also, is it possible to get an input mask or validation rule to change based on the value of another field? Example; Each venue has a different format for their case number (the above situation being the exception) but some people get lazy and don't follow
the format to the "T".
I need to require people to input the data properly each time. And if they don't, I need to send a small electrical charge to the seat of their desk chair...
Anwsers to the Problem data macro?
I do NOT recommend using multi-field primary keys. Especially in this case.
I would use an Autonumber as your primary key.
And then do an After Update check for duplicates.
If NOT IsNull(DLookup("[CaseNumber]","tblCases","[CaseNumber] = '" & Me.txtCaseNumber & "'") Then
If MsgBox("Duplicate Case Number, do you want to accept?",vbYesNo) = vbNo Then
Me.txtCaseNumber = Null
This would require that you not set the index to no dups.
And yes you can alter the Input Mask.
Use Cevin's instructions for that.
Check if there are memory problems
Memory management issues can also cause a BSOD in Windows 7. Thankfully, Windows 7 has a Memory Management Diagnostic tool that detects and solves problems related to system memory.
- Click on the Start button on the Taskbar.
- Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
- Click on Windows Memory Diagnostic Tool (in the search results).
- Click on "Restart now and check for problems (Recommended)".
- The system will restart, and you need to follow the instructions given on the screen.
Another Safe way to Repair the Problem: data macro?:
How to Fix data macro? with SmartPCFixer?
1. You can Download Error Fixer here. Install it on your computer. When you open it, it will perform a scan.
2. After the scan is done, you can see the errors and problems which need to be fixed.
3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.
Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 18.104.22.168059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.22.214.171.124 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.126.96.36.199,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: DDE no longer works on Vista [Anwsered],Troubleshoot:Default Gateway not available windows 7 64-Bit Error,d1.openx.org cookie removal from from temporary internet files cache [Solved],Fast Solution to Error: desktop icons change size when plugged into second monitor and don't change back when unplugged.,Solution to Error: Deleted the partition using Disk part now laptop starts up, it says: no media present