Recent content by jazztie

Thanks for the information, Rak! After googling on Normalization, I now realise what it is. I've build complex databases before, so that wouldn't be a big problem. (Just a challenge...) ---- Mien pilsie bin ick kwiet...

So, I need to normalize the data (I believe most of the data in the excel-sheets is already normalized) and call on the 'Analyze with Excel' function in Access. So, basically I'm calling on the PivotTables in Excel to analyze my data? Wouldn't that give me the same problems with filesize as my...

I'm currently using Excel and PivotTables to extract and analyze vast amounts of data. (up-to 25,000 records with many variables). The problem now, is that the size of the excel-file is starting to exceed its limit (130MB). So, I would like to use Access instead (it this a good idea??). So, my...

I have this form where there's mention of CompanyID In a subform, I have the information about all the contacts of this Company. In order to see full detail information for a particular contact (of that particular Company) I have a Combobox with a query. At least: that's the whole idea...

I have a subform which shows records... usual stuff. However, when I turn on the scrollbar, it always shows the scrollbar... also when there are no or a few rows in the subform. Can I make the scrollbar of a (sub)form conditional? -- so, if the form needs more than so many space because of...

Anyone? please... pretty please???

Thanx! That worked. Jazz

I have a query which is run in a subform... however, I need a value from the parent form. How do I link to this value in the parent form? The query should look like: SELECT tbl2.name, tbl.number FROM tbl1 LEFT JOIN tbl2 ON tbl1.aID = tbl2.aID WHERE tbl2.aID = parentform.[aID] Now, the...

I have two Combo boxes which work as selection boxes for the detail form. So, if one Combo box selects Name - the detail form is filled with the information belonging to that Name... However, I have two combo search boxes: one for Name and one for Clientnumber. They both work fine, but I would...

I have a form which shows contact information. I have added a combo box which automatically shows the information of the selection in the combo box. So, far no problem. However, what I would like is that (since there will be a lot of contact in it) you can search inside the combobox. Say, for...

Nope, -- same error... What about this error? Can anyone explain me what it means? I'm starting to think something else is wrong, I mean, all these examples I've tried -- all of them giving the same error... that's not logical, is it? :( Jazz

This is just NUTS!!! :eek: :mad: :( I still get the same error from Access. This is the code I have: Private Sub Arbeitszeit_AfterUpdate() Dim MyPercentValue As Double MyPercentValue = CInt(Me.Arbeitszeit.Text) * 1.25 Me.Arbeitszeit25.Text = MyPercentValue End Sub And...

Hi Godofhell, It seemed very logic to me... and it also is, but I still get an error: The expression After Update you entered as the event property setting produced the following error: A problem occured while Microsucks Access was communicating with the OLE server or ActiveX control. * The...

Hey MStef, Thanks for the example... However, I can't find the Source Object and LINK CHILD etc you mentioned. I'm using Office XP, maybe you have functions I don't have? However, I did find the relationship window - not via the FORM, but in the topmenu. Jazz

I see... I get it now... (this simple one)... I'll be back with more questions later :D Thanx! Jazz