Search results

Wow again thank you so much. If you ever in Germany please come round! I owe you one big time-We have really good wines in our region

Good morning Arnelgp! I cannot thank you enough for this sample DB! The concert is on the 5th Nov. and ticket sales are really coming in now so I am under a bit of time pressure. You have made my life sooo much easier. I just have one question :) I actually posted an older version of the plan...

Hi there! Sorry found it! I hadn't unblocked the db!

Hi there! Wow I can't believe you did the whole thing for me! Thank you so much!! I just have a problem... when I open the DB/form I get an error message (on mousemove) -Sorry about the German:) Basically it says there is a procedure on mousemove that access doesn't recognize? I have tried...

Thank you all so much for the advice/suggestions. Just to let you know I am working on it and "following up all the leads" I will post again when (if) I get it working Marion

Thanks Gasman, will look into that

Morning all, I have a small application where I sell tickets for concerts in a hall that can seat 720 People. At the moment I enter the name and address in my tbl_Customers, then in a dropdown list from my tbl_Seats I select the ticket Numbers (seat numbers) . After Update I enter the info into...

Thanks Pat! Feel so honoured that you answered :) I have it working now with some help from ArnelGP and a little research. I have the Summary in a subform and edit/add as needed. Works fine thanks again to all

Thanks. so much I am working on it.

good morning all, I hope I can explain my problem "understandably" On my main form (Customer) I have a sub form where concert tickets are selected (Category 1 or 2) for the selected customer. Now I would like to add a new record to a "summary" sub form. I have made a recordset clone of the...

Thanks everyone It works like this: DoCmd.SetWarnings False DoCmd.RunSQL "Delete * from tbl_Kett_Teilnehmer_Vorauszahlung where tbl_Tour_ID=" & Me.Toursuchen & " and " & "tbl_Voraus_ID=" & Me.Voraussuchen Me.Refresh sqltext = "insert into tbl_Kett_Teilnehmer_Vorauszahlung([tbl_tour_id]...

Hi all, I need a bit of help please. I have this sqltext that works fine but I want to add another field that is not in the source table, but in a box on the screen. sqltext = "insert into tbl_Kett_Teilnehmer_Vorauszahlung([tbl_tour_id], [tbl_teilnehmner_id])" & _ " select...

Basically I just want to know if there are records in the subform. If I select a new client, before I have entered any items in the subform an error occured, if I reference the field on the subform. This way I thought I could just count the records in the subform (for the client in the main...

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