Search results

Hi Smile, To do what you like with regards to the likeness of memory buttons, you will need to create two Form Wide Variables in the Declarations section of the Forms' code module, like this Option Compare Database Option Explicit Dim MemItemName As Variant Dim MemPurchaseDate As Variant...

Re: 'Run-time error 13: Type mismatch' occurs for CreateObject("Outlook.Application") Try this......... Dim OutlookObject As New Outlook.Application Dim OutlookMail As MailItem Set OutlookObject = New Outlook.Application Set OutlookMail = OutlookObject.CreateItem(olMailItem) .

Good show Mike. The IDE (Integrated Development Environment) is the VBA Editor which you now know :)

Uhhh...I think I see what is going on here. From what I've read thus far, your Form is obviously bound to a table. You need to ensure the the Control Source property for the Employee Name is set to the Employee Name field in Table. The Same applies for the Supervisor but the Control Source...

In the Form Code module of the OnCurrent event for the Deliveries SubForm: myBoxVariable = Forms("BoxesFormName").BoxTextBoxName .

My apologies. I misspelled the Field name Status within the WHERE clause. Funny thing is....I even highlighted it blue :o No worries though, it still wouldn't have supplied the desired result. It would have changed the Column Order within the Combo. You are back to using your Query which is...

The WIA (Windows Image Acquisition Automation Library v2.0 Tool for hose that care to know). If the WIA is properly installed and Registered you should be able to see the Windows Image Acquisition Automation Library v2.0l within the IDE's Reference list. Make sure it's check marked The best...

Welcome to the Forum :) Your assumption is correct...at least that's how I would do it. Below is a Function named GetFromLinkedEMailTable (for lack of a better name at the moment) that can do the job for you automatically but you will need to call this Function from within the code that is...

If IsNull(Forms("AccidentEntry").OpenArgs) = False Then If Forms("AccidentEntry").OpenArgs = "InSearchMode" Then Me.cboEmployeeName.RowSource = "SELECT EmpID, LastName & ', ' & FirstName AS Expr1, DateOfHire, Status FROM tblEmployees;" End If Else Me.cboEmployeeName.RowSource =...

If the Form fields (Text Boxes or Combo Boxes) are bound to Table then something must be going there if there is indeed a name displayed in the initial Form itself. It may not be what you expect but there should have been something placed into table. Perhaps a number instead the Name text? What...

Let's start at the beginning here. You have a Form which is obviously displaying a partcular image where the path to that image i stored within a Table. You want to see if there is a better image so you browse the system and start selecting images to see what they look like. In the process you...

To automatically prefix already existing data is nothing new and is relatively easy to accomplish. During the process though, you need to consider the possibility that perhaps there will be three or maybe four or more identical Manufacturer Part Numbers that will be entered into the database...

Like the old saying goes....."A picture is worth a thousand words". In you case your post is missing, oh, about a thousand words :D .

You know....I'm not sure there is such an event for this sort of thing. What you could do however is either confirm that the Data was stored or disallow the use of the Escape key during the operation or both. To prevent the Escape key from being used in Form add his code to the Forms'...

Or Dim Mnth As String Mnth = "December" MsgBox Month(CDate(Mnth & " 1," & Year(Now))) If you want the Month number from a todays Date: MsgBox Month(Now) ' The Current Month Number. If you want the Month number from a specific Date: MsgBox Month(#8/7/2008#) .

This error is basically telling what the problem is. Ensure that none of the conditions the error specifies actually exist. Off hand...I would say check the Master and Child links between the Main Form and Sub-Form. Are the Record ID's the same? No...then you have a issue there. There is...

I don't quite understand what you mean by this. Do you mean you can not find the the Code modules for the two Forms? If this is the case then you will find the Code within the VBA IDE (Visual Basic for Applications editor). You can access the code editor by selecting the Form name from within...

Well Chris, you can do it either way. You can use a Filter or the Filter Property of the Sub-Form or you can use a SELECT Query either made through the Access Query Wizard or through code. I had modified your previously posted Sample DB to show how you can accomplish either way (Filter or...

In general, it's irrelevant whether the person injured works at the plant or does not however, it is relevant that a persons ID number goes into the Employees field within the tblAccidents Table since doing so allows everything to function properly since this is how the structure is laid out...

This is becuase....if you actually look at the record in table you are missing something. Guess what it is. Make sure this sort of thing can not happen. For obvious reasons, it is a necessary field. Without this information the entire record is pretty much useless (well....to some degree). I...