Recent content by jera

Hey guys! A form displays information on a construction site in various text boxes. I want to enable the user to change this information but not until a save button is pressed. Now I have the problem that as soon as I change the value of a text box, the data in the database is updated. Is...

Sorry, I forgot that I get the error message Run-time error ‘3061’: Too few parameters. Expected 1 but the value of the insert variable is the following: "INSERT INTO Begehung (Datum, Baustelle, Montageleiter, Sicherheitsfachkraft, Leitung, QM, Dateipfad) VALUES ('23.03.2013', 3, False...

Sorry, I forgot that I get the error message Run-time error ‘3061’: Too few parameters. Expected 1 but the value of the insert variable is the following: "INSERT INTO Begehung (Datum, Baustelle, Montageleiter, Sicherheitsfachkraft, Leitung, QM, Dateipfad) VALUES ('23.03.2013', 3, False...

Hey guys! So I still have my database containing construction sites inspections of such. To every inspection there are minutes of meeting which should be somehow shown in the database. The user chooses the file using a form, the file is copied to a specific folder on the server and the UNC path...

Works fine now, thanks so much!

Thank your for that, date works fine now! INSERT INTO Baustelle (Projektname, Kunde, Adresse, Auftragsnummer, Division, Projektleitung, Bauleitung, Baustellenstart, voraussichtlichesEnde, erledigt) VALUES ('Test',41,42,'Test','I DT',50,46,#01/09/2013#,#01/09/2013#, Falsch)However, I still kept...

When I delete the ' I get the error message syntax error in statement blabla 08.01.2013 ..

Thanks for the quick reply! I already looked at the statement to be executed. I even watched every single variable I put into the statement for it has the right field type. It looks fine to me .. The only issue I could think of is inserting the dates into the fields but I tried several...

Hi guys, I've got a form that saves construction sites into a table "Baustelle" in a database where I can also save the customer, address, project leader and construction leader of the construction site all in different tables. I therefore only save the IDs of the fields described in the table...

I had a similar issue where I wanted to show the persons in charge for an inspection of a construction site. Therefore, I created a tabular form with the fields ID and name of the persons and deleted the field ID in the form afterwards, so the form was still linked to the field ID but it was not...

Yeah ok, so I read from that that Microsoft is not to be understood :P Thanks for the help! :)

Oh you're one wicked boblarson! And if you could tell me why the hell this one worked you'd be my hero too! What I don't really get is why Access is obviously not able to work with the format I set for the field [Baustellenstart] type date .. But anyway, thank you so much for the help, u made...

Thanks for your replies! @llkhoutx: Text27.Value is indeed not a date, that's why I have to convert it. After conversion it has the beautiful german format dd.mm.yyyy. @boblarson: As I see it the format including periods is what Access wants. I configured the field [Baustellenstart] as date...

Hey guys! So I have this form where I want to filter data by a date. At this point, I don't really care if entries at exactly this date, after or before the date are displayed. I just want it to work. Dim filter As String If Text27.Value <> "" Then filter = "[Baustellenstart] = #" &...

Hi everyone! I'm 22, female and from Austria. I've been studying computer science in Vienna, so I'm not new to programming nor databases. I've started my master's degree studies in medical and rehabilitation engineering. However, in my job as student employee I have much to do with VBA which...