Search results

OK, I get it, its VBA, I just ran it in the Immediate window and it gives 202404. Very good! So this is some way I can organise my YYYYMM, correct? Writing some VBA to organise the data? The question mark gave it away.

Pardon my ignorance but where do I run it? Is it SQL or VBA? I just tried SQL but it wants an Update or Select or something, I give up what is it?

That's fantastic! It's something I can use to group my data further. That's food for thought and application. I shall study that further and play around with my data, thanks very much for that. Just a question, what's with the multiplication by 100?

Just a question, how do you combine Format with DatePart, I used it earlier but got an error. Could you help?

I see, thanks for the update Gasman!

Thanks for the response, I'm not sure what you mean with: I used datepart() access ? I looked up the link it refers to DatePart as well. Thank you.

Thanks for your quick response! OK, only one "m" that's great, no wonder I was getting the error. I've just run it and it works, thank you. I will review that link that you've added, no doubt I'll learn more about it. I'll make sure I include the SQL in my posts in future, I'm fairly new to...

I'm having problems getting the DatePart function to work. At present, when I run the query I get an error "Invalid Procedure Call". As far as I know I'm doing the right thing but obviously not completely. I've attached a picture of the QBE grid and also the SQL for the query in question...

Thanks for the feedback, I'm happy to just use it as I need it. It is a good width (Immediate window).

Thanks Gasman, I understand what you're saying. I was following instructions from a book (which I won't mention) but wound up in a mess. I think your suggestion that I use each window as required is a very sound idea. It is straight forward and solves the problem. I was starting to look for...

I've been trying to arrange the Immediate, Local and Watch windows. I thought it would be straight forward but its turned into a small nightmare. Is there any help with getting these windows arrange in the VBE so that the Code window has the most space and these windows sit below the module...

Sorry I forgot to hit the reply button, but that is my reply above (another error). I'm pretty new to the forum, been a member for a fair while but haven't gotten into Access for a couple of years until last year, so I'm learning a lot from feedback on the forum. Thanks again.

Thanks for the feedback. I was using this as a practice database, but I recognise the faults you have pointed out. It was created a couple of years ago (not too sure exactly) but I thought it was good to learn combo boxes properly. I shouldn't have numbers leading field names like "1 plus" as...

This should work: https://www.access-programmers.co.uk/forums/threads/synchronising-a-list-box-to-a-combo-box.330233/

I found why it was not working, I overlooked putting the SQL into the RowSource. It is now working fine. Is there a protocol when a thread is finished? I'd like to close this case now. I found the "Solved" button at the top of the thread and clicked it so this thread is now finished from my...

Here it is again: https://www.access-programmers.co.uk/forums/threads/synchronising-a-list-box-to-a-combo-box.330233/

Sorry, I don't know why it isn't. I copied the URL from my browser and pasted it into the post, I'll have another look at it.

I tried the example that C.J. posted and that was perfect. I have tried duplicating this into my database and it isn't working. I have attached it here.

I tried putting =[cboClarity].[Column](2) into the Control Source. My combo box is not working properly. I'll attach the file I'm working on. cboClarity is on frmClarity.

Sorry, my mistake. It is a text box, I got my terminologies mixed up. It is actually a text box. I've opened your archive Combo.zip, that solves it perfectly. That is great, thank you for replying with that example. That answers my question thanks.