Replies

Sounds like you may have criteria set that is limiting the records returned.

I would check this by executing the query from within the design view of the query to see if it is returning the correct records.

HTH
RDH

The best way to overcome this problem is to restart your computer in “Safe Mode” … then run Scan Disk or if needed Defrag. The problem is caused by apps running in the backgroung that is wiriting to the harddrive. When this happens, Windows detects it and restarts Scandisk.

HTH
RDH

Not sure about Oulook 98 and 2000 … but in Outlook 2002 (XP) you can alter the files that Microsoft has deemed “unsafe” via the Registery. Follow the link below for information on how this can be done.

Cannot Access Attachments – Outlook 2002

HTH
RDH

Well … that a lot of “nested” If statements. It is very hard for me to follow the logic behind your code. All of the “GoTo” statements were sending me all over the place.

The response I gave in my earlier reply was using the “Forms On Before Update” event and not the controls event. I have looked at your code for several minutes and can not get a complete grasp on what all you are attempting to do in the routine.

I normally validate the forms entries at “form level” instead of at control level. Maybe now that you have posted the code you are using … someone can come up with a reasonable solution.

Sorry I could not be more help.

RDH

Are you using the Before Update event of the Control or the Form? It would help if you would post the complete SubRoutine you are using. This may fill in the holes needed to give the exact solution.

RDH

Is there a chance that you are over-riding the settings on the form by using the acNormal argument in the code that is opening the form?

You may be using something like this:

DoCmd.OpenForm “YourFormName”, acNormal …… ect

In the example above the “acNormal” will force the form to open as a “Normal form”. You can either remove the “acNormal” from the line or change it to “acFormDS” to force the form to open in Data Sheet view.

HTH
RDH

Hmmmm ……..

Me.Undo will clear the complete entry …. I think the poster only wants to clear the single control.

RDH

You should be able to add the two lines below before you cancel the event:

Me.YourControlName.SetFocus
Me.YourControlName.Undo
Cancel=True ‘(or Cancel = -1 in your case)

(change “YourControlName” to the actual name of your control)

HTH
RDH

You are welcome ….

I was just slightly faster responding than rpwoods.

RDH

Use the On Got Focus event:

Me.YourComboName.Dropdown

Or you could simply use:

Me.ActiveControl.Dropdown

HTH
RDH

I agree that what LegareColeman has submitted will work with “no problem” ………

You can also do this without the need of a “User Defined” function by using an IIf statement:

=IIf(InStr([FieldName],”@”)>0,1,0)

RDH

This may be what you are reffering to in your post ……

The only thing I know of is the information in Access help file if you search for “order of events”. This pretty much expains all events and in what order they trigger.

Sorry if this does not give you anymore information than you already know.

HTH
RDH

If Francois’ reply does not do the trick ……. the file attributes of a file can be altered using a Windows API function:

Declare Function SetFileAttributes Lib “kernel32.dll” Alias _
“SetFileAttributesA” (ByVal lpFileName As String, _
ByVal dwFileAttributes As Long) As Long

‘ Use these constants to set the attributes you want
‘ FILE_ATTRIBUTE_ARCHIVE = &H20
‘ FILE_ATTRIBUTE_COMPRESSED = &H800
‘ FILE_ATTRIBUTE_DIRECTORY = &H10
‘ FILE_ATTRIBUTE_HIDDEN = &H2
‘ FILE_ATTRIBUTE_NORMAL = &H80
‘ FILE_ATTRIBUTE_READONLY = &H1
‘ FILE_ATTRIBUTE_SYSTEM = &H4

Public Function SetAttributes(ByVal FullFilePath As String, Optional ByVal FileAttributes As Long = &H2) As Long
‘ Makes sure that the file path is not too long

Hmmmm ……

I’ve been trying to think ….. what is “hun”?

If you are referring to hundredths of a second, then you have a problem. Access does not return this. The smallest increment for a Date/Time value is “seconds”.

You may be able to do this with code using the Timer built into a form.

HTH
RDH

LOL …. It is almost as hard to learn how to use Access Help as it is to learn how to write code in Access.

You are welcome for the help I’ve given …..

RDH