Search results

Well that is all well and good but I need to get this thing done and once I get closer and need to get somthing else into that database all collapses. And I am getting nowhere. Ths simpler things are done but that database need more functionallity and when it comes down to that things collaps...

Not getting anywhere really.. it drives me insane. It is part of a bigger database and everytime I like to finish it I come accross problems. Not sure how you mean it all.. I give up

Hi Pat, thanks for your reply! So if I would put Suppliers, Customers, in one table but then it would be called (Contacts) but how to differenciate CustomerNumber from SupplierNumbers and how to use Customers with their Articles and so forth. Would that not be then also difficult? Manage...

Hi guys, which way to go about following. I got a project. In a project there are several Companies involved. Companies = "Plumber", "Wholesaler", "ProjectTransmitter" (not sure how to call it best in english) It means that a Company sends us a Project. Sender is us with different Companies...

Well yes that is what I meant, now I have to enter each Private Person as a Contact as well. So I guess I add a button to the Customer to add the same info to the Contact. Ok than I do that ) Cheers

Hi, I will try that thanks!

Hi, how can I just create a Folder under MyDocuments without any of this OneDrive Extension in Windows ??? I need to add a database to a windows 11 And every time I set up a Folder for it it adds MyDocument/xxx- One Drive -xx I would just like a simple Folder no One Drive Can this not be...

Hi Doc, Ok I try to explain it a little better. I have Customers either they are Companies or Private individual People. All stored in Customers Table. Customers who are Companies can have "Employees" which I add to CustomerContacts linked to Customers. i.e. Huber Ltd can have Employees "Mr...

Hi guys, just wondering if you guys have a solution to following situation. I got a CustomersTable and a CustomersContacts Table. Now I like to record Correspondence for each Contact. So I need for Customers and for CustomerContacts a Correspondence Table. Or Add a Private Customer to my...

Hi, first of all you should name your PK's not just Id as ist is difficult to know which Id is for what Table or Form Secondly nameing the forms should also be a little different and represent that what holds the form However. following adjustments will get it working In the frmFirstTable...

Hi again, sorry been away for work the past days. Attached you can find the current relationships. Can someone take a look at it for me please and tell me if that is ok so far or what needs to be changed? Many thanks!

Unfortunatelly I can not get it to work. Tried different things but without look. It would need to be the same as if you would open the frmCustomerTab with the record selected in the sfmCustomerSearchMini sfmCustomerSearchMini is based on a query, qryCustomerSearch where I have a control...

Ok thanks guys for the posts! Cheers

Hi, thanks for your input. I believe it had something to do with the mouse rather then something with my code. Now it seams to work again. So I keep you posted if there is it again. Cheers

Ok I will try that thanks!

Hi, thanks for your reply! The button in on frmCustomerSearch Header. on that form I have a subform sfmAllCustomers. and when I select a Customer in that subform I like to open another form with that particular CustomerID I can open another form with that kind of code when I open a form...

Stuck again, sorry for posting that many questions but need to get some things done and getting stuck. What I am trying to do is open a form from a subform selection in another form. Problem is that the form I like to open has two subforms and a textbox in the header. Attached the pic of the...

Hi again, When I select a record in the datasheet view the form selects sometimes more then one record. Does anyone know what cause this issue? Cheers

Hi, ok I thought so that this might be the case. Thanks

Sorry Arnelgp did not get notification for your question. yes I did see it in design view.