Search results

Galaxion solution worked like a dream. Really really simple and without involving excel. Thanks guys for the effort!

Hey guys! I have spend last 8 hours trying to get this done with just one button, but without success. Searched all over in previous posts, but didn't get clear answer to what i am looking for. Now I am max confused. I cant understand the difference between OutputTo and TransferText in...

Hello! I have made secured database, which means only way how to open it is through that .exe file which in target includes security file and .mdb file. I have made several user groups and i have made myself as admin of course. Problem is that I'm unable to edit macros cause I keep getting...

Did like you said and everything seems to work normally now :) I made that sum formula in my subform footer, but when I am trying to get it out on main form using just ordinary textbox im getting #Name?. But rest is great, thank you a lot! Found my mistake about textbox aswell. Nice! Thanks a...

Hmm I was about to try it, but when I inserted my subform in main form, I'm getting error message about "unable to communicate with Ole/ActiveX" and even when I deleted subform, main form becomes unusable and i'm getting the same error message on every button click :( edit: i managed to copy...

Hello again! This time I have to make subform based on query, but I am interested in just these values where field value meets with one of my form fields. Idea is that I cant make separate qbf, but I have to implement it in my form. No idea how can I achieve it. Maybe you can suggest right...

Probably this is for another topic, different sort of thing. It says: This error has the following cause and solution: A line label or line number is referred to (for example in a GoTo statement), but doesn't occur within the scope of the reference. The label must be within the procedure that...

Ok this solved the problem, but now im getting "label not defined" CurrentDb.Execute "UPDATE body SET body.[VIN] = """ & Me.updatevin & """," & _ " body.[CMR] = """ & Me.updatecmr & """," & _ " body.[TR rekina datums] = #" & Me.updatedatums & "#;" p.s. Before like half a year I was realy close...

My situation for now: Just form with 3 textboxes * "updatevin" ( Key in table). All fields are filled with this value. This value will be just pasted in to somehow point at needed row in which one I am interested in. * "updatecmr" just number which will be similar for multiple VIN's *...

I Was away from work this week, so now I will try to finish this :rolleyes: For what I am not still clear is how to manage that VIN search, Just combobox or simple textbox. Input method will be paste it in. And how to point right row where to put these 2 field changes in.

Not Like [tbl_hardware]![Owner] seemed to be right answer, I opened my query in sql view and there was clearly something wrong with tables ( that _1 thing ) I fixed it and everything works great now. SELECT tbl_hardware.Hardware, tbl_hardware.[Inv number], tbl_hardware.[Serial Number]...

I tried Not Like "[tbl_hardware]![Owner]" Not Like [tbl_hardware]![Owner] Not Like "Owner" None of these worked, I have same layout as in your sample.

Hello! Let's imagine that I have 2 columns in my table "user company" and "owner" This time I am trying to make query which shows only these rows where "user company" and "owner" doesn't match. I came up with something like this obviously: [tbl_hardware]![User company]<>"Equal to...

Nice :) But what about that bound to VIN ? I just cant understand how to target right row, just found out that VIN searching will be by wildcards, last 6 digits or so. Thank God my working day is over, I will continue tomorrow. Mailman, Your effort is realy appreciated again. +100

Ok, i thought under query is something more complicated :) What I don't understand is how can i bound this query to row which i have to change, As i understand i made combobox bounded to table with all 3 my interesting fields. Ok, I understand my 2 field values in code, but what should i write...

Yep, I could do that. Well you mean just make empty update query with related fields, since update part should be custom from code

I can see how it works, but I'm afraid that my skills won't be good enough for that update query button, sounds like Chinese to me

I know :) I am at the same state, You see entering process is just copy paste from another system. What if there would be form with my 3 fields and 1 button. I write values what i want for date and quantity. User just paste ID ( VIN whatever how we call that scary number ) and presses update, in...

Hmm subform would mean same horrible effort with updating them im afraid. You see my "ID" like I called it just to explane - actually are VIN - car chassis numbers ( 17 digits ), so range is not what we are looking for this time. It will be like 10 car update "combo" per hour so export import...

Hmm listbox probably will die cause there are over 5000 Id's Hmm so I should make it based on just normal form then.