Search results

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")...

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?

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...

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

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, 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...

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...

Hey, Can someone pls tell me how can get not equal resoults from my two tables? I have table1 and table2 both with field "Layer" and what I want is to get only that data from table1 that does not have the same Layer as table2.Layer? I try to JOIN table1 and table2 and i get the same resoult as...

Hey, I look everywere but i just cant find how to write two rows in single msgbox? Can someone pls tell me the code? THX

hey, Can someone pls tell me how can i split my string in three ways? I have a field in my table called (proiz) with data like "somethink1/somethink2/somethink3". Now i would need to get that data out splited like: mystr1 = something1 mystr2 = something2 mystr3 = sometnihg3 Does anyone have...

Hey, Is it posible to eliminate an append query or update, delete querey message. So that users wouldnt have to click "yes" in a msgbox that show? THX

Hey, I have a text file i wish to link up to one of my tables. The problem is that even if i try to import data from that file i get "Text file specifikation field separator matches decimal separator or text delimiter." message and after that one an err that the file cant be imported. Does...

Hey, I have 2 tables that i compere together with a query and if my criteria is OK than selected data is recordet in new table with some calculation....code: INSERT INTO tblZaloga ( Proizvajalec, Tip, DN, Predvideno, Naroceno, Zaloga ) SELECT tblACAD_Urejeno.Proizvajalec, tblACAD_Urejeno.Tip...

hello, i have 3 tables: ACAD_U: ID PROIZ_A TIP_A DN_A KOS_A IN_U: ID PROIZ_I TIP_I DN_I KOS_I ZALGA: ID PROIZ_Z TIP_Z DN_Z KOS_A KOS_I KOS_Z Now i want to create an append query that will add in table ZALGA fealds PROIZ_I, TIP_I, DN_I, KOS_A, KOS_I by critera if TIP_A = TIP_I AND DN_A =...

hey, can someone pls tell me why i get an Type mismatch in expression err with this code: INSERT INTO tblACAD ( PROIZVAJALEC, TIP, DN, KOSOV ) SELECT tblsifrant.Proizvajalec, tblsifrant.Tip, tblsifrant.DN, tblsifrant.Kosov FROM tblsifrant, tblACAD WHERE (((tblsifrant.Sifra)=[tblACAD.TIP]) AND...

Hey, I have a big problem, becouse i even dont know where to start this time? :confused: Ok, for the start i have a Table1 and Table2 with fields (ID, TIP, DN, Pieces, Date). What i need is to run thrue the records in Table1 and select the records with the same TIP and DN and than sum the...

I would like to set a database password for my back end so that ppl could not "exidentaly" open the wrong .mdb file. Then i want to send a database password from my front end to my back end so that users who use FE would login my BE automaticaly? Is this posible? If so, how? One more question...