Possibly newbie question about formulas

[daja]

Hi,

I was wondering if anyone can help me out with this.
I have a row in my access table that looks like this:::

abc.1      1     default.1

I need to copy this 16000 times and every time the last character should auto increment itself like

abc.2      2     default.2
abc.3      3     default.3
abc.4      4     default.4

and so on.

Can anyone tell me what kind of formula would accomplish that?

Thanks in advance,

Daja.

 

[Russell Hauf]

Do you just want to store these values in your table? If so, I suggest doing this in Excel and then importing the sheet into Access. Let us know if you need help doing this.

-rh

 

[daja]

Hi Russel,

I do need help doing it. I have never worked with Excel. I would appreciate some help on the matter.

TIA,

daja.

 

[Corticus]

Hi daja,

There's a few ways to accomplish what you need, I'll suggest one easier method, and that is to use a form and a loop.

I'm having a very hard time trying to figure out exactly what you're doing, or what you've got, so I'll provide a generic solution.

Make a form that refers to the table that contains the data you mentioned. make sure the table has an autonumber field.

Add an unbound textbox to the form that will hold the number of records you need to create (I'll call it TxtRec). Add blank fields to the able that will hold these new values you want to make, I can't tell how many you have.

Autonumber field control is TxtID
Control holding ABC is TxtABC
Control to hold ABC.1 is TxtABC1
Control to hold default is TxtDef

I have no idea if all of these values are supposed to be generated or what, so I'll assume you have only ABC and a number.

Use a loop like this (called by a button perhaps):

CmdGenerate_Click()

Dim i as integer

For i = 1 to TxtRec
TxtABC1 = TxtABC & "." & TxtID
TxtDef = "Default." & TxtID
DoCmd.GoToRecord , , acNewRec
i = i+1
Next

End Sub

I like this method because you can specify how many records you need to generate, and then just hit the button to make 'em.

HTH,

 

[sunshine]

I don't know if this will help or not but you could try going into Excel,

Typing in the first row of data;
when you get to the first cell of the data that you want to be in series, right click on the cell and drag down. When you release the mouse button a menu will come up. choose the option "Fill Series" This will fill in the data in series matching the data types that you have entered. This will work will alpha and numeric data. You can also make more detailed changes to the series format from this menu as well

Then you can import that data into Access.

Hope that helps, Post back if it dosen't

Sunshine!