Search results

Thanks everyone! It ended up working after a few minor changes using what was stated earlier. I wrote it as: If me.DeliveredDate >=0 then me.orderdelivered = -1 else me.orderdelivered = 0 end If End Sub I realized checkbox is coded as -1= true and 0 = false. Is null was not...

Ranman256, Thank you for your comment. I made the adjustment below, but it still doesn't work. The code does not pop up as "debug" which is good but the checkbox does not check. Private Sub Command582_Click() If IsNull(Me.DeliveredDate) Then 'Set Me.OrderDelivered = true End...

I am trying to have access set a field to true if another field has data. Example: If "Delivery Date" field is not null, set a checkbox called "Delivered" to true (Check Checkbox). The reason why I am doing this is client would like a progress type system to see at which stage a package may...

Welcome Kris!

Thanks! So far I am trying to figure out how to set up a Sum IF function, but I am not sure how to get it to do multiple fields.

Q1-Q17 are fields, that is correct. Also the ID is the Key field. The totals are also fields.

Hi! Thank you both for your replies. I am a bit of a noob when it comes to access so I need a bit more explanation about how to make this code. I have also decided to enclose a picture of what I am talking about. Each field should be added only within the record. I do not want to add total...

I am trying to have a field auto sum if specific values come up within a form. The form is a survey. Total all number zeros, total all 1's, 2's etc. so that I get a discrete value total for each option. Ex. Q1) 1 Q9) 0 Q2) 1 Q10) 1 Q3) 0 Q11) 2 Q4) 2 Q5) 1 Q6) 1 Q7) 3 Q8) 1 Total...

I have been able to successfully set up code to be able to add appointments to microsoft outlook based on data within a few forms that I have. My question is this however, how do I get access to make that appointment to a specific calendar on outlook. This calendar is a shared calendar...

I'm going to try my best to explain this as clear as possible: I currently have a form that only shows data based on a specific record id. I have placed a list into that form though that has multiple record ID's listed ( It's a log). How do I get a List to Filter to just the Record ID that...

Thanks Gasman! That worked! How do you protect the Field though? Much appreciated!

I am very new to access and I am trying to figure out how to build an expression for one of my fields. I have a field called Order Date, which holds the date of when an order is filled. I then have another field called Fill By Date. This new field I want to be 2 weeks after the Order Date. Is...