Recent content by Birrel88

I edited the code, and removed the array. Makes it much simpler and less code. Thank you ! Final code: Private Sub Form_Load() ' Disable month cbo and open report button Me.cboMaand.Enabled = False Me.cmdOpenReport.Enabled = False ' Place all years from 2018 into the cbo Dim intCounterJaar As...

You are right. Now I see this it makes it so much simpler. There is no reason why I put in in an array first. I think it's because when looking for a solution I first came on a website where I learned how to put things from an array in a combobox. After that I looked up how to out things in an...

Well. It seems taking a shower and smoking a cigarette helped getting my thinking process activated again. Got a revelation and after looking up how to do it, got a solution that works (hopefully) for now and the future. Ditched the table with the years and months, and put up some vba code to...

Thank you for the quick reply. The reason why I don't choose for 2 date formatted textboxes and pick a range is that I want the program to be very easy for the user. I want the user to just select a year and a month. Not pick a daterange where it is also possible to accidently pick a range from...

Hello there, I hope someone can help me with this issue. I trief solving it myself but I can't figure out how to do it. The problem: I have a report which shows monthly income made from different customers. When you want to open this report, you go thru a form. This form consists of 2...

Have you considered the possibility, that the first link wasn't clear enough? I did read, but couldn't find the answer. The second link is a bit clearer for me, and after knowing the answer now, I see it is in the first link. And so you tell me, because I don't know one thing (dates), I don't...

Thank you for the reply. The solution worked perfectly. The article you provided, it is very helpfull and especially very easy and clear to read. Definitly word a bookmark.

So, I did some research on the code. And this is what I came up with. First of all, I have a Union Query. This query gets data from a couple of tables which hold information about customers, combined with the date they showed up and the expenses they have made. This is working absolutely fine...

Thank you for the replys. I asked before I triple checked because maybe there's a simple thing you have to do with this case. Tomorrow I am definitly going to triple check my code with th3 handout you guys have linked I am not using a particular date in my code, only the input from. A textbox...

O, im sorry. The issue is that the check, of a record already exists, doesnt seem to work on the dutch version. It assumes a record doesnt exists, while it does

Possible Multi-language problem [Solved] Hello, I have encountered a problem with my access program, which I think could be a language problem. I am creating a program on my computer. This computer is set to an english language (both windows and office/access). The program itself is for a...

Hello there, I encountered a problem after I tried to fix an annoying bug in my program. I hope you guys can help me out with this. Setup: Mainform INCOME is setup with a couple of controls where I can select a customer and put in stuff like cash money and date. Next there are a couple (3)...

Really, that simple? :) Thanks, it is working now. So, what you are saying is that the problem is that the fieldname start with a number? And with putting the square brackets around it will work (obviously) So I think a better naming convention for fields will be not starting with numbers?

Hello there, For this question I searched alot on the internet. And I stared hours looking at my code and form design to find what was wrong, but I just couldn't find it. So hopefully you guys can help me. I have 2 forms. Form 1: frm200Groep - It shows a Continuous Form of the table...

Hello there, Im designing a database right now. And one thing I like to do is view a couple of days from a google calendar on the main form. I tried a couple of things, some which work better then the other but there isnt one perfect. The thing is, almost everything the company needs to manage...