Search results

Hi Eberhard, thanks for your answer! So that would mean I create a GameResID as double field? And then in the GamePlays table as the FK also as double right? Then I would only need one field in the GameResult table insead of two fields? Furthermore I was not able to work out the link you did...

Hi, I have forgotten to insert Forms Sorry! Also I did update the crosstab Query with Nz. Cheers Albert

Hi, hiere is a sample Database with some dummy data and some queries. Cheers

Hi Pat, thanks also to you! I will try it with some sample data and see how I go! Cheers

Hi guys, thanks for your inputs! @plog I did some research on how others create such a Database and it was mentioned that with that type of structure queries would be a bit easier then self referencing to Player Table...

Hi, thanks for your input! But isn't that what I have with ChessEntryForm01? Or do you have a different thought about that? Further I think if I have to insert two players with each of their results wrong inputs can be entered. Like both players have won or lost.. as nothing is preventing it...

Hi guys, I have created a little Database for our Chess Club with below shown Table Structure. This is all working well and I get all relevant Information out of that database using Queries, i.e. who played on what date, who played and who won with what color played. However at present I...

Hi guys, @ebs17 cheers for pointing that out to me! I was not thinking about that! @cheekybuddha cheers I will change that! Many thanks!! Cheers Albert

Hi David, many thanks! It works fantastic!! Cheers :)

Hi guys, I like to create one filter procedure for different textboxes in a subform With this code below I am able to filter different textboxes in a subform. Private Sub txtContactNumber_AfterUpdate() If Not IsNull(Me.txtContactNumber) Then Me.Filter = "[KndNr] LIKE '*" &...

Thanks guys, @CJ_London In germany and austria for some reason are csv files seperated as a semicolom(";") @ebs17 I will provide a sample file but I am again out for work and will be back in few days then I hope things are getting clearer. Sorry for it to take some time but I am trying for...

Hi CJ_London, Sorry that this is going on for a long time! But there are just a few things that just don't work the right way. I found the issue or where the problems are: Attached are pictures of what the issues are. First of all I can not create a External Data Import if the filename is...

Yes it is called like that I will change it to no spaces No problem! Oh sorry that was just another test trying to work it out with a different table! Oh hmm ok :(

Hi Eberhard, sorry I guess there is a missunderstanding.. I just got one Table called IMPORT in my Access Database. And the source is just the folder where I got my CSV Files located.. i.E. fpath = "C:\Users\Albert\Documents\AJL\CSV_Daten\Test\MyTestFiles\" in that path I got files...

Hi CJ, If I run UsingDoa01, I get an runtime Error of 3127 Fieldnames not recongnized... If I run UsingDao02, I get an runtime Eirror of 3061.. 10 Parameters... Just ment that the Text shows with " at the beginning of the Text in the Umsatztext field Or if one field is empy on...

Hi CJ, Some date gets inserted correctly.. some other with "" if a field is empty or on the last field Umsatztest it starts like "Some text" And on some there is no Date Values in the Valutadatum or Buchungsdatum ("Datum = Date :) I will look at your post again see if I can manage ) get back...

Sorry spotet the problem! sSQL = "INSERT INTO VBImport ( IBAN, Auszugsnummer, Buchungsdatum, Valutadatum, Umsatzzeit, Zahlungsreferenz, Waehrung, Betrag, Buchungstext, Umsatztext ) " & _ "SELECT VBImport.IBAN, VBImport.Auszugsnummer, VBImport.Buchungsdatum, VBImport.Valutadatum...

Ok Thanks Eberhard! Here is what I have tried for now... There is a issue with Sub InsertIntoStatements() Dim db As DAO.Database Dim sPath As String Dim sFile As String Dim sArchive As String Dim sSQL As String Set db = CurrentDb sPath =...

You mean once it is importet in access?

Hi Eberhard, many thanks for your explaination and how you would do it! I will look into it and let you know I it went! Cheers! Albert