Search results

Hi all, Hoping someone can give me an idea how best to do this. Background: My DB is the administration of a day care centre. I have a list of clients, and the days they have chosen to attend. eg. Monday and Friday or Tuesday and Wednesday etc. ( as check box) Now I need to print a monthly...

Thanks so much from Germany to USA! - Works fine Have a great day! Marion

Hi all, I have created a report to print address labels using the wizard. It works fine for one client after another - but I want to print 1 page of labels for the same client. If I do openreport.... etc. where Id = me.ID (Client is the selected record on the form) I get just 1 label, not one...

Thanks so much! Works like a charm. M

Hi all, I have to check the "access level" of the current user and close the form if the user is not supposed to have access. I have put a bit of code on the On Load Event of the form. This works fine, and even displays my message "Access denied" Now I have tried putting docmd.close or...

Thank you so much! Have just spent 2 hours at a customers office trying to figure out what went wrong!! After decompiling, recompiling, copying all the files to a new DB, compacting, repairing, recreating the accde on the local computer, etc...... I gave up, loaded a full version...came home and...

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...