Recent content by willknapp

It appears you're looking to have a single nested iif statement. Generally, you can format it as follows: Iif(Comparison1, Returns if Comparison1 is true, _ Iif(Comparison2, Returns if Comprison1 is false and Comparison2 is true, & _ returns if both comparison1 and comparison2 are...

Thanks Paul! I'm not trying to be sneaky or anything - I just knew that, as I was having difficulties in the Outlook and Excel arena, searching these forums didn't reveal very much. Also, I don't always get to spend as much time perusing the pages as I'd like - I often while away the hours...

Hey everyone, Just wanted to post this here - I just finished a Access project that was deeply intertwined with Outlook (generating outgoing email and scraping incoming messages, custom forms) and Excel VBA (primarily for reporting). If anyone has any specific questions regarding either...

Multivalue fields can get tricky when it comes to reporting, so I tend to steer clear of them. If I were tasked with building this system, and I understand you correctly, I would consider the following: I'd want to truly normalize this database, so I'd probably want to handle this with a...

You really take the fun out of this when you solve the issue yourself... ;)

Exactly how are your tables tied together? That is, what is the relationship between them? If your tables are tied together by the loan number - meaning the loan number is the primary key in the loan table, and a foreign key in the Exceptions table - then changing the loan number in the Loan...

I'm not familiar with the wizard you're referring to, but if you're looking to create and customize an email, you'll want to use the Outlook.MailItem object. You'll have to add the MS Outlook Reference in the VB Editor to make this available. Here's a link to more info on the MailItem Object...

Happy to be of help! Good luck.

I see what the problem is - based on the code you posted, it appears that the bound column of Combo2 is the AppLink column, not the AppName. Try this with the changes in red: Private Sub Combo2_AfterUpdate() If Len(Me.Combo2 & vbNullString) <> 0 Then Application.FollowHyperlink Me.Combo2...

Is Combo2.Value tied to AppName, or is it tied to a different ID field/value? Also - try using "me.combo2" (like you do earlier in your code) instead of "Combo2.value" - my sample code used "listbox.value" as a generic placeholder, not necessarily a literal control reference.

You can add something along these lines to the code that launches the apps: Dim db As DAO.Database Dim rs As DAO.Recordset Set db = Access.CurrentDb Set rs = db.OpenRecordset("SELECT * FROM AppLinks WHERE Appname = '" & ListBox.Value & "'") With rs .Edit !ClickCount = 1 + !ClickCount...

You could easily incorpoate a VBA procedure that would update the values for you. How do the users interact with the list box? What steps do they take to launch the apps? That is, do they choose an app then click a command button, or do they double click an app?

The SQL below uses aggregate functions to show the latest status for each machine. You want to Group By Equipment Number, showing the Max TimeStamp for that group along with the First Status Value. SELECT tblEquipmentStatus.EquipmentNumber, Max(tblEquipmentStatus.Timestamp) AS...

You ought to be able to use an aggregate query to find what you need. http://office.microsoft.com/en-us/access-help/count-data-by-using-a-query-HA010096311.aspx Scroll down for instructions for using Maximum and Minimums, which when applied to date fields, will give you the Newest or Oldest...

In the screenshot, tblStatus is a textbox control. You have to change it to a label control in order to use the Caption property.