"New Product" Form wont open

[iskov]

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 to add new products I get an error message, I dont know the exact translation in english "Typen Unverträglich" (See Screenshot attached)

If I press OK I get the message with Error2950 (See error2950 attached Screenshot)

The problem occurs ONLY when the list is EMPTY and not if there are products already in the list (See example attached "AddNewProducts")

I have given my database a "trusted path" and tried alot of things, none seem to work

I really hope people will take the time to try and help me out

Thanks in advance
Anders Iskov

EDIT: Opret Nyt Product means Add New Product

 

[BlueIshDan]

Type Mismatch?

It doesn't look to me, from the screenshots, that you're working with much VBA.

So my first guess is to go and look at your table's design views and make sure that any fields(that you're linking between tables) are of the same data type.

 

[iskov]

Type Mismatch?

It doesn't look to me, from the screenshots, that you're working with much VBA.

So my first guess is to go and look at your table's design views and make sure that any fields(that you're linking between tables) are of the same data type.

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

 

[iskov]

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

 

[iskov]

Could anyone possible help with this problem? From what I understand is that it can not specify a position as it is usually get the ProduktID<->ProduktID from the other products already loaded into the table

 

[iskov]

Bumping one last time for help or ideas

 

[JHB]

Could you post your database with some sample data, (zip it)?

 

[iskov]

Hello @JHB I am unfortunately not near my database currently as my laptop is not in the house. I would like to put it up as soon as it comes back. how do I put it up?

 

[JHB]

When you replay to a thread, scroll down a ½ page then you'll see a button "Manage Attachments", click it.

 

[iskov]

When you replay to a thread, scroll down a ½ page then you'll see a button "Manage Attachments", click it.

Right, got it, I will come back asap, I have a feeling the technicians will take till tomorrow though.

 

[JHB]

Okay - by the way are you Danish/German?

 

[iskov]

Okay - by the way are you Danish/German?

I am danish and is currently working on a database inspired by one I made in germany for a subsidiary, however I had alot of help with especially programming of the database hence my limited accessskills

 

[iskov]

When you replay to a thread, scroll down a ½ page then you'll see a button "Manage Attachments", click it.

Godmorgen JHB

I am getting this message when trying to upload the DB

"Your submission could not be processed because a security token was missing.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error."

Hjææælp

 

[JHB]

Har du zippet filen?
Det er ikke dit netværk der er noget galt med?
Prøv at genstarte!

 

[iskov]

Hvordan er det jeg zipper sådan en fil?

 

[JHB]

I Windows 8 - marker filen - højre klik, vælg "Send til".
Hvor stor er filen - der er en grænse på 2MB her på forummet.

 

[iskov]

Den er desværre for stor ser det ud til

 

[iskov]

Mit problem er egentlig at jeg har to forskellige Tabeller:

ProduktT
KundeT

Når jeg opretter en ny kunde via KundeTabelFormular og går fra den videre til ProduktTabelFormular og vil oprette nye produkter giver den et "Mismatch", så snart der er ét produkt minimum i denne tabel forsvinder problemet. Det er derfor ikke hensigtsmæssigt for enduser da jeg ikke kan forklare dem de skal ind og registrere et produkt igennem selve tabellen.

 

[JHB]

Hvor stor er den da?
Du kan evt. lave en kopi af den og fjerne alt det som ikke er nødvendig.
Er nok først her tilbage i eftermiddag.

 

[iskov]

Den er pt på 68mb, jeg ved ikke helt hvad jeg skal fjerne for at skabe så meget plads