Search results

Like the title of this post...strange... It was true only one table was reconnected and thats why the problem started. But when i check it for the first time it looks like all get reconnected. So bat17 you wore right..sorry;) The point is ... now everythink works just as i want it...thx guys!

I put those debug lines in to see what is goin on and thats it. Now im lost..dont know where the problem is:confused: And yes all 3 tables are linked to a new locations... :confused: :( anyone ?

Hey, Thats the code im using for my starup form, to check if linked tables have a connection: Private Sub Form_Open(Cancel As Integer) Dim LinkSt, errSt On Error GoTo err_Handler Debug.Print "[Start Link]" & CurrentDb.TableDefs("tblArhivARM").Connect LinkSt = DLookup("Nazv", "tblArhvOpir")...

NP i get it..Dlookup do just fine...

Hey, I have 3 linked tables in my DB and i would like to create a form that will check if the linked tables links are OK and if not users will have posibility to set link by them self. I know how to create the second part...but i dont know how to check if links of liked tables are ok?

ok i find the core of the problem but i dont know how to fix it... The problem is that when i am typing in the textbox the data is not saved as long i dont move off the field. And becouse of that the list box is not refreshed as it should be. So does anyone know how to "save" the data of the...

Hey, Can someone pls tell me how can i create like auto complit on my form. The idea that i have is to have a text box and after i would type in it the list box would show up and show the posible records based on the string in textbox. I hope you guys understand what im trying to do;) I come...

Im sorry for double posting...but i think this is the wright place for this question. Hey, I have a main form (frmMain) and two subforms (frmSub1 & frmEditRecords). Both subforms are in datasheet view. In frmSub1 I write this code under ON Current event: If Right(Me.ZapSt, 3) = "000" Then...

Hey, Can someone pls tell me how can i get data from query to a string so i can use it in my VBA code? I have a query that basicly creates me a uniqeu code and i need that code when i write new record in datasheet form? For example: I have Query1 that has a field1 with data "AASSFF" Now i...

Oh...i get it...thx...it work just as i need it.

hmmm sorry but somehow i dont get it... but ill explay what i want: i split var1 to var2: var2 = split(var1,"/") now i need the list of all arrays of var2: arr1 = var2(1) arr2 = var2(2) arr3 = ... and so on... So basicly what i want is to get the number of last array of var2?

hey Can someone pls tell me if it is posible & how to get the list of all arrays and/or last array of one string? What i want is that when i will split a string with slitp function i will be able to get a list of all arrays and/or the last array? THX

I know i can do that with a command button, but i dont want that...And it make sense, becouse i dont want users haveing two or more forms open.

Hey, Can someone pls tell me how to close a form as soon as it gets deactivate? Becouse i try with Docmd.Close but it tells me that i can not do that in this event, but thats exactly what i would like to do - close form when it gets deactivated? Thx

Hey, Can someone pls tell me how can i get data from query? The problem that i have is that i build a query that have a one row resoult. And now i would like to update some fields in my form to the resoult of the query. So lets sey that i have a Field1 to Field5 in my Query and the same way on...

hey, i try with UPDATE Table SET Field = Right(Field, InStr(Field, "Ex") + 2) WHERE (InStr(Field.Text1, "Ex") <> 0) And the problem is that my records are not all the same left of the "Ex". Some have more some less characters and that i dont get allways the same resoult :confused: So does...

hey, Is it posible to somehow intigrate this code or some other code that would do the same in to query? code: str1 = Right(Me.Text1, InStr(Me.Text1, "Ex") + 2) I have a table1 with filed "EXZ" and that field contain some data like "7.5/400/Eex de IICT4" now i would like to run an update...

:D so easy :D Thx ghudson

Hey, Is there a way to cancel add new record procedure? The problem that I have is that what users are clickin on a "Add Rec" button (DoCmd.GoToRecord , , acNewRec) the new record Is added but if they change their mind and want to cancel the input of the new record i do not know how to do that...

hehe, i never use that buttun before :D THX