Search results

I am transfering data from one system to another. A person's occupation on one system is entered by free text but I am moving that data into another system that has a person's occupation entered through a pre-defined list of jobs. If you look at the MS access table I have a list of...

I am trying to use a replace function in VBA to run a query but I dont know how to reference it in VBA in order for it to work. Here is my code where I ahve tried to use to get rid of certain characters from people's name: Public Function GetName(AnyText As String, bFlag As Boolean) As...

I dont know how to reference the replace function in VBA, and I cant use the iif statement because Im replacing words aswell as special characters. I have the following but when I add any more replace functions it crashes saying the query is too complex...

Is there a limit to the amount of replace functions you can use in a single query?

ok fair enough. one quick question. how would I reference the MyForename field?? Replace([MyForename],"+","") ---- Doesnt work

how about if i had certain characters preceeding the name like '*Paul' and '+Tony' How do you use the replace function in VBA to get rid of the '*' and '+' characters??

bingo.......thanks. i really appreciate your help

Thats unreal thanks. Do you know the way some of the name entries only has one name. i.e Michael That is coming up twice in both the forename and surname. Is there a way for it to only show up in the forename field? Ben/Jane Ben Jane Michael Michael Michael...

Thanks they both work. :-) How would I got about displaying the second names then and If there is only one name entered it will leave it blank. i.e. the 'ben' entry would be blank?

Thats great. It works. Thanks very much :-)

I am trying to seperate a name field so that only the first part shows. Data I am trying to seperate looks like this: John/Mary Frank/Jennifer Ben Jonathan/Janet I tried using this: Left([name],InStr([name],"/")) However, when I use it the 'Ben' entry disappears and the first part of the...

How can i use the replace function to replace a number of characters...below is what i have so far: Expr1: Replace([occupation2],".","") Above just replace '.' but i want to replace other characters like "`" , "^", "+", and so on. Does anyone have any ideas??

Thanks. It works much faster now. It does it in about 10/15 seconds!! :-) :-)

That query did not work for that account number by the way

oh ok. But there is actually 60,000 records in table1 that I need to see if it is referenced in table2. Is there still a way to use that query.

that would not work!! The entry in table1 is an account number and the entry in table2 is an account description that has the account number in it. See the entry examples above in my first post.

I have to following code to loop a large amount of data in an excel spreadsheet. However it takes a very long time to loop through the data( around 8 minutes) and produce a result. In the code I pick one entry from spreadsheet one to loop through spreadsheet two entries and find any entries to...

access 2003

Thanks. How do I do that? I don't see that option in the wizard.

I am trying to run a query to display all the account numbers that appear in TableA but do not appear in TableB. What should i type into the criteria section? I tried 'not equal' but just returns a list of the account numbers in both tables.