Fixed the #Name? problem (symantec issue) but it still isn't pulling the RoomDescription as it should. Here is how things look:
RoomDescription (a textbox) has a Control Source of "=cboRoom.Colum n(1)" per your instructions.
Now I followed what you were doing, in that this should pull the value of the "hidden column" from cboRoom. If I am following you right, Column(0) would be the Room #, Column(1)...
LosLobo
Last Activity: Aug 18 '08, 03:48 PM
Joined: Jul 7 '08
Location:
-
hjozinovic,
Getting closer! Now I don't get an error (I commented out my old code to try this solution) that calls up the debugger, however I am getting an unknown type error in the RoomDescription box:
#Name?
So it is trying to pull it thru but something is still off since it isn't associating what we're trying to do.Leave a comment:
-
hjozinovic,
Thank you for this creative idea. I like it conceptually, but admittedly VBA is not a language that I know very well at all so I am uncertain how to go about doing what you are suggesting.
Presently the RowSource for ROOM is determined by the code that I have already listed previously; what do I need to change to make it work the way you suggest? I am not sure also what you mean by changing the column widths,...Leave a comment:
-
I did as you suggested and got the following error:
Run-time error '2465': Microsoft Office Access can't find the field "Building" referred to in your expression.
Here's the thing ... in the code itself, on line 3 (IF IsNot NULL ...) the value of Building is 1 (at present) because I am using the first building. Perhaps I need to pull back and give a broader view of this issue. I created a dropbox on the form...Leave a comment:
-
Well I would be the first to agree that (in hindsight) this is getting a lot more convoluted than I had originally intended it to become. I think my logic/thought process on what I wanted to see happen was sound, it just became difficult to make it happen based on the field types (it didn't occur to me at the time that I created the database).
I have inserted your code, however I get the "dreaded" error code 2001 "You...Leave a comment:
-
Another question I have ...
I understand the data type issue outlined above, however when I am in the VBA debugging mode and move my cursor over line 6 (above), specifically over "Me![Building]" it gives me the following subtext (value) for that code:
Me![Building] = 1
Ok, so the good news is it is reading the value as the numeric equivalent (instead of the building name itself) which...Leave a comment:
-
Ok, fixed that problem (needed to change the second BuildingID to Building) but now I have a mis-match in data type. Here is the code:
...Code:Private Sub Room_AfterUpdate() 'Make sure both the Building and Room Combo Boxes have values in them If Not IsNull(Me![Building]) And Not IsNull(Me![Room]) Then ' Lookup and Insert RoomDescription into the RoomDescription box on form Me![RoomDescription] = DLookup("[RoomDescription]",Leave a comment:
-
Adezii,
Ok, first thank you for all of your help. I have tried your code, but I am getting some errors in it, which appear to be symmantic, but I am still trying to figure out where that particular problem is. Everything you have there appears as though it should work fine. I am still learning the code, and admittedly keep forgetting about DLookup, but your query should work just fine. Instead I get the following error:
...Leave a comment:
-
I would be interested in seeing any list of books you, Stewart or anyone else would like to recommend. Though this isn't my thread, I too am always looking to learn more and there is always something new I didn't know before. :-)...Leave a comment:
-
I've looked up the error code with Microsoft Support and it seems to have to do with Windows 95 ... umm ... alright. That made no sense, so I went back to Google and found another gent who has had the same error with one of his bits of code. From this it sounded like the error is occurring because it doesn't like my object, in this case the Me!Room in line 8.
Now what I don't understand with that is if it didn't like it there, why...Leave a comment:
-
Okay, I killed the control source so that the field is considered UNBOUND now (duh, not sure why that didn't occur to me previously ... it's early and a Monday :-) but my code isn't working. I had a similar variant of what you had suggested but the only place I can think of putting it is in the "AFTER EVENT" for ROOM in order to create the row source for RoomDescription . Either this is wrong (as it isn't working) or I'm doing something...Leave a comment:
-
ADezii:
Thanks for this code. Here is the scenario (basically):
User selects Building from drop down list.
User then selects room number from drop down list which is auto-populated based on the Building selected (this coded as an "AfterEvent " in Building Properties).
The goal is for the associated room description to automatically populate once the room number has been selected (user...Leave a comment:
-
Cascading List Problem
Greetings all. I know that cascading lists are a common problem and in truth I my initial post here was to request help with my own, but then I figured out the right code. That being said, I have a new challenge which I'm not sure how to go about. Here is my situation:
I presently have 2 combo boxes (cboBuilding, cboRoom) and which are properly cascading. That's great, but now I want to be able to pull the RoomDescription for the room... -
I do have that open, but I have not seen any specific calculation within that database. Perhaps I am not looking in the right spot, but while the tables have "sample data" in them, there is nothing specific as to the way it was calculated. The only thing that I have found to be true to form is the way they calculate the total depreciation, which is (presumably) a summation of posted depreciation amounts ...
Thoughts or other...Leave a comment:
-
Straightline Depreciation in Access 2003
Good morning all.
This is my first post to the site, and what a wonderful site this is. I wish I had come across it years ago. I am working on a database that is going to track the assets for a non-profit organization. One of the aspects which they wish to have happen is to have the database auto-calculate the depreciation value of any given asset (straight-line).
I have done several searches on this topic and in a...
No activity results to display
Leave a comment: