Search results

Hello vbaInet I Solved it .... I just did in such way: Column Count: 2 Column Widths: 0";1" Maybe someone will need this too...

Hello Dear friends, I need your help! I played with it, searched in the web, but without any results and goals. So what I need.... As usual I use Date (Long Date) in English as default, because we use that standard at our office... But there are some kind of reports to be generated with The...

Hello Dear Friends for the reply: My Access Database Is based (Built) On Access 2010 As I know MS is developing free for use MSSQL "Express" I think..

Hello Dear friends, I have a question about connecting Access Database to SQL Server. For security reasons I want to store my access flat file data to SQL server... Which version to use, I think that I needn't the enterprise or r2 versions... I just need it only for access databases (about 15-20...

Ok then I will do as i did with the report, now everything is clear, I thought that there may be another variant of doing this.. Greatest Thanks vbaInet Your help is highly appreciated

Ok vbaInet Thank you I'll try that (Wen I change the text-box to Combo do I need something additional config for that, how do i change main filed to a second, it only shows me a main field) Thank you

Hello vbaInet Thank you for your reply.. I have also another question about this.... I want to do the same with continuous form too. I have one form which displays the records as it was described above in my report, now I need to DISTINCT the records on the continuous form... how to do this...

Hello Dear friends, I need your Help.. I need to display second field of a text-box or combo box in report (I have a text box where is displayed my Product List for Example: Main Field: Field Description DESKTOP | Translation In My Language SCANNER | Translation In My Language PRINTER...

Thank you vbaInet for the suggestion, I changed it to Distinctrow, but not worked: SELECT DISTINCT [QUERYDATA].Product, UnitPrice, SumAll, DateOfPurchase, Account, AccType FROM QUERYDATA; This is My Variant and working then changed to SELECT DISTINCTROW [QUERYDATA].Product, UnitPrice, SumAll...

I Solved It SELECT DISTINCT [QUERYDATA].Product, UnitPrice, SumAll, DateOfPurchase, Account, AccType FROM QUERYDATA; Seems Working

Hello Dear friends, I have a question. I want to hide or not to display duplicated rows in access report. I have created a special report for access where the product list is displayed. Record Example: # Product | UnitPrice | Quantity | SumAll | DateOfPurchase | Account |AccType |...

Greatest Thanks Larry Works Perfectly :)

Hello Larry, I have one question if you don't mind help I have this VBA they're working perfectly, now a Question How i can =DSum everything as One VBA Code =DSum("Unitprice","DATA","Account= 'Budget1' AND AccType = '013'") =DSum("Unitprice","DATA","Account= 'Budget1' AND AccType = '064'")...

Thanks lcook1974 Worked perfectly, This is what i needed Greatest Thanks :)

Hello lcook1974 Thank you for your reply... I think that this VBA is complicated variant, I need something easy like: =DSum("Unitprice","DATA","Account= 'Budget1'") This is working, but i just want to add one Field With Value: AccType = '013'") I added this, but something is wrong, I want them...

Hello Dear friends, I need your help... I have a database in which I sum Price, I'm using the VBA =DSum("UnitPrice","DATA","Dateofpurchase >= #01/01/1998# AND Status Not In ('Removed')") I works but I need to add some criteria.. This variant sums Unit price from 1998 till now. I added some...

No ideas, No Solutions? :(

Hello Friends I need your help, I played with it but without any results. I want to change selected field font In Datasheet View with VBA or if there is another method. P.S. I can Change whole Datasheet font and sizefrom VBA, but i need selected field only... Me.DatasheetFontName = "My Font...

Hello BobLarson, How're you, how is life? I was searching for this and found your Sample here... Works Perfectly, Greatest Thanks!

Thank you John Big Booty Given Article helped With Best Wishes