Search results

Hi David, I tried your code but unfortunatelly that does not change it.. Same issue Cheers

Hi, I just checked the "LongText" field for the Data and all went in correctly.. Not exactly sure why it does that but as I mentioned it is not the end of the world so I just need to see which option is best suited. Cheers anyway )

Btw is there now a button somehwere to close the treat or does it stay open?

In my database are no spaces in table names but I am aware of that thanks for pointing it out Eberhard. @Gasman.. it was all performed via vba and no concatinations in a form.. And yes there was also missing a space lol but I tried so many different things got stuck .. Anyway it all works...

Hi guys, could not find proper help from the net and maybe some of you guys know what the issue could be and if there is a way to go about it. Via VBA I am importing CSV Files into my system and for that mater I need a LongText "Memo" field However I am updating that field via code ...

Hi Gasman, sorry for late responds.. was not on No there was no concatination...

Hi Gasman, hmm not sure if I am honest.. I tried with debuging but was not able to spot it.. :( Sorry

Thanks You Eberhard!! Thats the way :-) Cheers!!

HI Gasman, yes I did debug.print and if I run SELECT * Into Test FROM Table1; it works.. but I would like to have Test and Table1 as varibles so I can use the same query for different tables .(

Hi guys, unfortunatelly I can not figure out what I am missing or doing wrong with following SQL String and it feels like I tried all but am not able to get it run without errors. I like to Create a Table from an Existing Table .. Can someone please check my SQL String? Many thanks Albert

Hi Eberhard, many thanks for your reply! I will try that out and see if I can manage. Cheers

Hi Eberhard, the query works great in MS Access thanks again for your Help! I am not sure if I can asked that here on this forum but I like to use this Query in SQL Server.. I am getting Errors on the following statements Abs(SUM(P1.GameResID = 1)) AS won, Abs(SUM(P1.GameResID = 0.5))...

Many thanks Eberhard! I will do that cheers!

@ebs17 you gave me some queries on #23, could you please tell me how to change it to the Nicknames of the Players rather then the ID's please? I tried jut inserting the PlayerNicknames to your queries but not sure if that is the right way of doing it. Many thanks

No Problem, got it working! The issue was that the Date was bound to the form. I changed it to unbound and it is working now! Sorry

Hi guys, I have been working on this database but came accross some issue I am not able to work out and what is behind the behaviour. When I open the newEntryForm and change the date on the form to todays Date for example the first game Entry gets changed to that date. All remaining Data keep...

Thanks alot Eberhard, I will try that and see how I will go! Cheers!!

No Problem Eberhard, got it to run with a normal date field and updated the code and it runs perfektly! Many many thanks! P.s. Just got one more question regarding a query. When I like to count who played against another player how would you create a query for that? Example: Player A...

Hallo Eberhard, vielen lieben Dank! Leider sehe ich das Datumsfeld nicht mehr ist da etwas beim entpacken daneben gegangen? LG Albert

I have changed it as you mentioned. But I should keep the PK on GameResID right? And could you please help me with the frmEntryNew "Form" Cheers P.S. I think you are also a chess player? :-) knowing about the scoring points?