Search results

Galaxiom, jdraw is it better now? If you need any additional details let me know.

No. I know, and I truly appreciate it. Sorry I still couldn't make myself clear. I finally found some time to try and create a DB that shows how mine works and upload it, since uploading mine is a problem. It's exactly the same idea only smaller and with less details. I hope it'll make...

I gave an oversimplified explanation of the idea of my DB... You all seem to focus too much on the how my DB works instead of simply answering a very simple question in VB which is how to return a value of an object. I do appreciate your help with the relations since I did change it and...

Is it really that complicated to return a value in VBA???

Oh sorry, 3 tables : TypeA, TypeB and LineID. As I mentioned before, the lines are assigned to different types because they ARE different. They're all communication lines but of different characteristics. They have many similar fields but also many different ones so putting them in 1 form or...

OK. Don't get me wrong I really appreciate it that you're trying to help. I'll try and give an example about the code I wrote above that works and what I need to change: Let's say you have this: - 3 Tables: TypeA and TypeB TypeA has 100 lines, let's take one for example "10-123456" TypeB has...

Ok, first of all thank you jdraw :) But it seems what I need help with is still not clear so I'll try and make it even simpler. Private Sub Edit_Click() * Dim strWhere As String * Dim DocName As String * DocName = "FormName" * strWhere = "[Field Name]='" & Field & "'" * DoCmd.OpenForm...

OK, I managed to return the names of the tables into a query using this SQL code I found: SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name; Now the problem is I'm not sure how to use one...

Hmm.... interesting idea. I'll give it a shot and let you know if it worked. Thanks! :)

The relations between the tables is no more relevant... I fixed that problem. But I still need the code to get the record's source table.. Is it really that complicated to accomplish...?

Anyone...? Please? I fixed all the issues you mentioned but the code is still needed to open the form depending on the record...

Ok so I read and tried the concept of relating tables... I guess it really does help solve this thing and is not as complicated as I thought. But still I need the code that I requested even after using relations since I can now search for a specific line ID but I'd still want to click on the...

Galaxiom, I tested your idea and it works nice. There are 2 problems with it though: 1) If I end up using conditional formatting in all of my DB I would end up with a huge form with tons of fields enabled/disabled... since I do have many types and many optional fields for each type... 2) I'd...

I see what you mean but as you say, I need some kind of tutorial to understand these concepts and how to use them, then I can implement them in my existing DB. I googled for some relations tutorial and some seem ok but still not very informative... If you can send me a good tutorial that helps...

Actually they have a lot of similar attributes since they're all communication lines. It's just that some of them have extra or a few less attributes.

My big problem in creating a big table such as the one you describe is that each type of line has different fields... So I'm suppose to create one big table with no fields and small tables with many different fields I don't get it...

Wow... ok... that explains a few things.. Well, the part I forgot to mention is I actually learned by trial and error and everything after taking an existing DB that someone else made before me... So I now unedrstand he didn't work properly from the beginning... which made me make these...

Ok I'll try and be more clear about the purpose of my DB. Btw, I never defined it as a "relational database"... I created a DB that contains and sorts many types of communication lines. Let's say there are 3 types of lines, then there are 3 different tables, each table contains different...

As I said, I'm new to Access, therefore have I haven't had the chance to mess around with relations but the fact of the matter is I already have a quite huge DB which works completely fine. I'm just trying to take it a few steps ahead. I don't have an example to show... I simply asked how to...

It actually has nothing to do with data encoding... I don't even have any relationships between tables. It's irrelevant and I'm sure there is a simple way to get the name of a record's table...