Search results

:( it highlights the part I talked about above

Also I want to add, it is not a VBA coding, it is just a Makro that opens the Form, and when I close the form it adds a product to the list from the specific customer and assigns it a primary key

Hey Dan, I am not sure I understand, right now the problem ONLY occurs if I just added a NEW customer and therefore the ProductList is empty and my guess it is in unclear on its path as my "New Product"-form has ProductID and CustomerID connected so it knows where its place is

Hello people, My Database is running into a problem I cant seem to solve. It is at the moment build upon two tables CustomerT and ProductT I have a MainMenu->CustomerList->Customer->Produktlist in the CustomerList I can add new Customers and their Productlist is therefore empty, when I want...

How stupid of me, I obv shouldnt search from ProductT rather the Query I have assigned the Form. I will let this information stand as I find this textbox search function very helpful and maybe it will inspire people to do a similar thing in their Databases :-)

Hello there access-programmers I am having some minor issues with my current database. The way it works currently is having a MainMenu where you can either go to customers/ProductList/Product OR ProductList straight away. I have a CustomerT and a ProductT. I have made a Query where I link the...

Hey CJ I am really sorry I didnt reply to you, I did not see the post :banghead: It tells me when I plug this into the Criteria that the "expression is invalid" and then highlights the "#" & format(me.startdate,"dd/mm/yyyy") & "#"

The searchfunction works perfectly, however I cannot make my reportbutton firstly only show what I filtered for through my txtsearch field AND THEN ToDate

Hello CJ Correct, the txtsearch field is where I put my value, in this case "ProduktNavn" (ProductName) is my searchvalue. Actually I am using a Database I was programming with another company in Germany, hence the confusion with Danish/Germany/English words. Kunde is basically: "[KundeID]="...

Hello Access-programmers! It is my first time posting here, so bare with me if I do anything wrong. I am currently working on a database for the company I am working for. The idea behind this is to store informations on products we have at customers around europe. These products will have a...