Does anyone know why I'm getting a #REF! for this formula?
=SUM(OFFSET('[HugeReport.xls]DMR'!C15,0,COUNT(15:15)-7,1,7))
I'm trying to calculate the last 7 rows of data in row 15 of an external excel doument.
Thanks for the response Joe. I looked at this program but could not get it to work without connecting a Signature Pad. I would rather write on my screen. I wonder if the code could be edited to not look for the external Signature Pad?
I have a TabletPC and would like to enter signatures or initials into a table via a form that I can write on. I do not want to convert the handwriting to text. I've used to Microsoft Ink activex to write on the form but cannot get a field to equal the contents of that activex control. Does...
I have a control on a form where a user inputs a number then presses enter. The AfterUpdate event prints a report. The problem is that it prints the previous record each time its updated. I want to print the current record. Maybe some type of requery before the event happens. Any ideas?
Thanks for the reply! I should have specified that I have a form with 11 Command Buttons. Ten are Command1, Command2....and so on. I want the 11th Command Button to tab through the 10 buttons.
I want a Command Button on a form to move to the next Command Button. I basically want to do the same thing as the Tab button on my keyboard. However, I do not want to use the keyboard.
Wayne,
Thanks for the reply. Here is what I ended up using.
varReturn = Shell("C:\Program Files\Microsoft
Office\Office\msaccess.exe ""C:\My
Documents\Test.mdb""", vbNormalFocus)
Thx, Brian:)
Does anyone know the vba to open a particular powerpoint presentation from access? My path would be "C:\TestDb.pps". I would also like to close access on the same click. I think it would be application.quit.
Thanks, Brian.:confused: