I am trying to transform the following code into SQL Trigger, if any can help pleasse send back to me. Function UpdatePeriods() Set dbs = CurrentDb Set ctr =...
I've no knowledge in creating triggers, but your code can be simplified quite a bit (this will surely help when creating the trigger). Function UpdatePeriods()...
There's an error in the code. I forgot a close paren in the line ctr("M" & i+1=... It should be ctr("M" & i+1)=... I've no knowledge in creating triggers,...
... Very easy. ... Very easy if you understand how to create reports. ... You will not need any VBA code to do the 2 above tasks. Neil Squires ===== Neil...
I prefer to trap all errors before they occur. An example follows. dim num1 as double dim num2 as double dim answer as double num1 = 7 num2 = 0 if num2 = 0...
As a side note there is a large execution time difference between the following 2 lines of code. if (me.txtUserString = "") then and if len(me.txtUserString)=0...
Beth You might want to take a look at the Time and Billing database in the database wizard. I use a modified version for my business. You would need to add the...
If you've disabled the shift key bypass (Holding down the shift key while opening a database will bypass the startup settings) through code, you can download...
Thanks Bill! I am not charging by the hour just yet, have a loing way to go for that, so I used one from 97 and converted that has order entry. That way I...
Huy Regarding the question "how easy is it in Access to calculate a sum/average of donations?" It is possible to do lots of thing within the SQL behind the...
ok. looks like just bypassing the calculation if the divisor ends up 0. I took the first suggestion and did a IIF to pull out the calc based on the ...
From http://www.microsoft.com/AccessDev/articles/outprog.htm Regarding Access 97 and there is a sample download on this site: Creating Outlook Items from Any...
Hey all, I know there have been discussions in the past about reduced network performance or other speed issues, but I've encountered something that seems to...
After posting I remembered the /runtime switch, so I went ahead and tried it. That definitely made all the difference, now the machine is flying much faster...
Okay now, you are getting like Beth and answering your own posts. Just kidding. LOL Craig Williams Static Control Components Inc ... From: Daniel Koster...
Craig Williams
CraigW@...
Jan 2, 2004 11:34 pm
11231
You might try turning off all the subdatasheets for all the tables. This code will do it: Function TurnOffSubDataSheets() Dim MyDB As DAO.Database Dim...
Craig - And what's so bad about that?!? :) Btw Dan, I would think that a full version would run slower than a runtime as it has to load more 'stuff' whereas...
Another option that may speed things up is to compile the db into and mde. This will shrink it by possibly half it's size, and optimize the database's ...
Happy New Years Dev's I'm attempting to develope an app that allows work orders (access form currently) to be put on an outlook calendar. Is there a way to ...
It is possible. First look at http://www.slipstick.com/dev/vb.htm and then there is an example of how to add an Outlook Appointment (Calendar addition) at...
When I am done working in frmCustomerList I want to return to frmCustomers. I use the following code, which works well to open and filter the frmCustomers to...
Thanks for all the feedback. I will definitely turn off all the subdatasheets. I'm not going to mess with an MDE though because I would have to change the...
Dan, I don't know if this sheds any light on the situation, but we have an individual at our office with the same issues accessing dbs on the network. I can...
(This tip refers to Access 2000. It will work for most versions of Access, but some of the steps might not be the same for all versions.) When you are...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
