Search results

I have a data entry form, that when a user hit's the "Add Record" button, the data is populated into a temp table, and then the subform is requeried showing the user the record that they entered. On the main form, I have the item numbers hidden and the item description shown so the users can...

Thanks, yes I saw your link. However, I just don't understand the logic when doing a compare across two columns. All of the examples I've seen, including in the link, are based on a single column. I don't understand how to go from one column to a multiple column compare with a case statement...

I'd do a select case statement, I just don't understand the logic when doing a compare across two columns. All of the examples I've seen are based on a single column, with small results, as you can see this is a little more complex then that. With no reference, I'm not sure how to do it. I'd...

I got the IF statement working as expected. status_id: IIf(([effective_date] Is Null And [inactive_date] Is Null),"Pending Approval",IIf(([effective_date]<=Date() And [inactive_date]>=Date()),"Active Enforcement",IIf(([effective_date]<=Date() And [inactive_date] Is Null),"Active...

I'm not inserting it into the table, just presenting the value through a query based on a two field calculation. I don't get how the case statement works in a query to do what I'm trying to do with determining a values base on a number of combinations on two field. Sorry, just a beginner with...

I'm really close. status_id: IIf(([effective_date]=Null And [inactive_date]=Null),"Pending Approval",IIf(([effective_date]<=Date() And [inactive_date]>=Date()),"Active Enforcement",IIf(([effective_date]<=Date() And [inactive_date]=Null),"Active Enforcement",IIf(([effective_date]>=Date()),"Future...

I'm not sure how to write a select case statement in access. Would that let me do the compare between the two field and let me insert a value based on the results?

I have a complex if/and/or calculation formula in Excel that I want to convert into a query for access. The field names in Excel and Access are the same "effective_date" and "inactive_date". The new column is named "status_type". I've tried all kinds of conversion, and I just can't figure it...

Figured it out. So I'll post it incase anyone else needs it. Private Sub Command21_Click() Dim ctl As CommandButton Dim stMachine As String Dim stShare As String Dim stLink As String stMachine = [Forms]![Lookup]![ComboBox1]...

Sorry, this is probably a very basic question, but I'm new to access programming, and I'm stumped. I have two ComboBoxes on a form that I want to generate a hyperlink from, and then when I hit a submit button, it opens the file in the link. I just can't figure out how to finish off the code...