Recent content by LinusIT

That's just what I was looking for ChrisO, thanks for taking the time in writing that for me. I'll go through my other forms and tidy that Print/Preview VBA up as well now :) Cheers

Thanks to the help from the users on here I now have a working form that shows when a customers MOT is due based on Month Buttons. There is a report that prints MOT letters using the data from this. In order to print the letters you have to select a tick box for each customer you want to send...

Excellent, I have applied that code and it works great, thank you!

The information in the database is only dummy stuff that I've typed in through testing various things. I can't upload it onto the forum. Thanks for all your help with this

I have previously tried both but have just tried again to be sure and neither have worked. Both methods bring up the box asking for the value of cboYear. The only reference the combo box has to cboYear is set under the "other" tab and "name" value of cboYear.

Value List: 2010;2011;2012;2013;2014;2015;2016;2017;2018;2019;2020 Bound Column = 1 Limit to List = Yes When you press September (my test button) is asks for the value of cboYear, if you enter 2010 then it works perfectly. It just isn't reading the value of cboYear

Anyone have an idea for this? The CInt(Me.cboYear) didn't work (not exactly clear above). I don't know what else to try.

On your subform set enabled = no using the form properties then using VBA somewhere through your parent form, use: Me.objectname.Enabled = True

My programming skills are somewhat limited and I'm wondering if there is a better way of writing the following? I'm just interested to learn and make better code :) Private Sub Preview_Click() On Error GoTo Err_Preview_Click If IsNull([AccountCustomer]) Or [AccountCustomer] = "" Then...

That hasn't worked, thanks for the suggestion. When you select a year and then press september it brings up a box asking for the value of cboYear.

I have a similar problem with a different form now but along the same lines so didn't want to start a new thread. I have a form with Jan - Dec buttons, these apply a form filter based on what button is pressed. I'm trying to get the buttons to work using the same concept as previously...

Cool, that's great. That's 1 problem sorted. Any ideas on the "Can't save record" issue.

Hi I have a form which is used to enter car parts, the form has a Save button and the X at the top right hand corner. I have the following code in place to make sure the user enters the required fields. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim msg As String, Style As Integer...

The month and year combo boxes are just lists, they don't use queries at present. Can anyone help with the SQL for the date combo box. At a guess it would be something like: select saleID, date from t_sales where custid = me.accountcustomer I know that the above is far from correct but...

Thanks Rich, that's pretty handy. Doing it this way would only populate the combo box with available data based on the months :) Next idea but again, don't know how to code. You select a customer from the drop down menu, then it populates the Month & Year Combo boxes with whatever data is...