Search results

Exactly what I needed! You're awesome! Thanks!

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.

Private Sub Command1_Click() Text1.Value = Date() End Sub

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 used "Me.Refresh" and it worked. So disregard.

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?

That was absolutely it! I would have never figured that out. Thanks!

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

Wayne, Where is the link?:confused:

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:

Thanks. I'll let you know how it turns out. Brian:)

Mile-O-Phile, This is pretty cool! Do you mind if I use and modify the code to complete my project? I'll drop you a comment within. Thanks, Brian.:)

That would work also. I just need to know how to use it. Thanks.

I have four different test for people to take because someone could just record the answers and give them to the next person. I would like to combat that by randomly opening a different test each time. Thanks.

I will have 4 different forms based upon 4 different tables. What I would like to do is create an event or create an autoexec macro to randomly select one of the 4 forms to open (Form1, Form2, Form3 and Form4) each time the db is opened. Any thoughts on how to accomplish this?

This worked. Thanks! Brian

I want to set up a query that will include the entered date and records for the previous day. For example; if the user enters 2/2/03, I want it to include records from 2/2/03 and 2/1/03. Does any one know how to enter this into the criteria? Brian