Recent content by tpowers

That was just what I needed to know.... thank you so very much....

I know that the norm is to display one record after another, but I am trying to find a way to split the report and have one record on the left and the next record in the database on the right....Can this be done.... I am using access 2k Thank you for your help in advance, TPowers

Yes, my question goes beyond the duplicate issue, I have 2 tables and these 2 table have nothing to do with each other, there is a series of numbers in one table that need to be assigned to the series of numbers in the second table. So in the first table there is say numbers 1 - 100 and in the...

Hello everyone I am trying to assign ID numbers to certain records in my database and I have already run a query that tells me which records need these ID numbers and I have alread created the ID numbers in another table. Now I am trying to assign these ID numbers to the certain records, with...

Thank you guys so much....

Hello everyone I am have been trying to get this code to work for the longest time and I jus can not grab it. I have a form that has a sub form and and I have code that when you double click a field in the sub form another form opens and it is controled by a query that is looking for data from...

Hello again, I am trying to use this section of code to tell me if there is a comma in a section of data that I select, other than going space by space with a bunch of if statements is there a way I can go 3 deep pull 11 and then find out if there is a comma in that 11. here is the cod e I am...

Ok.... because I am not the sharpest tool in the shed, here is my question. I am trying to take data that I pulled out of this file and add a Decimal point to it can you help me with that. Thank you in advance, TPowers

I am trying to save a record by running the vb code "DoCmd.GoToRecord , , acNewRec" and some how every time I run the code I get this error message that says "You can not use the GoToRecord action or method on an object in Design view, but I do not have any objects in design mode. Does anyone...

It seems to be working thank you, I will work with it a little bit and let you know, again thank you so very much for your help,

Yes the last line of every record starts with 5A. Thank you so much I am recking my brain over here.

Below you will find the first complete record in the file. I have placed a "|" at then end of each line to show you where that line ends, because the space will between the data and these lines will some times contain data. 1ACO758400000ANKERAGE NP13469*40261*RHO119291...

I don't mean to be a pain, but can I please ask why you have txt9 and msgbox tst9 commented out? See line 1 is differnt from line 2 so I need to parse at differnt sections of of that line. Really all most every ling is differnt, One record could have 10 lines in this file, before I get to the...

When I run the code with with out the "strContinue" it goes and cycles the first line twice and then moves on to the next line. I don't understand it. Tpowers

Hello Payback, the following is the code that I am using: Dim strFileName As String Dim strContinue As String strContinue = "1rst" fp = FreeFile() strFileName = "C:\Old_Data\ABS\Development\WESTERN1.txt" Open strFileName For Input As fp While Not EOF(fp)...