Search results

thanks pbaldy. that s perfect

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

I found this on another forum. Works for me. The result you will get with: msgbox ConvertLocalToGMT(Now()) The working code: Option Explicit Private Type SYSTEMTIME wYear As Integer wMonth As Integer wDayOfWeek As Integer wDay As Integer wHour As Integer wMinute As...

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

I think I got it. At first using aggregate query I create a so called "aggregate" table where I can store sum of qty. Then I delete duplicates using method described here ( http://www.satorisoftware.com/support-article/eliminating-duplicate-records-in-microsoft-access/ ) . I chose alternate one...

new table with actual data will be imported every day, thus every day needs to be done this aggregate query.

I need to replace them though. Otherwise the table is useless. any idea?

thanks guys. Now I remember I already used aggregate query before, but after a year I am back in Access and I forgot most of the stuff. And what would be the best way to replace original lines in source table with these aggregate ones?

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

you are right. even in the report table is the same problem. I have found out that problem is when a column name consists 2 or more words and one of them is "Description"...sounds weird but after I renamed the column everything works fine. thank you

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

Thank you guys. You were right. I solved it using Group by query and sub-query.

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

That s perfect, man. I knew there had to be a way using VBA. Thank you very much :)

e.g. If I choose only H customer on End customer filter and then again display all of them, colors for ">=8", "6" and "7" will change. Only color for "<=5" will stay as it was because it s the only color (column) which is visible for H customer. I am using access 2007.

There u go, You can try it either in Form CRAD or CRAD_chart. Change end customer filter and u ll see how some color revert back to default settings. thank u

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

That is what I was about to reply. When it loses focus it will revert back. I ll present possible solutions to users and they ll decide. Anyway thank you guys.

spikepl, thank you for your idea but unfortunately it doesn't work on a continuous form.