Recent content by daffelito

It worked. It was because the first product to be displayed does not got any voltage, it´s a dummy, but when i added the requery in the after update event it worked lika a charm. Thanks!

I have tryed that, but it aint working.

The problem is that i dont have any what so ever information in the tblProduct that is about voltage. So if i set the forms record source to tblProduct and creates a unbound listbox with the rowsource of whats in tblVoltage i get nothing. Actually it´s showing everything thats in that table, but...

Hi. I use a form to display data of a table that contains information about the Product "tblProduct". I also have a table "tblVoltage" that shows wich types of voltage that a product can be runned on. And when i use a Query it displays the same product the same number of time as there is...

I have solved it. I rearanged a bit in the code so it looks like this: Private Sub Kommandoknapp55_Click() '---On Error GoTo Err_Kommandoknapp55_Click Dim db As DAO.Database Dim rst As DAO.Recordset Dim varItem As Variant Dim strSQL As String '--- open the table Set rst =...

Ok, i will explain what i'm trying to do (i´m using access 2000) I have a form that i use to enter data about a product. That form is bound to a table that looks like this: id (primarykey and master to ProductID in table2) productinfo1 productinfo2 ..and so on But i also got a listbox in...

I know, have corrected it now. I dont know how i was thinking realy.

Hi, I have this code on a button so that i in a single push of a button enters data into two tables that are in relation to eachother. But i don´t get it to work. It just enters the data to one of my tables The tables looks like this: tblPumpsort id - counter (primary key and parent to table...