Search results

Hello, with parameters I mean figures that need to be stored in the database about the machine when making a product. For example the machinespeed is a parameter or the steampressure is a parameter. I hope this is clear for you? Thanks for the help, Sven.

Hello, I'm sorry but I don't understand what you mean by foriegn keys ... Best regards, Sven.

Hello, thanks for the information, but I still can't solve my problem. As you asked the explanation about the tables: there are 5 tables. The first table (machine) is about machines that exists in the factory: machineID = PK about the machine machinenaam = machinename actief = active...

Hello, I have some trouble with creating the right relationships between my tables. What do I have so far ... I have a table called machine tha is linked to a table machineparts (machineonderdelen) that again is linked to a table parameters (kwaliteitsgegevens). Now my problem is the next...

Hello, I just did the debug.print and as I expected there is nothing wrong with the sql ... there has to be a problem in the code below. Sven.

Hello, but as you can see this strsql string is also being used as a recordsource and this gives no error! So as far as I can tell there is no error in the strsql. Sven.

Hello, this is the total code: Dim strSQL As String Dim Aantal As Long strSQL = " SELECT Werknemers.Personeelsnummer, Werknemers.Achternaam, Werknemers.Voornaam, Werknemers.[In dienst], Werknemers.Ploeg, Werknemers.[Soort contract], Werknemers.Telefoonnummer, Werknemers.[GSM nummer]...

Hello, I am getting an error, values are missing error -2147217904 Sven.

Hello, I tried it this way but it doesn't work: Dim strSQL As String Dim Aantal As Long strSQL = ... [Forms]![FrmBewerkenPersoneel].RecordSource = strSQL Dim Rst As ADODB.RecordSet Set Rst = New ADODB.RecordSet Rst.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic...

Hi, personeelsnummer is the primary key

Hello, this is my sqlstatement: strSQL = " SELECT Werknemers.Personeelsnummer, Werknemers.Achternaam, Werknemers.Voornaam, Werknemers.[In dienst], Werknemers.Ploeg, Werknemers.[Soort contract], Werknemers.Telefoonnummer, Werknemers.[GSM nummer], Werknemers.[Uit dienst], Werknemers.Statuut...

Hello, is it possible recordsource to make a recordcount when the recordsource is based on a strsql? For example: dim strsql as string strsql = "..." me.recordsource = strsql how can I count the number of records from this recordsource? Thanks, Sven.

Hello, I have made the example. If you open the form, change the first field and go to the second the sql is giving an error! Thanks in advance, Sven.

Hello, both give the same error ... this is a strange thing.

Hello, indeed I forgot to copy the currentdb.execute strsql to the website but anyway I still get an error when executing the strsql syntaxiserror operator is missing. Sven.

Hello, I tried several things but this is the last sql: Private Sub txtuitnodiging_AfterUpdate() Dim strSQL As String strSQL = " UPDATE Bestandlocaties SET Bestandlocaties.Locaties =" & [Forms]![FrmBeveiligingsbeheer]![txtuitnodiging] & " WHERE (((Bestandlocaties.NummerId)=1)); " End Sub Sven.

Hello, I really don't understand this at all: Below a working query: UPDATE Bestandlocaties SET Bestandlocaties.Locaties = [Forms]![FrmBeveiligingsbeheer]![txtuitnodiging] WHERE (((Bestandlocaties.NummerId)=1)); If I change this in a string it doensn't work? Why? Best regards, Sven.

Hello, I still get an error 3075 syntaxiserror ... I don't understand why but I think it has something to do with the fact that I update a string like "c:\database\documenten\test.doc"

Hello, I put everything in a table and now I want to make my SQL: UPDATE Bestandlocaties SET Bestandlocaties.Locaties = [Forms]![FrmBeveiligingsbeheer]![txtuitnodiging] WHERE (((Bestandlocaties.NummerId)=1)); i change it into strSQL = " UPDATE Bestandlocaties SET Bestandlocaties.Locaties ="...

Hello, in my database I have to open a word document by pussing a button. Now the location of the word file is hardcoded. Something like c:\database\test.doc I would like to change this in such a way that everybody can change this location (in a form). Do I have to store this location...