Search results

Access '97 Open a report in Preview. You will have 4 ways to "Close" the report. 1 - File/Close 2 - The 'X' on the FAR right upper corner (This is the Window's 'X') 3 - The 'X' on the NEAR right upper corner (This is the Access 'X') 4 - The word 'Close' on the Print Preview Toolbar If I...

Sounds easy. Actually, it is. That is, when the user closes the report with the 'Close' button. But when they close the report using the 'X' in the upper right hand corner though.... Here is the code I have in the report's Close Event: Private Sub Report_Close() Dim stDocName As String Dim...

Great !! I was just passing through and must tell you guys THANKS for unknowingly giving me the best laugh I've had in a loooonnnng time!! When I came across the subject line: Shrink My Package to a Smaller Size that was funny enough to get my attention. But the reply: Not that I would...

Syntax: DSum(expr, domain[, criteria]) expr = An expression that identifies the numeric field domain = It can be a table name or a query name =DSum(Hrs ,queryname)

This usually happens here when the network that the db resides on doesn't have much disk space. This is one possibilty.

I just love the internet Thanks for letting me know "u" is a vowel. **sigh** If I followed the thread as I thought I did, Rich: a (first vowel) me: Big E inside of an I (that's a,e,i so far) Rich: o mrabrams2 (me) : U that would make it a,e,i,o,u Now that all the vowels were taken...

consonants anyone?

I must have used invisible ink yesterday.

For Each fld In rst.Fields If fld.Value = Null Then MsgBox "null record" Else End If Debug.Print fld.Value & ";"; Next Debug.Print How about: For Each fld In rst.Fields If IsNull(fld.Value) Then MsgBox...

Why I believe you would need to do your calculations through a query. If you explain why you need to do this in a table, we could help a bit more. Michael

You're not kidding! Whoa! That was a bit wordy :D - but very well explained. Thank you for the link !! Michael

Not a big deal - I am more curious than anything. I have a simple import spec. Imports a text file into a pre-existing empty table. The first field in the table is RecNum (not part of the text file). Most of the time, after I import the file and check the table, the table is in the same order...

Ssshhhhhh.... don't tell anyone. Guess who spelled these English words wrong? perminent (permanent) retreived (retrieved) pritty (pretty) tryed (tried) disscusion (discussion) myrical (miracle) Repetative (repetitive) Man, 9 0r 10 posts and you're putting someone down for poor English...

Someone got the sack? Michael

Credit Just to set the record straight, the Prevent Mouse Wheel solution, is credited to a gentleman named Andy (Accessman) from Indiana, with help from another nice guy from England named Rory. Both posted/worked on the code on another board a while ago. *I will place a disclaimer in future...

I tried to attach the VBA332.DLL file (zipped) but seems that it is too large. The VBA332.dll file should be found at: C:\Program Files\Common Files\Microsoft Shared\VBA Suggestion: If it is not located there, try: 1- Do a search on your machine for the VBA332.DLL 2- Go to another machine or 2...

Here is one This has worked for me for over a year now. It works in Access 97, but I cannot tell you if it works in 98 +. Michael added 6-26-03: Just to set the record straight, the Prevent Mouse Wheel solution, is credited to a gentleman named Andy (Accessman) from Indiana, with help from...

:D Simple !? Thanks - I will break that one down too so I can understand it and use it properly in the future. Pat & Jon - Thanks for sharing your time & knowledge. Michael

All I can say (after shaking my head) is THANK YOU very much. It works wonderfully - now I need to study it and learn. JonK - Thanks again. Michael