Search results

I understand now . It is more complicated then i thought. Query is colecting data from table . In table i have 28 characters in one field ************_20180515_****** In the middle I have date in digits format. My query separate this in digit format - TestDate: Mid([Fname];14;8) Next...

Hi, In my access I have 6 tables . Which are fill by imported data. Base on this tables - query's and charts are working in my main form. I am looking wait to automagically import data to my tables I can do that with form Time Event but it import all data at once . I need import each data...

Hello, I have csv files in folders Test [main folder] Data1[subfolder] Data2[subfolder] Data3[subfolder] Folders are creating automaticly by external software (qty going up) . In each Data folder is csv files In this file in field A9 and A8 is data which i wanna import to table in access...

Not working . Incorrect type of data.

Hello, I am looking way to put criteria in my query which will allow to show data only 10 weeks in past from present day . What i shout put in my data column in query criteria field ?

:) Thank you very much for help. Is that what I want .

it was a rule during manufacturing process. Never mind. After internal discussion I just need regular day in year with 3 digit format

Yes exacly . I wanna include Feb 29 al the time. Even if not exist

Hello I am looking way to display in text box day of year . I am using : Dim iDayNumber As Integer Dim dt As Date: dt = Date iDayNumber = DateDiff("d", CDate("1/1/" & Year(dt)), dt) + 1 I have two problems: 1. If day in year is below 100 i have for example 89 or 7 I need to have 089 or...

Hello, During work with access I have problem with some solution. I have form when is a text box let say txtStatus. This box is bound with table column Status. What I want to do is that I will have txtStatus2 and txtStatus3 on the same form and I need to save any changes in the same...

Thank you . Perfect solution :) Once again tnx

During my work with access I stock because of some problem. Looking help with this. Let's say I have query (qryStat) which contain two columns: Color Result RED FAIL RED PASS BLUE FAIL BLUE FAIL BLUE PASS GREEN FAIL GREEN FAIL PINK...

Hello, I am lookinh way to import filename from directory in to access tabel. But I want to have imported to 3 sapereate column in tabel file name , extension, creation date. I found many codes which doing that but all copying file name to one column . Please help. Thank you

Hello. I am looking for help. At the moment i have form with combo box (cb1). This cb1 is linked to the tabele (Tb1/Column1) if i set up number in cb1 rest of field is field automatically (base on table). What i want to do is - I setting some number in cb1 and after i am pressing button (bn1) i...

Hi all. I hope you will help me with small problem. Let's say in tabel i have 5 columns .mother board,ram,HDD, graphics card ,procesor . W her i am writing down serial numbers In a form i have this column and I use them to put data in to the table. Every thing is great till I have rework or...

first 3 digit are not important at all last two also. That example is only to show what i am looking. I am not working with car parts or car. The idea is . When i will scan this number by bar code scanner that for digit should show, what should show up in other field. I am scanning number and...

Hi, I am looking VBA code to change value one of the form field base on value from other field. But to make it more difficult- If I will write to Field 1 one of below number : 858055078 986055063 123066046 987066036 then in field 2 I would like to have value deepens from that middle four...

Hi, I almost finish my form but now i am struggle with big problem . I will show all process : 1. Scan bar code to serial number field 2. Fill data 3. Fill output 4. Fill power after 24 hours 1. Scan the same barcode to other serial number field 2. Fill verification output And finish. All...

Hi, In my form I have 2 data fields where data is setting up automatically after I write down any data in related field (it is something like actualization ) date. I am looking way to lock this 2 field in this form for edit. Any way data is set up automatically then we can turn off edit in...

Hi, On the beginning sorry for my English Is the production meter . If you have 7 products and some of them are build using the same elements and we talking about machines and change overs between the product. You are looking way to optimise time ( make shorter) of change over. If you create...