Search results

  1. S

    Need help with a running total

    added on the following now getting a Name? error =DSum("[Payment]","tblocrbackup","RecordNumber>0" & [Forms]![FrmOCRBackup]![Text22])
  2. S

    Need help with a running total

    DSum("[Payment]","tblocrbackup","RecordNumber") The above formula I have but into a control box but instead of a running total it is just summing up all the totals.... Help!!
  3. S

    Need help with creating a running total in a form. I have the following formula in a text box...

    Need help with creating a running total in a form. I have the following formula in a text box but instead of a running total this formula is summing up all the totals: DSum("[Payment]","tblocrbackup","RecordNumber")
  4. S

    Open a database within another

    Solution Okay if anyone else needs this info, i found the answer. In a macro choose the action RunApp then, in the Command Line type in the following code C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe G:\Database Location\DatabaseName.mdb What you are trying to do is launch Access...
  5. S

    Close one form and open another on oone click

    I suggest using a macro I don't know about using code but why don't you use a macro. You can create a macro using two actions Close & OpenForm. The Close action will allow you to close the first form & the OpenForm action will open the form you want. Within the Close action just select the...
  6. S

    Open a database within another

    Help! I recently used a macro to open a database within another and accidentally deleted the macro. Now i can't remember how I created the original macro...can someone please help me:o .
  7. S

    Subtract Previous Value from Next Value

    Thanks for responses Thanks guys. i didn't have much time to work on this so i just went with Excel.
  8. S

    Subtract Previous Value from Next Value

    :confused: Need help building a query that will subtract the previous value from the next value at each change in date Date Tier 1 1/6/2006 4.22 1/13/2006 4.27 1/20/2006 4.27 1/27/2006 4.314 2/3/2006 4.314 for example, 4.22-4.27 = -0.05
  9. S

    Removing CR, line breaks, and tabs from data

    Hi, I am receiving a text file out of a core system that is created with carriage returns/line feeds. When I import the file into a table a blank record is created because of the carriage return/line feed. I could delete the blank records in a query but would perfer to import a clean file. Do...
  10. S

    Removing CR, line breaks, and tabs from data

    VBA Help I'm sorry but I have never used Visual Basic in Access and don't even know where to start but thanks for your response.
  11. S

    Removing CR, line breaks, and tabs from data

    How do you use the replace functions? What I mean is...How do I right the code for this?
  12. S

    Removing CR, line breaks, and tabs from data

    How does the replace function work in order to eliminate carriage returns and line breaks?
Back
Top Bottom