Search results

Not sure what's happening. It removes the text in the field and returns a blank field or zero depending on the code. Pasting doesn't work either. Ah well - you can't win them all!

Yes, it returns blank. I tried using replace using ^w which didn't work so they must not be regular spaces. What are they??!!!

I haven't much experience of sgl, I just typed the code in query design. UPDATE q SET q.FNAME = "UPDATE MyTableSET FNAME"=LTrim("FNAME"); q is the table name and fname is the field I want cleared of whitespace. Thanks.

I put it in the update to section but it returns a zero in each record. What am I doing wrong?

I'm not sure really. I imported a lot of names from excel and they all contain whitespace, both in the table and the form. I wanted to remove it somehow but I'm not sure if trim is any use.

I'm trying to use the trim function to remove trailing whitespace from 2 fields in a form. Is this possible? If so, where does the code go? Thanks.

Well, it's not DISTINCT so it looks like you're right lightwave. I'll have a look at the tables.

Thanks for that Lightwave. I think I have the tables set correctly, I do have what you said. Someone here at work said it may be that in the query I have use DISTINCT so I'll look at that tomorrow and let you know.

I'm having problems with a report printing the wrong information. I posted a while back and thanks to the replies I modified the join and it worked. Except I have just noticed that the report lists a staff member and training done OK but if there's say, 3 Smiths it lists the first Smith but...

Thanks for all the help. A left join did the trick. Thanks again.

So, does that mean the relationships I have set up are wrong? I have 3 tables: tb_staff has staff details tb_courses_done has training done tb_courses has course details. tb_staff to tb_courses_ is 1:n with staff_id as pk in tb_staff and staff_id, courses_done_id and start_date as the...

Do i create a new table?

I'll give it a go. Thanks.

Help! I've just recently managed to normalise my database but when I try to run a report based on a query I can't display what I want to. I want to display staff name and details of their training. I have tb_staff and tb_training_done but can only list the training_done_id rather than the...

I'm trying to get a form to display a pick list so I can choose a staff name from the whole database and the form will go to that record. In the after update of my combobox I have: Private Sub STAFF_ID_AfterUpdate() Dim rst As DAO.Recordset Set rst = Me.RecordsetClone...

I have a small health service database that I am slowly getting into shape thanks to these forums. I have a main form based on 2 tables - tb_staff and tb_courses_done that are 1n. How do I get the staff name, job title etc to display as a set, similar to the courses done subform? Thanks.

Can anyone recommend a book for learning vba? I searched the forums but the books suggested seem a bit much for what I want. Basically I want to know enough to make various forms do what I want. I've seen a few but they major around excel. Thanks.

I had a database that wasn't normalised but after some (a lot of) help here it now is. I have quite a few records that need to come accross to the new database and I was wondering: I can drop the NAME/JOB_TITLE/BASE information in OK but can I place the trainig done for each staff member in...

Thanks for that ssteinke. Please take another look and let me know if I've linked the tables OK. If I have then it must be underlying code that I'm missing because I still can't get the form to work.

That's my problem I suppose, the relationships are not right. The thing is, MStef's solution worked although he changed the primary key. Anyway, I'm trying to grasp relationships so perhaps you will bear with me a bit. In my original dbase I had tb_staff staff_id linked 1:n with...