Search results

Hi guys, just wondering how you can save threads you find interessting or particular posts in the forum? Cheers

Hi Doc, Thanks for that info! But what I did is deleted the subform and pulled it back in to the form and it worked again. Well easy enough pff.. But good Info and will keep that in mind if those kind of things would happen again. Cheers

Hi guys, for some reason I can not see my subform anymore in the mainform. Property is set to visible = true on the property Sheet. I got two subforms on my form and updated the second subform on Load Event to hide some columns in that subform. However now I must of done something to hide...

ah ok.. So when do you use what? I mean I can always edit the form can't I ?

But the Me.requery I can leave out right?

hmm I am not sure why it did Now I did change it to if isNull (me!CustomerID)...

CustomerID is correct. It opens ok without me.requery and for double click event I have following If IsNull(Me!CustID) Then MsgBox "Bitte wählen Sie zunächst einen Datensatz aus." Exit Sub End If DoCmd.OpenForm "frmCustomers"...

So you don't need requery? And is it also the same in an endless subform? Cheers

Hi guys, can't find the post and was wondering if someone can tell me if that code is correct? I have a main form in the header I have a button. in the detail secton I have a subform. This is the code I am useing. If IsNull(Me!sfmAllCustomers!CustID) Then MsgBox "Bitte wählen Sie...

Hi thanks Pat, I will look into it and also post without relevant tables. Just in the middle of something but I will get back to you! Cheers for your input and help"

ok On the FK Fields you mean? PrimaryKey remains as No right?

I mean when you delet the 0 on the Property Sheet Attached

I am in Austria and still there are just two one tax rate in Services or Products. Every sold Item in my case is a rate of 20% I have my tables at present set up so they are with envorced integrety but left the 0 out in the properties. hmm what does that mean sorry never heard of it is like...

Just hour or piece TaxAmount is the tax rate Services is just something we did like Servicehour or some kind of Product we use for billing. So take it out of the Services.. So in Services you would just have a description on what has been done.. And how would you go about entering something...

Hi guys, I am just wondering how you go about following. I got an Invoice Details form as a subform where I like to select "Services" I have done. However what if I like to enter a one of in the Invoice Details form. Meaning leave the Services out and enter in Description and Price without...

Yes more or less. Generic parts like nuts and Bolts or washers could be bought somewhere else to in a Warehouse or something like that. But not really relevant in that case. Using your example of your Honda :) : You bought the Hoda from a dealer, after a while that poor Lady does not start...

Hi, thanks Pat but this drives me nuts this model.. Not sure how many times I tried in different ways of getting it right but still no luck. Drives me nuts. 1. The Manufacturer is also the supplier! 2. Parts are for Maintainence Work, Parts come form Manufacturer/Supplier 3. Parts are needet...

Hi again, sorry for the late responds.. Had to sit back and think about the structure a bit more. I changed Products to Parts which is more appropiate as we receive Prices from Suppliers for SpareParts. Further more I have included ModelParts as a linke Table to Parts and Models Each Model...

Sorry to be a pain guys, just updated the Relationship and was hoping to get some feetback. At present I have Products and SupplierProducts nearly the same just for the sake of getting all Data into the Database. Marked as red is what I believe could be deleted. Would that be ok like this...

hmm ok I understand Pat. But I guess in that case it is to much anyway. I guess I just have the junktion table and then work from there as suggested above. So you would work with a Structure like this below the SupIDRef ist red crossed out so I will delete it after. Would you then Link...