Search results

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...

I know this is off topic but could you explain a little further about the prevention or provide a link, anything for me to look at really. I see exactly what you mean, I've ended up putting more code in to hide error messages etc.

If they choose a month/year where there is no data then I've used the following to show an error message. Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data for this report. Canceling report..." Cancel = -1 End Sub

Fantastic, it works! Thank you so much, the end user are people who aren't computer literate so the easier I can make it, the better for them and myself. You mentioned it needs changing so they can select the year aswell, can you help me out with this aswell please, I know a bit but obviously...

Hi all I have a form where you select a customer, then type in the first day of the month you require and again for the end date. The problem is the user has to know how many days there are in the month which not everyone can remember. It's also a long winded way. I have an idea but not sure...

Hi, This is my first post here so I'm hoping it's in the right place. Basically I have a Access application that I need to distribute to different customers, at present there is nothing stopping anyone from copying & pasting the file and editing whatever they feel like, stupid I know. What...