Search results

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...

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 ??

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...

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 ?

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...

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...

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, I am looking way to compare tabels or meby columns. Let say we have 7 "base" each base have about 120 elements. Some of the elements are the same . I need to create somethink to show which elements are shared and which are unique. Next step will be create query or raport which show...