Search results

Once again thank you so much! I have worked on it all day...it is exactly what I needed to give me a kick-start! We really need a kiss kiss smiley! Marion

Thank you so much for your time and effort - really appreciated. I am working through it and will let you know how I get on! Marion

Forgot to say I also need to keep a "running Balance" of their + or - hours and carry the Balance as a starting balace over to the next month. My idea was to sort of write a month end procedure..(I am very brave:D) it could obviously run more than once if for example they had made a wrong...

Hi there from Germany to Canada! Yes I do have a list of rules and they are really quite straightforward: 1. I know how many hours each employee should work a day. (7:25) 2. I know the "Frame" Timespan. (Monday - Friday 07:00 till 17:00) 3. They enter actual hours worked. I have to Report...

Hi Mark, Thanks for the answer - I thought it would be easier to store the data as I have to print various reports using the results. But still, what I Need to know is if I am the right track here - and how to compare from and till Dates to the set criteria. Something like if from_time >=...

Hi All, I am hoping someone can give me a bit of advice. I'm not sure how to do this: Basic Info: The application id for staff hours - the School has set times 08:00 till 17:00 If the Staff work outside of these hours they are awarded overtime If they work after 21:00 (Parents evening) they get...

Thank you! Works now:D:D

I think this should be easy but...... I Need to select a recordset based on multiple conditions - basically Set kids = db.OpenRecordset("Select * from qry_BeitragBerechnen where tblxx_familie_id=" & Familie!ID & " and " & "[Invbegindate]<=" & RundateEnd) This works fine but now I need to add...

Thanks for the answer. I wrote the code and it is really just These couple of lines on the "on key" of the Combo box. These are Serial numbers and the user knows that they either start with 1. or 2. or 3. All I want is to be able to do is : If the comma on the numerpad of the Keyboard is...

Hi all, I have searched the Forum but can't seem to find what I Need. I have a Combo box which contains a set of numbers divided by "." e.g.: 1.342567.24433 When looking for a certain code, I would like to use the number pad to enter the first few e.g. 1.34 to move to the Position. In...

Thats why I replace the comma with a period, then it works

Hi there Found it! The secret is to remove the comma and replace with period. anz = Me.AnzahlStd anz = Replace(anz, ",", ".") Set recs = db.OpenRecordset("Select * from tblxx_Beitrag where tbl_KIGA_ID=" & Me.Parent!tbl_kiga_id) recs.FindFirst "[AnzahlStd]= " & anz If recs.NoMatch Then MsgBox...

Hi! The Dlookup is notoriously slow. I prefer the findfirst as I don't need to find a specific record, only to know that a fee is available in the recordset I have selected for ,5 an hour. (For eg. if they enter ,75 I want a "nomatch" then an error message telling them that ,75 hours cannot be...

Hi there, Hope someone can help me out here: I have a table tblxx_Fees in which there is are 2 fields Hrs(double) and Amount (currency) Hrs Amount 1 10€ 1,5 17€ ,5 4€ etc. Now when in the billing ,5 is entered as the Hrs, I want to check if there is any Fee available for the...

Hi there, I know this is an older Post, but I have the Problem and can't solve it! I have tried the Attachment Field, but it does not Display in my Form. Ideally I would like to save a Bitmap in an Ole field in a table (I have only one in the databse.. the Logo) that I would like to be able...

Thanks so much for the reply... unfortunately still not working.. I have done a Little Workaround Set ExternKinder = db.OpenRecordset("SELECT * from tbl_ExterneGeschwister where tblxx_familie_id=" & Familie!ID) If ExternKinder.RecordCount > 0 Then ExternKinder.MoveFirst Else...

Thanks for the answer Paul... It doesn't select the records.. says it Needs another Parameter, but I can't figure out which one!

Hi All, I Need some help with the Syntax of a "relatively" simple Statement... I just cannot get it to work! I have a table with Family_Name and Birthdate and tblxx_Familie_ID: I am trying to create a recordset that selects all records that belong to a certaim Family and where the Person is...

Thanks so much! I am still working on it! Have had a few days holiday. Marion

Thank you for the reply. However, I would prefer no answer than a sarcastic one. It is quite intimidating for mere mortals like myself. If the question irritates you, then don't answer it. Marion