Search results for query: *

cavery: 1) Nope. You can run it from code, or on an event, or timer, etc. by calling the function. 2)As it's written, it should go in a module and can be called from anywhere in the DB with EmailUsers(), but you can transplant the code (all but the function declaration) anywhere you want. 3)...

Give this a shot ( quick and dirty, not tested). You'll need to define FieldName as somthing meaningful. Public Function fMakeTable (SourceTable as String, DestTable as String) Dim dbCurrent As Database Dim rstSource As Recordset Dim I as Integer Dim FieldName ‘Create Destination Table...

Have you tried specifically requerying the box, as in Me.MyComboBox.Requery or Me.MyComboBox.Refresh? This should be run each time a button is clicked, either by putting it in each button's code, or in a ubiquitous Form or Detail event.

OK- I'm dyin' here. All I could find is "manualy cut-and-paste, or use a macro"- there must be another way. Anyone?

tpowers: That's for cavery, from earlier in the thread. Sorry for the non-sequitur, but I figured I'd throw it out there.

Another possibility, if your qMinDate and qMaxDate queries are as simple as they sound, is to use the DMin and DMax functions instead of these queries, as in: BETWEEN DMin("[Date]","TableName]","Min Criteria If Any")AND DMax...

You can trap errors using: On Error Goto errHandlerRoutine Then, in your error handler, you can use the Err object to identify diferent errors, as in MsgBox "Error number " & Err.Number & ", Error Desc: " & Err.Description or like With Err Select Case .Number...

cavery:Lotus Notes question Here's a Lotus Notes email routine. It requires that the user be logged into Notes, otherwise it prompts for the password. Enjoy. '************************** Public Function EmailUsers() Dim Session As Object Dim db As Object Dim doc As Object Dim rtf1 As Object...

'I'm not sure this will count directries, but it should give you a file count. Set .SearchSubFolders = True to count into subdirectories. '******** Public Function FileCount(MyPathname As String) As Integer With Application.FileSearch .NewSearch .LookIn = MyPathname...

If by 'Import' you mean 'display an arbitrary image file from disk', you can set an unbound object control's SourceDoc proprerty from VB, like MyOLEControl.Class= "Imaging.Document" MyOLEControl.SourceDoc="path\filename.jpg" As for thumbnails & enlarging, it's been my...

I have a little app that allows users to store images in OLE fields from an image capture program by way of the clipboard. My problem is that once they're stoerd- as [Picture] objects- I can't seem to export them to Excel, or convert them to another format (BMP, JPG, etc.). Any advice?

howsvamp: JeremyNYC is right. Assuming your 5 tables have the same fields, just create one table, and add a field called [Area]. You can then filter what users see with no less security risk than the 5 tables method. And, your data entry form design will be a breeze. And, you won't be kicking...

I have a little app that allows users to store images in OLE fields from an image capture program by way of the clipboard. My problem is that once they're stoerd- as [Picture] objects- I can't seem to export them to Excel, or convert them to another format (BMP, JPG, etc.). Any advice?