Search results

@Brianwarnock: Your solutions also works, I just tested it. But the looks for the last used cell in the whole worksheet and not in the special are A to C ;)

@namliam: Thank you for your code! It works well so far. I'm just curious.. if you say Range("A1").select, how does he know he should use the range from A to C? I ask because you said it will not differentiate between A,B and C, but somehow.. it returns the row number when I write something in...

@Rx_: Thank you for your answer and your help :) This is a basic table I want to apply my code on: As you can see in C9 there is one cell with a '1' written in it. So this is the last used cell in my range A to C. And I want to find the line, in this case line 9. So he should go down in...

Hello, I need a little help very quick, I couldn't solve this problem on my own: I want to find the last written cell in the range A2:C700 using VBA and store the line number in a variable. I already have something like this but it's only for one column and not a range: lastcell =...

Hey, thank both of you for your answers! (and sorry for my late reply) Actually I should have waited one night and should have taken counsel with my pillow :rolleyes: It was the problem with the SQL statement and the next day I found the solution by myself. Actually so simple but I missed the...

Hello community, I need your help very quick. Actually my problem is pretty easy but I've been trying to find a solution for hours now and can't solve it. That's way I need your help very quick. I want to update a table called tblFinalOrder, that looks like this: In particular, I want to...

Thank you for your answer, Uncle Gizmo. I'm curious, how would I modify my table to take advantage of Microsoft Access? I'm still new to Access :/

Actually I wanted to update all columns at once. I could write one for one column, saying like: UPDATE tbl1 SET c1 = 0 WHERE c1 ISNULL; But I have like 20 columns in my table ;)

Hello, I have a small problem: I have a table with over 20 columns. In every column there are some 1's, but the other cells or tuples are empty. In these empty cells I want to write a 0. So I need an UPDATE query. But what should I write for the WHERE condition? So he should check every cell...

Ok perfect, I got it now :) I had no idea about this "mmmm" but after playing around with it I only need 3 m's :D So my final code is: SELECT sapOD_orderDate, Format(sapOD_orderDate, "mmm")&" "&format(dateadd("yyyy",abs(month(sapOD_orderDate)>=10),sapOD_orderDate),"yy") as sapOD_month FROM...

Thanks a lot, CJ_London for the code. I could have never made this by myself, it looks complicated. The FY looks great, but I'd like to make some adjustments to the month. I know that in VBA the function MonthName(Month(A), True) outputs Jan. So I need this and the year like 15. Is this also...

@CJ_London: My fiscal year 14/15 starts at October 1st, 2014 and ends the following year September 30, 2015. And it should be future-oriented ;) @namliam: I'm building a database for my boss and I'm rebuilding an actual order by the help of the table.. so he wants me to do it :D It's part of...

Hey namliam, thank you a lot for the code. I'm trying to work this out, this is indeed helpful for me.

Hello, I want to build a query that calculates the fiscal year and the month from a date on-the-fly. I tried to do it in VBA, but it's more complicated than in query I guess. So this is my table: The date is on the left, in the middle I want to have calculated Jan 14 and on the right I want...

So I found my own way to display my form as a popup. First you need to go into layout mode, adjust some settings for the form (like popup = yes, bound = yes, border type = changeable, cutting line = no, scrollbar = now, and some personal adjustmensts). No it looks like this: Thanks all of you...

Thank you for your answer. After deleting WindowMode:=acDialog it copies the value. But how can I open this form in something like a popup window (like on my picture)? I need a window mode and not the full screen.. Can I set the borders somehow?

Hello, I have a small problem that I can't solve and I'd ask you for your help. My problem is that I want to copy the value of a text-field of form frmSnippet into another text field of form frmChange. But this is not possible, Access tells me that it can't find the form frmChange. But it's...

Some thoughts to your thoughts: 1. Honestly.. I don't know if my relationships represent what I want to do. I mean I know why you have relationships, the meaning behind it. But I think that I don't really rely on them. Further down I'm going to explain what I want to do in my db. So right now...

Hey Ranman256, thank you for your answer :) Hm, I guess I didn't express myself correctly. So I was thinking of an If clause, something like with a check box: If optionKR.Value = True Then sqlKR = "SELECT sapmat_materialID, sapmat_aemenge " & _ "FROM tblSAPMat " & _...

Hello community, I have a problem I want to solve but I don't know how to properly do it. I already learned here that I can alter a SQL string by typing something into a text box and reading out the content (mySQL="....WHERE (" & strDetec & " is null..) But what I want to do now is: I have 6...