Recent content by teluser

Also, it might not always be just two items that need to be parsed like in the above example. It could be 3, 4, 5, etc. Its never the same. Thanks..

All the data is sent to me in an EXCEL spreadsheet. I have no control of the format that it is sent to me presently. Basically the only option I have is to take the EXCEL file and import into access. Thanks Brad

I have a file that I need to Parse the last column using the "\" character in the ERRORMSG field. The problem is that I don't need it parsed into a separate column, I need to create another new row in a table copying the same data in the preceding columns. Here is a sample of the data...

Thanks foolio12 and mikevh that got my code to stop looping endlessly. mikevh I'm not sure what you are suggesting will work for what I have or either I just don't understand how to go about it. Here is my scenario, let's say there are thousands of customers. Each customer has several...

I'm trying to figure out some code to select random records out of a temp table that is created from code. Below is my attempt to create a table using the fields that I need, then I create a new field to populate the random number in the table. Then I want to take 50% of the total table and...

If anyone else has any ideas I would be happy to email the database to them to see if they could come up with anything. Any help would be greatly appreciated. Thanks mstrmage1768 for your ideas earlier.

Thanks for the ideas, I checked the field and sections can grow property are both set to grow. The access report is fine. Its when I try to send the report to view in a DOC or RTF format that it gets cut off.

I'm having trouble with data being cut off in Word. When I view the data in the Access Report its is all there like it is supposed to be. However, when I export to Word or even Excel it cuts part of it off. I have the can grow option set on the field that is being cut off, which should only...

Thanks JoJ...Works great with a few minor changes to fit my needs. You have just gotten rid of a headache thats been bothering me for a while now. Below is what I did. I couldn't get it to work using a table so I made a query. Again thanks a million!!! Private Sub txtSearch_AfterUpdate() Dim...

Thanks for the quick responses,you folks are a lifesaver. Here's my whole plan so you can get the big picture. Maybe my whole idea is wrong. I have one main form with buttons for various reports. Then I want to have that single text box for user input,(has to be able to be found anywhere in...

I have a form that users need to be able to enter a text string or single word in a text box, then click a command button and it search for that text, which is usually somewhere in the middle of a line of text that is not uniform, in a particular field of a table. Is this possible without...