Search results

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

thx...but somehow i find a solution ... mypos1 = InStr(mystr, "/") mypos2 = InStr(mypos1 + 1, mystr, "/") mystr1 = Left(mystr, mypos1 - 1) mystr2 = Mid(mystr, mypos1 + 1, mypos2 - (mypos1 + 1)) mystr3 = Mid(mystr, mypos2 + 1)

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

thx to all of you ... strep21 it works like magic ;)

thx bat17 thats exactly fhat i was lookin for

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

thx man..looks like i learn somethink new ;)

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

:rolleyes: thx for that...its ok now :D

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

no swet;) I get it..the problem was in WHERE (((Table1.tip)=[Table1.dn])) it should be WHERE (((Table1.tip)=[Table1.tip])) And the other think...I solve it some other way! Happy Hollidays man!!! THX!!!

hmm that was one part of my question ;) But still i have a problem: If i use WHERE (((Table1.Tip)="A") AND ((Table1.DN)=15)) the code is ok, but as you can see thats criteri based on one record, thats why i get only one records in Table2, and thats not what i want. If I use your code WHERE...

THX this works great! The only think is that other this code "copy" only the peaces, but i would need to copy all the fields (TIP; DN, DATE). Can you pls tell me how to modify that code of yours to work that way? And one more think...Is it posible to count the same records, just the way u did...

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

Ok , when i read somethink like this from you i know im in deep sh** :eek: The problem is that i want my DB to be in one file only. No installation on users computers! Becouse users only need to read the DB (Im the only one to write data in DB) i thot that i would make my DB read only by...

Hey, I secured my database with password login form. Usernames and password are in special table becouse i did not want to use access security sistem. And thats workin just fine for me. The problem that i have now is that if two users login the second user get Run-Time error 2467. I think thats...