Help needed, Please!

[iLLmatic]

Hey peeps,
Posted here recenetly, and thank for the answer - however have deicded Im gonna at least try and create my own Database - i'll learn to use access and hopefully the DB will be "taylor" suited for my needs..

The problem I have is how do i make data see each other - I have a name table named

"names list"
Within that contains every user's name, and a service tag for there PC.. How do I make this update within my main table "asset"?

I basically want the function, of when I change Name field, all field's within my "asset" table update. What am I missing?

Please help - I have enclosed an Screen shot of what my asset table looks like at present - you can see where the field name is, and service tag.

Thanks!

 

[M8KWR]

I think you are missing the point of linked tables and how they work.

Have you created a relationship between these two tables?

Do you have the same fields names within both table design? i.e. user name etc.

You must have a link between both tables, so i am taking that you have a field called Asset ID with the other table.

If you can get me a screen shot of the other table layout, then I can help you further.

But i hope this helps you in the meantime. But also think if you actually need 2 tables. Sometimes people who are begining out with access want to jump straight in there and then confuse themselves. If you do not need 2 tables, then only use the 1 - but only you will know that answer to the type of data you are capturing, and what it is going to be used for...

 

[iLLmatic]

I think you are missing the point of linked tables and how they work.

Have you created a relationship between these two tables?

Do you have the same fields names within both table design? i.e. user name etc.

You must have a link between both tables, so i am taking that you have a field called Asset ID with the other table.

If you can get me a screen shot of the other table layout, then I can help you further.

But i hope this helps you in the meantime. But also think if you actually need 2 tables. Sometimes people who are begining out with access want to jump straight in there and then confuse themselves. If you do not need 2 tables, then only use the 1 - but only you will know that answer to the type of data you are capturing, and what it is going to be used for...

Thank you for your reply - my reltonship table currently looks like the picture (see attachment)




Please help - i dont mind how "long hauled" this project is, however... my understanding is "basic" - as ive shown, and any help would be great!

 

[M8KWR]

i've noticed in the relationship window that you have linked the "Name list" table twice, did you mean to do this...

You have a lot of tables that only have an IDnumber and a drop down (or so i am assuming)

I personally would not do it this way. I would have the table so you are able to add items etc, but have on the main form a combo box and have that look in the relevant table. I only prefer to use IDNumbers when I am gathering more then one set a results.

On your main form do you use sub form or not.

The only two tables that I would see as important are the Asset Main and Name List.

With these two tables are you gathering multiple line against the name or the Asset Main.

If you could give me a screen shot of your main form then that would help. If you could do this in design mode, if would be useful.

I hope this as helped and not confused you even more.

If you are using ID number like what you have now it is helpful to have the IDnumber spelt the same in both tables. eg MSOfficeID -> MSOfficeID not MSOfficeID -> MSOffice. It just helps you see the flow, and if the tables were not linked, or lost the links you would easily know how to repair them.

 

[iLLmatic]

picture of asset table..

 

[M8KWR]

can you give me a screen shot of your form/forms if you have any.

In your table layout, if would not work properly because your field types of the MSoffice for example should be a number not text to link to the other table.

What exactly are you using this database for. If you could explain this will help, the more detail the better, also if you try and explain how why you need to capture this information, and what you are going to use it for.

I think you are going in to complex (which is good, and help you learn more quickly but, i feel it may be clouding what the program is going to be used for, and how its going to be used by the end user.)

 

[iLLmatic]

basically, I need a way of bring up user details within my 200 user enviorment. My manager has given me this task, as Im a student in training, therefore trying 2 get this done - in the best way, so I learn - however will be useable.

It has to be able to have a names list, and basically have details of each user - i.e, Name, phone extension, Operating System, etc etc... kinda simple to the experts...

The information is basically needed so we can bring up user details in a quick manner, so that I can find user details, without having to go through the endless excel sheets we have...Hope that helps?

 

[M8KWR]

How much help can i give you???? Or what you want me to give you???

You can do this an easy way, or go the way i think you would prefer to go, so you are learning more quickly.

What i can do for you if you want is do something really quick and post it so you can have a look at what i have done, and see if you can us things out of it, or modify etc - to assist you.

If you let me know, it would only take me about 1/2 hour to get something together. Do you need a frontend, search/lookup facility etc.

If you just want me to push you in the right direction, you would need to set your table layout first, and make sure you field types are correct, as they are not at the moment.

 

[iLLmatic]

What i can do for you if you want is do something really quick and post it so you can have a look at what i have done, and see if you can us things out of it, or modify etc - to assist you.

If you let me know, it would only take me about 1/2 hour to get something together. Do you need a frontend, search/lookup facility etc.

If you just want me to push you in the right direction, you would need to set your table layout first, and make sure you field types are correct, as they are not at the moment.

that would be great, I think if I have something in front of me would make my life so much easier - trying 2 do this from nothing, with no workin exmaples or references is proving extremely diffucult!!

I need frontend, search facility as well, if this is possible, id be more than happy to stick your name in the report - however thats your choice.. thanks for all the help!

 

[M8KWR]

sorry its taken me a while to get back to you, i've be off work for a day.

I will get soomething over to you today if that ok with, sorry about the delay again...

someone read my email, and forgot to mark it has unread after they read it.

 

[iLLmatic]

if its easier for you, my email is

illmatic0"nospam"@msn.com

Take "nospam" as im sure you know, thanks again.

 

[M8KWR]

i have sent it to your email account, any issues please let me know.

If you are replying to my email address please post a comment here so i know to check it.

Hope it all makes sense.

Kevin

 

[iLLmatic]

Kevin, thanks for your help - it has really helped my understanding.

I have managed to intergrate my names list, and service tags with no hassle - However, now I have ran into trouble regarding the filter on the form. It works when I type in a name, however..

How do i make it so when I type J, It narrows the search down to all J's, so if i were to type my name: James as I type each letter, "J" (all J's appear) then "a" (only results with Ja as the 1st two letters appear)

Im guessing I havent explianed it in a great way - however I must thank you for all your help!!!!!! My complete lack of understanding must be somewhat annoying, so I must furthermore say thank you for helping and bearing with me!

 

[iLLmatic]

Kevin, thanks for your help - it has really helped my understanding.

I have managed to intergrate my names list, and service tags with no hassle - However, now I have ran into trouble regarding the filter on the form. It works when I type in a name, however..

How do i make it so when I type J, It narrows the search down to all J's, so if i were to type my name: James as I type each letter, "J" (all J's appear) then "a" (only results with Ja as the 1st two letters appear)

Im guessing I havent explianed it in a great way - however I must thank you for all your help!!!!!! My complete lack of understanding must be somewhat annoying, so I must furthermore say thank you for helping and bearing with me!

Kevin, are you able to help with this ? I havent been around of late - and have since lost your email address... Hope all is well.

 

[M8KWR]

I know that i have done this before, but I must ammit i have forgotten the code i used last time, and what procedure i put it into. I should have some time this morning to investigate it further.

So i will get back you if thats ok, if i get an answer or not.

Hope all is well with yourself.

 

[iLLmatic]

thank you for your prompt reply - the database is looking up so far - alot of details now in there, and have formatted it for the most part - thank you for all your help.

I am slowly understanding more and more about access - like the fact you cant import data usless the "header" of the tables corrosponds with the data your trying to import..

Im around all day up until 4pm (when i leave the office ) and thats mon-fri - so get back to me whenever is best for you.. once again thank you for all the help