Search results

Hi all, My last obstacle before finishing a big database is getting the summary form correct. This is going to be a long post, but i need help to make my VBA code simpler (if possible). Right now it takes about 15 seconds to do all the DLookup`s. I have an unbound form (frmSummary). There are...

Hi, Probably an easy question, but I havent found any good answers to it. Say you have a code with several If statements. Something like this: If me.checkbox = true then If msgbox ("Do you want to continue", VbYesNo) = VbYes then docmd.openform "formB" else Cancel=true End if End if In...

Hello all, I have a problem with my forms OnCurrent event. It does not fire when I move to the first record. The problem lies with the AfterUpdate event for a listbox that is on the form. This problem have been argued on several forums, but i have not found an answer on how to go around this...

Hello all, I am writing av event in the NotInList event of a combobox. The combobox does a lookup in another table and returns the value to a textbox in my main form. The lookuptable is tblSvarTypeSporprøve. It has 3 columns: - ID - Type - Category Its purpose is to show the answer of...

Hello all. Again I come here for help. I need some help writing, what I think, must be an easy code. I have a form "frmItems" listing every item in a shop. Connected to this form is "frmItemLocated" which tells where exactly each item is stored. The "tblItems" is the parent to...

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"...

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...

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...