Search results

If I hold cursor over dbFailonError it says 128 - otherwise see attachment - sorry about the German

I have now included the table name but still makes no difference - can anyone think of a reason why this doesn't work? The value of the variable 2 is correct in the debugger? db.Execute ("UPDATE Loktbl_LOCALS SET Loktbl_LOCALS.[text] = '" & s & "' WHERE (Loktbl_LOCALS.bezeichnung)='mdbPfad'")

Hi updates say I up to date:) So frustrating - also compiles with no errors

Hi I have only just installed the Microsoft Office Professional Plus 2019 in the last couple of minutes. I hope all Patches are there but will try now thanks

Good evening all, In an Access 2016 database I use: db.Execute ("update loktbl_Locals set [text] = '" & s & "' where bezeichnung = 'mdbPfad'") In the table loktbl_Locals I have a field named "text" and one named "Bezeichnung". The Variable "s" here holds the path to the Data (back-end...

Thanks Plog, Have got this working now. I used a recordset, which I filtered by Employee_ID, then used a findfirst with the dates as criteria. Works well.

I am now using Access 2016 in Windows 10 on a 64 bit system. I used a browse for file Code on my Access 2013/Windows 7 before where I had a form with a common dialog control to browse for a file (to reconnect my back end database). Now it is not working. Have tried: Reinstalling and...

Hi there and thanks for the help! I'm sorry if seems abit mixed up, I try and change the german terms to English when asking a queation as I think it might make more sense then. 1. Is tblxx_Personal_Id in tbl_Rates?.. yes it is Your last dlookup seems exactly what I want, but I also have to...

Hi there, Is anyone willing to help me a bit on this: I have a table tbl_Rates which holds the amount an employee would be payed within a certain time limit. eg. 01.01.2016 till 31.12.2017 - 50 € 01.01.2018 till 31.12.2018 - 55 € 01.01.2019 till (is null) -60 € Now for reporting purposes I...

Thanks, I have tried that as well. I have made a new form, using an unbound control to input a date. The name of the unbound control is "txt_fromdate" . Then I put another control called txt_day on with =format([txt_fromdate];"dddd") in the control source. When putting this expression in...

Thanks again, I think I have ruled out reference issues. Also the field [fromdate] is definitely defined in the underlying tsble. What confuses me is that I have not changed the accdb at all from running on my old laptop with access 2013. I only transferred it to my new laptop with access 2016...

Thanks for the answers - unfortunately the problem remains. I have compacted and repaired both Backend and front end. Reconnected the tables, no references missing, decompiled and recompiled, added new unbound fields which show the same #name. The name of the unbound control is txtday and...

Hi! yes it is in German. It's always worked with a semi-colon on forms and reports and with a comma when used in VB in Access 2013 - its only since using (or trying to use) Access 2016 that it doesnt work. Strange that when I redo it it actually suggests the format function--

The comma only works in VB, not in the controls on a form or report. Here the semi-colon should work. In the attached, the day should appear below the date.

except it's everywhere I use the format() function. Not just on one control. I feel like I'm going bonkers!

Thanks for the reply. Nothing seems to be missing ... I can compile with no error messages as well. Just seems to be on the controls on forms.

Hi there, I have just updated from Access2013 to Access 2016. All my Forms and Reports with the Format function in show an error. =Format([fromdate];"dddd") just displays #name. What to do now? If I add a new field it seems as though the format function is still there. Can anyone help me out...

Oh wow! Thank you so much! Easy when you know how. Works great! Marion

Hi all, I know this is an age old question but I just can't get it right. I have to display -0,029171 as time 00:00 I use this formula in an unbound field on the form =([zuvielstd]*1440\60) & ":" & Format(Abs([zuvielstd])*1440 Mod 60;"00"). It sems to work fine unless the first part not a...

Sorry folks! Post to hasty! Problem solved.... Dim I as date of course. Everything works fine now.