Recent content by knightwest

That's great thanks. Just out of interest. how can you make InStr search for the 2nd or 3rd etc space (if you can)?

Hello all, I have a problem with the RIGHT function. It all seems very simple to me, but I can't get it to work the way I want. I have a set of fields: RETURNED BACS - ET1685311TA they all start with "Returned Bacs - " bit. I thought it would be easy using the RIGHT function to just pick the...

Hello all, thanks for your replies. I have found that often when Access is "not responding" it is in fact not hung. I found this by checking the Task Manager, the process was still running. So i just left it long enough and once the process actually started is quite quick.

Thanks for replying. Not really, one contains 4 tables and about 10 queries and is about 54MB. The other contains two tables and 2 queries and is about 196MB. At my old job I used to compact very complex dbs at about 1.8GB with no problem at all. I don't think I am doing anything wrong or stupid.

Hi, I have a problem compacting a database. i used to do this all the time at my old job, yet here at my new company, all I get is the usual blank Access screen, the sandtimer mouse icon, and if I select any other program in Windows and the switch back to Access, it crashes "MS Access (not...

I like the last one best, I will try it.

That works like a treat. Thank you.

hello again, have written the following IIF function, which works IIf([G/L acct]=54201,"y","") so, if the general ledger account is equal to 54201, then put a "y" in the field, otherwise leave blank. The problem arises because I need 2 more accounts flagged with a "y" I have written the...

Problem solved Basically the problem was this: Instead of showing the first line of records in access in row 1, it showed it somewhere on row 20000 or something with all rows between 1 and 20000 being blank. in excel all records started in row 1. Reading your post helped me sort it though, as...

Hi, I have been importing excel spreadsheets succesfully for a long time now and this new problem I have never seen before. I don't know how to deal with it. I have had a look on here but could find nothing similar, I have not really had a any luck searching google, mainly because I am at wits...

thanks boblarson, your input has helped me progress a bit. for instance, with the function Like "5*" i have been able to run a query bringing back all the policy numbers starting with a five. I now face a few new problems: 1.) while this query now brings back all records with the above...

1. How does the data get into your database in the first place. It is uploaded from excel, it originates from an insurance software that bunches some of the fields into one. 2. Why is there multiple data in one column, from which you have to extract a policy number. the insurance software...

sadly i am unfamiliar with normalisation. i am trying to isolate policy numbers stored in that text field. in 90% of the time they are the first "word" in the field, but in the rest they are either at the end or sometimes in the middle. i thought if i could split them into different fields...

Hi, I am fairly new to VBA. I am trying to split policy numbers from a field in an access table containing more text than just the policy number. This is the VBA we use in Excel, it looks at all the different types and isolates them: FindText(1) = "*[A-Z][A-Z]#######[A-Z][A-Z][A-Z]*"...

Hi guys, I have a table with a rather unfriendly field. This is legacy data so it is not possible to alter the way data was input. The file contains text in the following way. Word1 Word2 Word3 Word4 etc... The number of words is not constant throughout the column. What I would like to do is...