Search results

I would like to thank everyone for taking their time to help me. Everything is working perfectly! Only problem is that now i get a enter parameter error message when loading the form in my navigation form. But I will try to make my own navigation form instead. I did a lot of googling before...

Yes, cities table includes CountryID field. Yes, i meant VBA, not VCA (typo). Thank you so much for your help Ridders, IT WORKS :)) Now i need to find out how to refresh the subform so the listbox with cities updates each time a new selection is made in listA (countries). Anyone have any...

Thank you everyone for taking the time to answer my question. I am sure that all suggestions are good, its just I cant make any of them work in my database. My biggest issue is that i cant understand why your suggestions wont work. I thing the problem must be in the query rowsource of my...

I have tried that - several times in many different ways. It must be something i dont understand. Since the first list is on the main form it uses the main form ID (main_ID). The list on my subform uses sub_ID as primary key, but also it has the main_ID. I try to use this WHERE condition in the...

Hi, I am currently working on a database that register recieved packages. I have a registration form (main form linked with a subform). In FormA i have a listboxA containing "FormA_ID (primary key)", "arrived_date" and "Lot_number". In FormB i have a listboxB containing "FormA_ID", "type"...

Sorry, the code I am using is this: DoCmd.OpenForm strform, , , , , , "Beslag_ID=" & Me.Beslag_ID I get the error message: "Run-time error '.2147352567 (800200009)': The value you have entered is not valid for this field (translation from Norwegian)

Hi all, To registrer items I use a main form connected to a subform. These to work perfectly together. In the subform there is a combobox with 15 different alternatives. In the subform i have a button called "details", and when clicked it launches a new form based on the combo box...

I found out what was wrong with my code - the combobox selection is case sensitive. Thats why the IF-statement failed, because i did not capitalize the first letter in the cbo-selection. I see that i get advice to do this differently. Is my way a bad way of doing this?

Maybe inventory was not the best word to use. I work in the police and I am making a databse for registering and viewing items in evidence. There will be a different database from case to case, so the total number of registrations will range between 200-500 items. Thank you for your help. I...

Hello all! I am not an expert in programming, but I manage simple VBA coding in Access. I have used the last few days searching online for a solution to my problem, but still havent found one. I think the solution is quite simple, i just cant figure out what it might be. I am building a...