Search results

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 : )

Sambo, I still have the D/B we started, I am in a bit of a crunch here trying to get this thing done. I am trying to learn as I go but sometimes the situation will not permit that. I tried to create a Query with both tables but I could not add to the recordset(??) Can you please tell me how to...

Sambo, I am almost where i need to be with this project. I can't seem to get the relationships exactly right. I cannot get the "DepartmentHead" to show up as i am scrolling through the job positions(??) Can you please take a look at what I have so far and give me some ideas? I need this D/B...

Sambo, I will work on moving the fields into tbljob. The main form will be used for data entry,viewing, and editing the records. Thanks

Sambo, I hate to ask but, Could you guide me further with this project? I will work on what is there so far but i would appreciate your help with this project. Thanks in advance.

Thanks Guys Here is a copy of what i have so far. Please let me know what you think and if what i need to accomplish can be done. I am struggling to learn this so please be patient and use little words : ) Thanks again