Search results

E.q. SN:1234TTT-1234BTY0001 SN:1234TTT-1234BTY0002 SN:1234TTT-1234BTY0003

Number is long . It have almost 30 characters . Include leters ,digit, and specialist characters as : . Last four position we talking about there are starting from 0001 and rising up

It is not that easy. Imagin you have target 300. You taking scaner and you scaning serial numbers. Serial numbers are mixed then when you will scan 300pcs you dont know how many grups with following numbers was created. Problemy my example was confusing. The idea is that VBA or query will...

This only example. Numbers do not in create all the time. Some Times is a gap between them . I need to catch first number from seqence. For example I am płacing serial number in to data base and the product is splited for bach. First batch is from 1 to 24 and second start from 72 till 138...

Sry Aaa1 and Aaa6 need to be transfered

Hello Forum, During my work with access I am struggle with problem I'm In My Knowledge is not Enough. I have guery with specialist number in one column . Let's say Aaa001 Aaa002 Aaa003 Aaa004 I need to transfer on raport only numbers which are first in number grup. Example: Aaa001 Aaa002...

It is working :) CDate(REPLACE([p1ok],".","/")) It was the solution :) Thank you very much

Hello, For confirmation I am sending pic with query settings and output. I am not sure why but in all query formula i need use ";" if I am using , I have fault On my personal laptop where I have Access2016 is working . When I copy database on pendrive and after on business laptop where i have...

sry not working

Hello. Basiclly column p1 is long text "Test End: 20.08.2018". P1ok using middle function to cut this text . After cut I have 20.08.2018. And this is imput for CDate

Input in p1ok is exqmple : 20.06.2018

Hello, Strange situation In query i have CDate(Format([p1ok];"00000000")) - which should convert string from p1ok column to date . It is working on 2016 Access. When I copied to access 2010 is not working and is showing error in this column Anybody know why ??

Thank you everyone for help. All done !!!

sample now :)

sample:

almost. It is creating row each time I have: P1 P2 Data1 Empty (files1) Empty Data2 (files1) Data 1 Empty (files2) Empty Data2 (files2) I need more like Data1 Data2 in one row

Thank you arnelgp. It is working perfect. I just modify code to get line 8 and 9 from csv. One issue which still casing problems is that all information are in the same column Is it possible to import i=8 to p1 and i=9 to p2. I try to use another if with update statement but didin't work

OK last problems :/ I was able to import what i want. Now how to create a loop (i think) to get path from tblPath column Pth import first row then get next path from second row and import and then get next path import ........loop Below code . On red is a open statement where...

Below I posted my code. I do not fully understand how to insert your suggestion. Private Sub Form_Timer() DoCmd.SetWarnings False DoCmd.RunSQL "DELETE * FROM files" DoCmd.SetWarnings True Call ListFilesToTable("E:\UTC\Vizualizacja\A") DoCmd.SetWarnings False DoCmd.RunSQL "DELETE * FROM...

Yep that true. I am using/learning access from 1 year . My base to solve issue which are to big for me is google .forums where I can find code or similar code and after i am trying tu understand this code and apply to my access database. In this case I was able to find and store path for all...