Recent content by thadson

This is great stuff. What is interesting that I already come to this solution once, but I have dismissed it because I could not make a form out of it where I could start entering some devices, then add some drawings with some subdrawings and then add in the parts. What it made it all more...

Thanks, I already had that link before, but... In my case (I tried) it would not work as I could have an infinite number of many "parrents" (many) to an infinite number of "children" (many). In the cases of horses, you can sove the problem with that ( I might add - really ingenious) solution...

Thanks Mat for the reply. Which version of Access did you use. My Access 2000 can not open the sample DB saying that it needs something newer. Please let me know which one. Thanks Thadson

:confused: Hi, How can I handle data in access that relates to itself: example: I have a device. The device has drawings and parts as follow: main drawings: draw1 (device1) draw2 (device2) draw3 (box1) draw4 (box2) sub drawings and parts: under draw1: draw5 (PCB) draw6 (electric outlet)...

Hi Everyone, I'm trying to figure out a sane way to build a database that seems more and more complex as I'm looking at it. I understand the basic principle of many to many relationship with the little middle table trick. But the way I need it isn't that simple So here it is: There are...

Thank you MStef for the reply. I appreciate it. However it will not solve my problem. I have over 500 spreadsheets that need to be imported. I wrote the vba code to loop the import and then to move the imported files. It already has the ability to import data into 1 table from them. What I need...

Hi, I'm trying to import specific cells from MS Excel 2000 spreadsheets to MS Access 2000 tables then move the spreadsheets to a different directory. I'm very new to this and I'm having trouble to implement this. I have worked out so far the code to import certain cells into 1 table, but I do...

i need a little more help. you formula is really great. I used it for 2 weeks and it works perfect for the most parts. I have noticed only 1 problem. when I have a partial IP address like 255.255.255. or 255.255. I start getting error messagesin the query. IP1 IP2 IP3 IP4 255 255 255 255...

WOW, Thank you.

Hi. I have a table that has 1 field called IP it containes IP addresses as data like this. IP 255.254.253.252 255.251.250.0 Is it possible to have a query that would break this up so it becomes a new table with 4 fields like this: IP1 IP2 IP3 IP4 255 254 253 252 255...

thanks, I got it... I needed a "!" instead of a "." between the fields. Thank you

did not work Thanks, apprecieate the help. However it did not work, I did the tings you have said and it just does nothing.. not even an error message. However the records are not updating.

update query like i can update all the customers cancel date to let say 8/21/03 at the same time but I want to use the data that is in the cancel table: how can i update customer1's CancelDate field in the customers table to 8/21/03 from the cancel table and customer2's to 8/3/03 and...

Hi, I have 2 tables "customers" and "cancel" the cancel table comes from a third party. Customers table has CustID CustName SignupDate CancelDate CancelReason CancelTable has CustID CancelDate CancelReason RoomCode Promocode As the Customers table is the original Table it contains no cancel...

the formula Thanks for the reply, I appreciate it. I guess I was not clear enough, my most important problem is the formula itself. I'm not a programer and the logic of this (however symple it might be) is beyound me... So far however noone else could came up the right formula either. If I...