Search results

Hi all I have a problem with selecting certain records to print in a report, My aim is to print all Orders that have no delivery date and where the expected Delivery date is < todays date. I have tried this : Printkriteria = "IsNull([DateDelivered])" & "and " & "ExpectedDelivery< " &...

Just to add to this: I have to first check that there are records in the recordset subform. If not an error occurs. So I ended up with this which works fine If Me.frmsubform.RecordsetClone.RecordCount = 0 Then Me.Restzahlung = 0 Else Me.Restzahlung = Nz(Me.frmsubform!sumendpreis, 0) End If...

Putting the code on the unbound text box on the main form did the trick

BINGO! Thank you sooo much. Have a good day!

wow now this is the wierdest thing! If I just select a client it doesn't show the amount BUT If I put a stop in the code and run it line by line it's perfect. How can that be!:unsure:

I select the client from an unbound combo box in the main form

Hi there, I have a sub form listing various transaction for a client. It displays in Datasheet form. I have put an unbound field in the foot of the sub form (nz(summe(endbetrag);0) Now I want to display this on the main form when the client is chosen, (forms are linked by id to clientID) It...

Hi there! Yohoo I found it thanks! For some reason the "Format(vFirstDate + 41, "yyyy/m/d")" doesn't work but Format(vFirstDate + 41, "yyyy-mm-dd") does! I'm in Germany - don't know if that makes the difference?

Hi Gasman, thanks for the help..... The VFirstDate has a valid date in, there are definitely Appointments in the tbl_Appointments that match the criteria, I'm not sure how to test the DateValue(ApptStart) (which is definitely a field in the Appointments table) before the recordset has been...

Hi there. hope it's ok for me to butt in on this conversation! I have downlaoded the tweaked version and find it super.... the only problem I have it that it returns an error on this line in the Public Sub "showmonthappts" Set rst = CurrentDb.OpenRecordset("SELECT * FROM tblAppointments...

Thank you all so much for the help and replies- Sorry I haven't reacted sooner, but it takes a while to check each link- I am still working on it and will let know which one I use. I also found onr by Perter Hibbs which seems to be super. Just wanted to say thanks and that I'm working on it...

Hi Everybody, I am trying to create a database for a bridal shop. I would really like to use a calender element to make appointments but Access no longer has the calender active X element that used to be in 2007. Sorry if this is a silly question, but is there another element /calender that I...

Thanks for the Input everyone. I've got it doing what I want - not very elegantly, but at least it works.

Oh dear - that doesn't work either - error - function FT not defined.. Oh sorry I see now you menat with an array...

Thank you so much for the excellent answer and the explanation! Really appreciated! I am trying to fix this code that was written in 2001.... it's even more complicated because there is a table, but only contains the Name of the Holiday and an active yes no field. Based on which Holidays they...

Hi there, I think maybe I didn't explain too well. FT1 = DateSerial(Intjahr, Monat, OsterTag) 'TM_OsterSonntag FT2 = FT1 + 1 'Ostermontag FT3 = FT1 - 2 'Karfreitag FT4 = FT1 + 39 'Himmelfahrt FT5 = FT1 + 49 'Pfingstsonntag FT1 through to FT25 have a Date value FT1 =...

Good Morning, I have a function that calculates Holidays from Easter Sunday..(thanks again to this forum) The FT1 to FT25 variables are declared as Dates. I want to send these dates to a local table. Is there a way of doing this without having to code 25 Addnews? I was think something like For...

Thank you all sooo much! Arnelgp - it worked ! It can be so easy if you know what to do!! Isladogs - that Function is the best thing since ketchup!! Thanks again

Wow! Thank you so much! I now have a diefferent Problem...Using this and the other Functions I copy all the dates into a local Table... and try th check from there if the Date is in. _____________________________________________________________________________________________________________...

Hi there, yes I have a table with the holidays I want to use. The user then clicks "yes or no" next to the holiday, but as Easter Monday, Good Friday, Ascencion Day for example don't fall on the same day every year, I am having a problem with them. If the user has clicked "yes" in the...