Search results

  1. I

    Complexity of United States tax code

    I neither said nor implied that it was easy to change what you do to earn more; I know because I did it. I know first hand what it is like to dig holes in the rain, stack firewood in the winter with holes in my boots and to eat oatmeal for my only meal every day for months at a time. I...
  2. I

    Complexity of United States tax code

    The general tone in the response here seems to be that the "rich" have some responsibility to spend THEIR money to support the poor. You are all wrong. There is no responsibility for anyone to expend any resource that belongs to them against their will. If you are poor / broke / not making...
  3. I

    Send Email After Entry From Data Access Page

    If you can call a script use the vbscripting method. Below are snippets of a script I use to email reports. 'Email: 'Verification Email: Dim objEmail Dim strEmailFrom, strEmailTo, strEmailSubject, strEmailMessage, strEmailCC 'Email: Set objEmail = CreateObject("CDO.Message")...
  4. I

    Complexity of United States tax code

    I support a flat tax. Tax at the same rate for every dollar earned regardless of how may you earn. When everyone has to pay a fair share of the burden, the class warfare waged by our current tax system will die down to a low roar and incentive to produce more will go up.
  5. I

    Microsoft Scripting Library in VBA Code

    "Microsoft Scripting Runtime" is included in the references list for Access 2007. "C:\Windows\System32\scrrun.dll"
  6. I

    parameter query Retrieve data BETWEEN two dates

    Add AND BETWEEN [Field] and [Field] to your WHERE Clause.
  7. I

    Any Ideas?

    Try to decomplie then recompile the VBA. Here's how: http://support.microsoft.com/kb/819780 An update to VBA may also be in order. Get it here: http://www.microsoft.com/downloads/en/details.aspx?familyid=DA1A7ABA-CD3D-458B-9729-AB9094C9BD3F&displaylang=en
  8. I

    Weird XP startup problem

    Re: Weird XP startup problem Could also be construed as being a little bit naughty, if you were of that ilk - but then none of us are are we? Any tool can be mis-used. I am not in any way supporting piracy or abuse of licensing. I did not interpret your comment to be accusatory, I simply...
  9. I

    Weird XP startup problem

    You may run into an activation problem. It took me a while to find my notes on this but these instructions will help reset the activation timer so you can log in the machine and set up any drivers that may be missing, like the network card which is needed to activate Windows. Reseting the...
  10. I

    Weird XP startup problem

    A repair installation would also do the trick. Here's how: http://www.microsoft.com/windowsxp/using/helpandsupport/learnmore/tips/doug92.mspx
  11. I

    Transactions & Calling outside procedures that affect data

    Thank you for your Response DCrake. Through through trial and error, I found that I can execute the code as desired with the outside procedure included within one transaction. I had to make a change in the execution methods I was using. Original code was DoCmd.RunSQL With the transactions...
  12. I

    Behavior of the "Enter" key on textbox

    Change the EnterKeyBehavior Property on the "Other" Tab to Defult instead of new line in field.
  13. I

    Adding "All" to a SELECT DISTINCT combobox

    It has been my experience that users like to see the "all" in the filters so they don't have to guess.
  14. I

    Transactions & Calling outside procedures that affect data

    I need clarification on how transactions work. I have read: How to use Transactions http://msdn.microsoft.com/en-us/library/bb243806(v=office.12).aspx. I understand the steps involved but I would like clarification if possible. I have a routine that updates a master price book entry that...
  15. I

    Adding "All" to a SELECT DISTINCT combobox

    Try using the Form_Open() event instead to update the list.
  16. I

    For all you space enthusiasts

    How long until the Obummer administration outlaws quasars over concerns of Blobar warming?
  17. I

    Export data + backup

    Here is a reference from MSDN regarding XML exports. Using this method should allow you to provide custom naming of your files by programatically creating a string. I do this with daily report files with a date stamp added to the name of the report. I realize it's not utilizing what you...
  18. I

    how to build this???

    Write a macro in the database to open a form filtered to the date you want. Use a batch file to run the macro through a scheduled task. The syntax for the batch file command is: "[Drive]:\[Path]\[database]" /x [MacroName] Example: "C:\Scripts\DailyInfo.accdb" /x Run_Daily_Reports"
  19. I

    Adding "All" to a SELECT DISTINCT combobox

    Use your rowsource query as a recordset instead. Loop through the records to create a string of values. Add "All" to the beginning by initializing the string with it or adding it to the end. The question then becomes, what do yo udo when the user selects the all option? Example: ( I...
  20. I

    A tricky calculation (maybe)

    You could use a complex calculation in the data source employing a dlookup statement. [Used] = [Total (Yesterdays number)] + [Made] + [Received] - [Total (Todays number)] Replace [Total (Yesterdays number)] with: Dlookup("[field]","[table]","Where [condition] = [value]")
Back
Top Bottom