Search results for query: *

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)...

Ok... hey payback this code is working, but I can not get it to cycle to the next line... I can pull all the data from the first line of the file and then display it, but when it gets ready to go to the next line it bombs out on me, do you know why that is? Thank you in advance, Tpowers

You know what thank you so very much, you have just made my day, I can not tell you how very happy I am. Thank you Thank you, Tpowers

Let me give an example: 1ACO758400000ANKERAGE NP13469*40261*RHO119291 3AANKERAGE 3BBUDGET BLINDS OF REDDING JERRY BAY 19182 BANNER WAY COTTONWOOD CA96022...

Hello everyone, I am trying to import a fixed width flate file and I was informed that the only way that I can do that is if I write a code in vb that will parse eaching line. Now since I am new at this I am unsure how to parse a flate file in vb. If anyone can help me that would be great...

The following code is giving me the same error IE: 2115 As stated in my above and first theard I do not have any beforeUpdate or validation rules set to the field that I want to add data to nore is this field connected to a table or query. can someone please tell me why this error is comming...