Search results

Thank you! your solution worked :)

I think I mentioned it before, the data type is AutoNumber.

Still freezing out. The immediate window gave me back: 1395. This is what the number supposed to be, and I guess this is an integer (?).

You are right, it stores numbers, it is defined as AutoNumber in the table, it is the primary key. What puzzles me, is that what you wrote here is basically the same as the first solution you provided earlier this week, and when I copied that into my code it worked fine for a few hours, and then...

Sorry again for the comfusion, I expected the immediate window to be more visible, I missed it before. The SQL string in that came back is: SELECT qry_SzovetTarolas.* FROM qry_SzovetTarolas WHERE tblSzovet.[Azonosító])= '1395' When I ran it the first error was "extra ) in query expression"...

I ran the code, however, I got no error message or anything like that. The only thing that happened is that the window froze again.

Sorry, I misunderstood. I tried to copy your code but I get a compile error "Expected: end of statement".

If I just run the query on its own, it works just fine. This is the SQL View code for it: SELECT tblSzovet.*, tblTarolasiNaplo.* FROM tblSzovet LEFT JOIN tblTarolasiNaplo ON tblSzovet.Azonosító = tblTarolasiNaplo.[Szovet ID]; The strange thing is, how the suggested solution worked just fine...

Thanks for the help, I do not want to abuse your kindness, but I would like to ask for a bit more help... I have tried your solution (the second version, as I want to pass an integer) and it work fabulously! However, out of the blue, it stopped working again... I can see that it tries to open...

Hello, I would like to ask for the kind help of the community, to figure out the problem I am stuck at. I would like to run a query with a button click. Said button is on a form, from where I would like to access a new form. The second form would get the data form the formerly mentioned query...

Hello, Recently I found a bug in my database, and I cannot seem to figure the solution out, so I would like ask for your help in this matter. So in my database I have a form with a subform. When I click the save button I want the program to ask me if I want to save the changes I made, and in...

Hello, thanks for your reply :) To be totally honest, I did not do a lot of prior research on Nav Forms before I decided I want to add it to my database :/ I thought it would be a good idea to make my program more "user friendly", as I have a bunch of forms, and I do not wnat them to search...

Hello, I think my forms are working. However after I added one of them (Only the the one that is like a Main form, where the other forms are linked to it) to the Nav Form, I can no longer 'return' to that form on the Nav Form(with buttons on my other forms), only to "version" of the form that...

Hello! I would like to ask for your kind help in the use of Navigation Form. I have already created a bunch of forms that are 'linked together' with buttons. They work really well, but now I decided to create one Navigation form for some of my already existing forms. When is inserted the...

Thank you for your hint. But is there no other way? I am really unfamiliar with unbounf forms and how I can save records with them. I had success with simple forms (using my code above), I only can not implement it to forms containing subforms :(

Hello Everybody! I am back with a new "problem". So I am now working on form with a subform. I added a saveBtn to my main form, and I would like to only save changes made to the form or the subform if I click the saveBtn and then click yes to the appearing messagebox. I have successfully...

I think I fixed it by creating a new form , that is when loading goes to newRecord :)

Sorry, maybe my explanation was a bit messy :/ So I have this "main" form, and here i have two buttons: the add and edit. Now if I try to use the add button I allways jump to the record editing 'function'. My code for the add button is the following: Private Sub addBtn_Click()...

So now I would like to add a new button to my form, with this I could create a new record. I tried to use basicly the same commands as with the "editBtn", I set allowAdditions to True, but whenever I click ADD (even when I set close form and Openform)I go to the form where I can modify an...

Thanks! I would have never thought of this :) I do not want to abuse your kindness, but can I have one more question? It is not releated to this problem but to the form I am currently working on.