Search results

Hi Thanks for your reply. This seems like the way to go though I don't know much about VBA code I'm afraid. If you had some pointers about where to find code for your processes on here that would be helpful. The files are currently in ASCII format but I can batch convert all files to .txt...

Yes, but the reason I wanted to link rather than import into one table is that access has a maximum file size of 2GB I think and the total of my text files is 80GB. What I really want to do is run a text string search on all the files to find out in which files the a text string occurs. I...

Hi I have 400 .txt files in fixed width format. I would like to import these into access as linked files (as the total file size is 80 GB.) I would like to automate the process of course as it would take too long to link each file individually. The access field specifications are 10 fields...

Yes, thanks. That worked. Thought it might be something as simple as an update query.

Hi I have 3 columns . Column A and Column B and column C. Column A is my unique identifier. Column B is fully populated ie no null values. Column C has some null values. Where column C has null values I would like to add the corresponding value from column B. Thanks

Here is the zip file, didn't work before because it was .rar

Search form with wildcard parameters Hi! I've finished the seach form I was making and have attached it as zip. The form basically uses a wildcard parameter search to search 3 text fields in the table. There are 2 possible searches 'and' search and 'or' search for which I have used 2...

Hi thanks for the replies. The tutorial was useful but it didn't exactly solve the problem. Just to make it clear, I already have the form with command buttons which execute the query. I essentially have 3 keyword text boxes which search in 3 fields for records which must contain 1,2 or all...

Hi this is a two part problem really. I have made a form based parameter query which uses a wild card search. All data in the 'table' is in text format. At the moment the form has 3 parameters keyword1, keyword2 and keyword3. The sql for this is below. SELECT column1, FROM table WHERE...

Yes, that's my fault sorry. Thanks for the help though.

Thanks but I figured it out. There were 4 columns Data, Date, Date1,Date2, I just wanted to select from Data where Date fell between Date1 and Date2. pretty simple really. SELECT Data, Date, Date1,Date2, FROM table1 WHERE (((Data)=1) AND ((Date) Between Date1 And Date2));

I have a table with 2 date columns which are different for each record. I have another column of numbers where I only want to select '1' for example if it is between the dates in the 2 date columns. I guess I should BETWEEN or DATE RANGE but I can't make it work with sql. Help appreciated Thanks

Thanks everyone this worked in the end Expr1: Mid([table].[field],InStrRev([table].[field]," ")+1)

Sorry, namliam. Have been on lunch. Yes the last space could act as the deliminator. This is probably better than using the first number right? Sorry for my ignorance, I'm a bit new at this. I wonder if you could help me using the "InstrRev" to find the space. About excel, I could spilt...

Hi Gemma Thanks for the reply. I think we are going a bit too deep in terms of objectives. But in general I want to split the column into two with one column simply containing the drug strength in the format : 150mg 300mg etc... I can then match the drug strength against another...

actually the column should look like this of course Valproic Acid_Cap E/C 150mg Valproic Acid_Cap E/C 300mg Valproic Acid_Cap E/C 500mg Valproic Acid_Tab 250mg Valproic Acid_Tab 500mg Convulex_Cap E/C 300mg

Hi. A quick query. I have a field which looks like this. Valproic Acid_Cap E/C 150mgValproic Acid_Cap E/C 300mgValproic Acid_Cap E/C 500mgValproic Acid_Tab 250mgValproic Acid_Tab 500mgConvulex_Cap E/C 150mgConvulex_Cap E/C 300mg I am simply looking to parse into 2 columns. Although I...

Great, this work a treat. Very clever, many thanks!!!

Hi! I got this used defined function off the microsoft online access (see below). The purpose is to change an ascii string into hex characters so they can be sorted case-sensitively. ******************************************************** Function StrToHex (S As Variant) As Variant ' '...

Hi! I got this used defined function off the microsoft online access (see below). The purpose is to change an ascii string into hex characters so they can be sorted case-sensitively. ******************************************************** Function StrToHex (S As Variant) As Variant ' '...