Recent content by Zerothi

Well actually it's the plumming/electrical/shafts/airconditioning installations in the building... Those being very specific. Down to what name of the model of device in every place... If i wanted i could make a table with presets for every fabricant on the earth... But that might be a BIIIIIIG...

Ahhh i see... I wouldn't have guessed that from normalization... I thought of that as splitting tables up, which had numerous reoccuring information... Many thanks for the replies... I will look in to the modification of my database for such a solution!!

What i basically have is a house. That house needs to be described in any possible way. That means 1500 individual specifications... So if i have one long table, how do i then make 300 houses? How do i assign an individual value for one of the houses to one of the rows without needing 1500...

Hi boblarson I'm not quite sure if i misdelivered my post... What i meant was that all 1500 fields are unique for each entry (yes i know, this sounds odd, but it's true!!! :D ). So essentially i needed a table which had the possibilty of 1500 fields. This can not be done in Access. Therefore...

Hi all!! I have a problem concerning many fields and their linking to each other via relations. I have one master table with an PrimaryKey (an autonumber), called intID. in this master table one enters additional parameters. In addition i have 15 tables with over 100 fields which all needs...

Many thanks!!!! I am very much obliged of your professional help!!! It is now working, if anybody needs the finished file, plz write me and i will supply the file!!! It seems as if i cannot upload... :=)

I am not quite sure what you mean... Does the subForms RowSource has anything to do with the ComboBox-control in the parent form? The RowSource you posted are not to be found in the form 'frmRoom'. But in the form sbfrmRoom. None of the Combo-boxes are based on that query, qryRoomCriteria, but...

The first SQL-code is the RowSource for the Subform, sbfrmRoom. But it's the combobox from the parent form that i can't get working. That is the comboboxes: 'ctrShaftSort' and 'ctrAptitudeSort' by name. And their RowSource, respectively: SELECT strShaftName FROM tblShaftNames; & SELECT...

Sry that isn't the problem, try yourself... If you change it to Allow Edits = Yes, then nothing happens, it is still not possible to change the combobox's value. As far as I know the Allow edits only determines whether you can modify currently accesible records. <- Nothing to do about the...

Well thanks for your try :) Any other having suggestions?

Yes that is what i need, the dropdowns should act as searchmethods. In the vba-section i have a macro that sets the sql of the query so the right information is fetched. The two drop-downs fetches data from two different tables, i should then be able to select items in the drop down so that...

I ain't that used to access Please, how do I then join the tables. I have tried relationships, but that didn't work... Hope you can help! ;)

Hi all, I think it's best to submit my file. in the form "frmRoom" there is two Comboboxes (up in the top, above the subForm) containing table look-up from "tblRoom". Now I have no idea why they are not editable.. I have tried replacing them with other Comboboxes, with no help. Any help...

Use the VBA Hi Amelia One idea is to make a macro in the VBA editor then do something like this: Private Sub drobDownName_AfterUpdate() Dim checkString As String checkString = "School" If Me.drobDownName.Value = checkString Then 'this is where you make you checkbox visible Me.checkBox.Visible...