Search results

Hi guys, need your help. It would be best if I show you example what I want to achieve. tblComment: PO Material Comment 123 Keyboard Not available 123 Keyboard Available from 23.2. 245 Mouse quality issue 245 Mouse Available Result...

Hi guys, I want to add GMT time to a field. Could you pls help me how to do that? Thank you

Hi guys, wonder if you could help me. Probably easy task. I have a aggregate qry which gives me one certain date from a source table with dates. Then I have a table with orders which contains order date. I think there is no way I can connect order table and aggregate qry. In a query from...

Hi guys, could you pls help with my issue? It is better to describe it on example. Lets say I have these rows: ordernumber / unit / qty 345 / laptop / 3 345 / laptop / 5 345 / PC / 7 345 /...

Hi guys I have a problem with sorting the data on CF_main form. Sorting according Issue, PSD vs RSD or order qty is working perfectly. The problem is with PN Desc. For some reason it is working only when I sort the data in the beginning alphabetically and then it is not cooperating. dont know...

Hi guys. I have a table and there are so called duplicate records (not entirely duplicate because there is field with the date of creation and other differences in a few fields, but from my point of view they are duplicates.). I d like to make a query which shows me only the newest record in...

hi all, I have a problem with seting up color for my pivot chart. First I set up color I want(pic 1).but then when I use filter for End Customer all the colors will revert back to default settings (pic2). Is there a way how to force it so it sticks with colors I chose? VBA code? Thank you

Hi all I have a textbox on continues form which contains multiple lines and I d like to set it up so it ll be scrolled down completely when it displays the form. I ve already found a few so called solutions but nothing worked for me. could you help me with it? thanks

Hi guys, Pls how can I modify the code below so it will display all options (not just AMAZON and ARGOS) ? I don't want to mention all of them in Array because they may change in future. Forms![Report]![Pivot_Issue].Form.PivotTable.ActiveView.FilterAxis.FieldSets("End Customer CHM...