Search results

Hi Pat, No not the user - I am trying to include this in an automatic Version Update - of course on the back end Tables. Just a once of converting the back end from Version 1.09 to 2.00 Thanks for the input

Hi there, I am trying to change the caption of a field in a table per VBA. Set td = db.TableDefs("tbl_Dress") With td Set fld = td.Fields("DPurchasePrice") fld.????? = "Einkaufspreis" td.Fields.Refresh Cn anyone tell me how to reference this property please? Sorry, I am using a German...

thanks so much! This works well for the field in the main form. I know I don't need 2 fields displaying the same but I am really puzzled as to why it doesn't work in VBA. (Unbound Field) Thanks again

thanks so much for the answer. Unfortunately it does not seem to make a difference. In the screenshot 1 is the Field with the control source set to =[subform_name].[Form]![endamount1] on the form before a customer is selected. on the second screenshot is the field showing correctly when records...

I have a very strange problem. Background: I have a main form on based on a table. I have an unbound combo search field on this form. After update I select the correct record from the table to display (recordset bookmark). I have sub form on the main form containing transactions pertaining to...

Thank so much to everyone for the very helpful hints and answers. A very special thsnks to arnelgp! I have a very nice little system up and running - Apart from a few minor updating of forms that I'm still working on Couldn't have done it without you all! Thanks again!

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