Recent content by Rick

It's me again, When I attempt to run the "Replace" statement in the "Update" query I get the following error: Undefined function REPLACE in expression. What am i doing wrong???

Sorry for the dumb question Harra but, Where would I insert this statement? Would I create a Module for this?? Again, I apologize, I am still learning. Thanks to all for the responses.

I have a "User" field in a table that gets populated from an imported file. The data in the field looks like the following: MT<>PWI<>Smith MT<>PWI<>Jones MT<>PWI<>Doe How do I strip the MT<>PWI<> from the record(s). This will also need to work on our monthly imports. Thanks in advance

I have a form where a user can ADD/Update records. If they click the update icon, the form opens with the recordset showing the first record in the table. Problem is, There are alot of records and if a user needs to update his or hers data i would like them to be able to pull up just theirs...

Thanks Sambo, Hopefully we can crank this thing out.

Hey buddy, I sent you a PM, Check it out OK? Thanks

Sambo, What I am refering to are the multible YES/NO Boxes in the original D/B. The department head will have to select one or more of thse selections to assign to the user. Also, The job qualifier has changed, If you remember me saying that since this D/B is based on "Position" and not...

Sambo, Two questions please. 1) The list of positions that were in the D/B I sent you are "Predefined" The drop down subform is great but will this work for the predefined list? Even if we could use a dropdown box that would allow us to select from. 2) The position qualifier at the top of...

Here is the Zipped file. Thanks

Thats the good part Sambo, There have been no Qualifiers assigned!! That is what the department heads will do for each job position when this gets rolled out and is live. (The ulcer is kicking in buddy) Should I grab the two files that will need to be imported and put them on disk in case we...

I know my friend, My lack of knowledge and time constraint were the factors but, You are absolutley correct. I was able to find out specificaly what is needed, My question to you is, after explaining to you what is needed, Is this D/B so far gone that we cannot tweak and fine tune? If you tell...

2 more items Sambo Hi Sambo, 1) I tried to import as fresh Employee file into the tblEMP and a Department head file into the tblDepthead tables. Problem is, When I attempt to import 1675 Job position records into the table i get a "Validation" error and it wants to only import 746 records. Is...

Sambo, What can i say, It's what he wanted to see. I of course see updating issues but will deal with them as they come. I can't thank you enough for your time and effort along with you patients. I guess I need to read up on Normilzation as well as Bound and unbound Fields. I thought I had...

Sambo, Can I ask you one more question? Yes this is what "The Boss" wants to see but, Can you tell me how I can set it up to be able to enter the department number and have that departments recordset populate? This is to save a Department head from having to scroll through all other...

Thanks Sambo, Think we can give it the ol' college try again?? I will not touch any of your corrections.......Promise : )