Search results

I am trying to change the default for my checkboxes so they are not shaded. I'm sure there is a very simple solution and I'll feel silly once I receive the answer, but can anyone help? It would be greatly appreciated!

Yes I did bind it to a table

I am having issues with checkboxes not holding their value and have been told that this is a known problem that has to do with shading. How do I change my checkboxes so there is no shading?

For any others interested, here is the code to solve this issue: Private Sub List92_DblClick(Cancel As Integer) DoCmd.SetWarnings False sql1 = "Delete from Profile_Industry where Profile_ID = " & Me!Profile_ID & " And Industry_Type = '" sql1 = sql1 & List92.Column(0) & "';" DoCmd.RunSQL...

I'm not sure I understand the question so I apologize. Should I have declared a variable with a DIM stmt

I'm not sure if this will help or not but I've formatted dates using the following: =Format(Date(),"dd/mm/yy")

I have a combo box that inserts data into an unbound list box and table. This works great but I am having trouble with the deletion part. I want to be able to dbl click on the item in the item list and delete it from both the list box and table. Currently, my code is deleting ALL items, not just...

I actually solved the problem with your help by adding a line to the code: FillFields = ";Deal_Type;" Thank you so much, forgot to send the update!

Thanks, that took care of the error. However, the value in my new record is still the value from the previous unfiltered record. My filter is for "Partnership" and I am currently on record 5. I want my new record to provide "Partnership. The new record will be #7. Since record 6 is "Direct"...

When I open my form it gives me a compiler error and highlights the "Dim RS As DAO.Recordset"

I was creating a text box to work with the following, provided by the Microsoft site. I really need the value to be updated in my bound field. Also, it was providing a value based on the previous record, not the previous filtered record. If my current field is "Partnership", I want the new...

I am trying to autofill a field based on the value of a previous field on a filtered form. I think the fact the records are filtered is throwing me off. Any help for me?