Search results

Tnx allot for your help so far.

no dont need want to get rid of it after it is split. Here is wat exacly must happen and dont have any idea where to start. i import a text file with different fields. the first field contains a 13 digit number and i want to split this number in 2 to generate 2 seperate numbers. this is an...

at the moment just trying with a button, but i dont even get the value of the field into a varuble. this is my code. Option Compare Database Private Sub Command0_Click() Dim aaaa As String Dim bbbb As String aaaa = toets.table1.NSC MsgBox (aaaa) End Sub

or must it be more like this? Mid(field1, 2, 2) = field2

This is how i understan from what the help gives me how it should look like. Private Sub Command0_Click() Mid(table1.NSC,2[,2]) End Sub

How does this work? do i put it in a query? I just want to add the field will aloways contain 13 numbers but the numbers differ totaly. Tnx

Howdi. Im new with access but can help my self. What i want to do is copy parts of a field into a new field. For example: Now: field1 000011110000 want it to be: field1 field2 000011110000 1111 Tnx allot.

Grate tnx allot

I c. It is basicly a work hour overtime system i want to write. What will work the best?

what i want to do is: I have a "create user form" if i click add i want the program to automatically create a new table with certain fields for each new user added? Tnx