Search results

Hi Ken, I'm back again... It still doesn't work. When I choose a location, again there error 438 comes up. Then you can start a VB problem resolving (I don't know if the translation is correct). It opens VB editor and a yellow line appears over the incorrect line. When I hover over the yellow...

Thats the exact line in VB code... When I place this line in the property window for the combo box it will return the error which say it can't find the macro... Weird? ;-)

This is my exact line: Me!city_id = Me!lokatie.col(1) The error message is: Error 438 during run: This property or methode is not supported by this object In VB it says: Me!city_id = Null Any idea? Thnx again and again and again! Grtz, Tim

I'm almost there I think! Only, if I paste me!myCityAbbrev = me!myComboBox.col(1) in the OnChange event (ofcourse with the right names), an error message appears that sais that the macro can not be found... Is this VBA or do I have to make a macro? I prefer VB but that has to be something like...

Thnx Ken! But I think you did not understand my question well, or I don't understand your answer...!! :rolleyes: Let explain my situation. I have a DB where I store all computer hardware of a company and its user. All computers have a unique ID. This ID will be generated by combining the city...

Hi all! First of all sorry for my terrible English! ;) I have a very simple question (I think). I have a table with 2 columns in it, filled with city names and their id's. For example: city - id rotterdam - rd amsterdam - ad new york - ny london - ld I have a form with this city-table as a...

Hi all! First of all sorry for my terrible English! ;) I have a very simple question (I think). I have a table with 2 columns in it, filled with city names and their id's. For example: city - id rotterdam - rd amsterdam - ad new york - ny london - ld I have a form with this city-table as a...

That's the problem. There are a lot of controls in my form so that will be a hell of a job! And if something changes in the form (i.e. delete/add a control) you have to remember to change that list also! :( So is there a code for all controls? Something like: If checkbox = True Then...

Ok, I found somthing which work great: Private Sub Form_Current() If checkbox = True Then Me.textfield.Enabled = False Else Me.textfield.Enabled = True End If End Sub Private Sub checkbox_AfterUpdate() If checkbox = True Then Me.textfield.Enabled = False Else Me.textfield.Enabled = True...

Ok, that's clear! ;) Only that's my question, what's the VBA code for "enabe = false" for all the controls in the form... :confused: Thnx again! ;)

Yes I have, not much, experience with VBA. And i do know the Me.AllowEdits etc. commands. But this will not gray-out all fields in the form. This will only prevent updating the record. My goal is to gray-out all fields with ticking the box. It doesn't matter if the checkbox will gray-out also...

Thanks for the replies! I read the forum and searched it but could not find an answer to my question. I knew the allow.edits thing but thats not where I'm looking for. Let see if I can change the question: How can I greyed-out all field in a form just by cheking a checkbox? Thnx! :)

Hi all! This is my first post here so my appologies if I do something wrong AND my terrible English!! :cool: I have made a database in Access where I can store all kind of information about hardware (laptop type, s/n, hdd size, memory etc.). Now it sometimes happens that an engineer will loose...