Search results for query: *

Hi, I have an on click event procedure that inflates the file size of the MS Access 2007 database. I think it has to do with writing to the open record set... This is confusing!?! Can someone take a look at the code and see if there may be a way to keep the file size manageable? THANK...

Golom, Thanks again for all the help!! -Joe

Thanks! I took the part: Select N Into NT From I Where N <= MaxSpan and named it query "NT". After running: Select MAX(End_Hse-Beg_Hse) + 1 As MaxSpan From myTable to determine the maximum span of numbers, I put that number into the "NT" query in place of "MaxSpan" (BTW it was 800 for...

Hello, I was able to get option 2 to work, and it seems to have processed the records properly :-) One thing is that the process is pretty slow. I did modify the "I" query to include longer integers as shown: SELECT I1.Num*10000+I2.Num*1000+I3.Num*100+I4.Num*10+I5.Num AS N FROM Integers AS...

Golom, I'm getting a late start today. I appreciate your response and shall try to implement the public function in a VBA module today. On a related note, I mistakenly published my last post without specifying that the original record was like: SIDE BEG_HSE END_HSE O 601 699 and I...

Oops, I think I found an issue with handling [SIDE] = "O" records. These types are SIDE NSIDE HSE O E 686 O E 688 O E 690 O E 692 O E 694 O E 696 O E 698 O O 699 I am trying to figure out why? It is interesting that the last record's [NSIDE] value is processed as an ODD an all others are...

Hello, I have the need to move beyond the limits of the query "I". I have modified it as such and would like to be affirmed that this works (even though I tried it and it seems ok). SELECT I0.Num*10000+I1.Num*1000+I2.Num*100+I3.Num*10+I4.Num AS N FROM Integers AS I0,Integers AS I1, Integers...

Golom, Are you kidding?!? This is very helpful stuff! Thanks for your efforts. I am going to tinker with what you have helped me with for now. I may come back with questions if you're up for it. I am now wondering if this thread is miss-categorized since it is really a query issue. I have...

Thanks Golom, I tried what you asked and just for the record, there is a brace in the place where a bracket is intended closing out the "NSIDE" field. After creating the "I" query and then creating another query for part 2 (and then), the results only included one record for each record in the...

Golom, After re-reading your posts I realized that you were on to the concept of having types "O", "E", and "B". Type "B" being as you describe in this quote.: Thus, this makes the statement: Untrue. At first I wanted to generate all potential addresses within the specified range, now I...

Golom, Thanks again for the response! At the time of the original post, I was thinking the side issue would be too confusing. So there would be the standard output much like the first solution you had provided for original records with "SIDE" field values of "O" or "E", as well as this type...

Golum, That works wonders! Thank You! I see that you inferred quite a bit from the sample, with regards to even and odd values, and the interval of 2 units. I have three record types: O = ODD, E=EVEN, and B=BOTH. This is in a field named "SIDE" The ODD and EVEN types are great. I would...

Golom, My apologies for the lacking clarity in the original post, and I thank you for the response. Here is a sample of a dozen or so records that contains the relevant field headings: -------------------------------------------------------------------------------- | OBJECTID_1...

Hello, First off, I am rusty as the tin man. What I would like to do is add new records to a new table. These new records will be almost identical to existing records in another table. Each existing record that would be duplicated will hold all the values of the original, the challenge is to...