Search results

OK, I think that you will have to use the before update event of the form and the built in cancel of this event. I have put it into your example for you to have a look at. Steve

try this Sample by Pat Hartman

Originally quoted by Paul Young This should be =[CurrentAccountTransactions].[Form]![TotalDeposits] Try that. Steve

Ally, The before update event should only fire when the record is saved ?? eg when you manually save it or if you go on to a new record. Am I mistaken about this? I have attached a little example for you ... it seems to do what you want. I have set it up so that field 1 is the required...

Ally, You would need to do this on the before update action and use the cancel feature to stop the record saving in the first place. That should do it i think.

Yes, Create an ubound text box on a form and put the code under this 'current' event of my form: Me!TextBoxName = "Record " & CurrentRecord & " of " & Me.RecordsetClone.RecordCount That should do it. Steve

Ally, Not sure why you need to disable the x on each form if you are using this code as it will not close the form anyway. Have a look at this example as I can't quite grasp exactly what your problem is with your database this may help. Steve

Wayne, Not sure where exactly to put that. My SQL for the report is a little more complex and i am not sure how to add that in. Not sure if that will help you.

I have a report that list clients that are about to enter a clinic ... this report is printed off and given to the advisor at the clinic. The problem is that people just have a habit of turning up when they are not booked in. So ... what i need to do is have a couple of blank boxes immediatly...

Thanks Cheers Mile Thats exactly what i was looking for.

Can anyone tell me the code needed to open a different database. Basically i just need to run this from a command button so that the users can open a different database. i have tried the Call Shell("C:\test\play.mdb", 1) but i assume that it only works on exe files or something because i get...

Thanks Thanks Rich & Pat. Works fine now. Also VenueID is the PK so it will always have data in it. Cheers Steve

Hi all, I am trying to get my database to do an archive ... the actual archive bit of the database works fine so no probs there. The problems begins when i am trying to tell the user what is happening. i have this code. Dim DateForArchive As Date Dim NumberForArchive As Integer...

Not Sure I'm not sure if this is the way to do it but ... Have you tried putting something like this on the calendar form. Private Sub actlCalendar_Enter() Me.actlCalendar.Value = Date End Sub Steve

It is because of the on lost focus event that you have. Private Sub Album_LostFocus() Call Album_AfterUpdate End Sub Why do you need this bit of code. Anything that you put into this field will run the afterupdate bit anyway. Just delete the lost focus event and it will work fine. Steve

I am just trying to get your example to work first.

My first form ? Call fSetAccessWindow(0)

i am using Option Compare Database Option Explicit Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const SW_SHOWMAXIMIZED = 3 Private Declare Function apiShowWindow Lib "user32" _ Alias "ShowWindow" (ByVal hWnd As Long, _ ByVal nCmdShow As...

Run Time error I am getting a run time error. I am getting this error message here Sub sPrint(strReport As String, Optional booNoPreview As Boolean = True, Optional strFilter As String = "") sPrint_Init strRepFil = strFilter DoCmd.OutputTo acOutputReport, strReport, "Snapshot...

Just a though. If i install this on someone elses computer would they have to download the snapshot viewer also?