Search results

I want to print an attendance register for a certain Period e.g. 01.04.2021 till 30.04.2021 where the backcolour of fields for weekends and holidays are grey. Using the weekday function works fine for weekends, but how do I calculate moveable holidays, e.g. Easter Monday, Good Friday. Something...

Thanks guys - Problem solved: Private Sub tblxx_Maschinen_ID_KeyPress(KeyAscii As Integer) If KeyAscii = 44 Then DoCmd.CancelEvent SendKeys ".", True 'put a full stop in the field End If Call NumLock End Sub Public Function NumLock() As Boolean NumLock = KeyState(kNumlock) If...

Thanks for the replies! Arnelgp - the code is very impressive, but a bit complicated for what I want to do... CheekyBuddha - it doesn't work? On keypress it doesn't stop the comma from being sent unless I use cancel event. Then I have to sendkeys to get it to insert the dot..... then the...

Morning, I have a a bit of code on the presskey property in a form- If KeyAscii = 44 Then DoCmd.CancelEvent 'stop the comma keypress being updated SendKeys ".", True 'put a full stop in the field DoEvents End If which replaces the comma on the numder pad with a ".". The reason being...

Thank you!! Magic! the fix works!!

Hi there! yes I do get the error 128 = "query is damaged"? (runtime error 3340) I have just been on google a bit - I found an article (in German) which says the Update on the 12 Nov 2019 caused the problem - and that one should de-install the update as Microsoft has not fixed the bug yet - Dont...

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.