Recent content by enfinity

Thank you guys! Do you know a simple way to make sure that the underlying db is updated when a value in the un-normalized table is changed? The code shown above only inserts the values but if the user changes values afterwards, no changes are committed to the normalized db! (I could insert...

Alright, I did some VBA coding and came up with this. Only problem: I have to confirm every time when the DoCmd.RunSQL strSQL is executed (which is 3x12 = 36 times!!!). Is it possible to disable the prompt? Private Sub cmdTransformCountry_Click() Dim BP_Year As Integer Dim CID As Integer...

Thanks! Good point ;)

Thanks! One question though: I think this part is not going to work: Select countryID, 01.02.2008, value from <denormalized table> Value is not a column in the denormalized table but "below" the column with the name "01.02.2008". I think it's gonna be a little more difficult b/c "Value" is...

Thanks Paul! I'm interested in the second option aka creating a non-normalized table and convert it by the click of a button to a normalized structure. Are there any examples available of how to do that? In my case I would have the denormalized table...

Thanks maxmangion! According to this link, I should be able to use Me!ControlName. However, it does not recognize the field.

The INVOICE_ID is on the child form. DBWIKI has a good despribtion of how to deal with forms/subform control elements. However, I cannot get it to work. The combo box is on a subform thus I would simply use Me.CONTROL_NAME. Also, when I try to use the INVOICE_ID on the parent form with...

I have a subform that is connected to the main form through the field INVOICE_ID. Now, I want to filter a combo box in the subform based on the current INVOICE_ID. For this reason I have included the following line in the WHERE clause: [Me]![INVOICE_ID]. I thought this works but evertime I...

Hi *, Currently, we're using an Excel sheet that we use for data input. The Excel sheet has the format: ____________________JAN________FEB________MAR GERMANY AUSTRIA SWITZERLAND Now, we'd like to use an Access database to save these records. The table I've already...

Hi * I have a report with 2 rows in the details area. The first row should be visible no matter what. The second row, however, should only be visible if the attribute it is supposed to display is not NULL. I attached a screenshot in order to make my point clear. As you can see, the first...

The reason I want to do it is pretty simple: The default value is based on a control element in the parent form so every time the form is loaded, the control element should display this value. My problem is that Access does not save the record unless I click in the field and type in the same...

Hi there, I have a form that I want to be opened and insert one new record into the table. When the form loads, the following happens: 1) Create new record 2) Put a default value into a control element (bound text box) My problem is that Access does not save the record to the underlying...

Ok, I found a workaround to avoid pressing F5. I simply used a macro in the first combo box that updates the second combo box. So it seems to work this way. However, I was wondering what operands are appropriate for use in a MS ACCESS SQL QUERY: I know that (1) literals, (2) identifiers such as...

BTW: the query works when I type: WHERE project_extended.CUSTOMER_ID = Forms!MyFormName!cboCurrentCustomer Notice that I did not write quotation marks or anything like that (is it really necessary to do so or not). My only problem now is that I have to press F5 after I select a value in combo...

Thanks neileg! I think Access find the appropriate values but has a problem with the data types (???). I get an error message saying that the data types are not compatible.