Search results

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

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!!

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")

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...

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...

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 .

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

: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

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...

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.

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

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