Adezii,
I know how to do switchboards and but I'm interested in improving the quality of mine. How can I download your demo?
DBlearner
Last Activity: Dec 8 '09, 09:41 PM
Joined: Oct 28 '09
Location: Eastern Coast of the United State
-
Yea, Access is acting like an helicopter mother worried that we may strain our brain too much if we play with codes.Leave a comment:
-
Can anyone point me in the right direction? is there a certain method of doing this that I overlooked?
Any help would be greatly appreciated and thank you in advance.
MattLeave a comment:
-
I'm back. I got a Access 2007 VBA book and learned a lot. So here what I did! For the most part it worked except for the very last part ;-(
I created a table titled [DoDAAC] that had three field names which are [ID] [CMO_Name] [DoDAAC1].
I also created a query titled [DoDAAC Query] that includes all fields from the DoDAAC table above.
I went into the main table titled [Data Collection] and created two field...Leave a comment:
-
Validation Rules for Data fields
I'm surprised I couldnt find a question about this here so guess I better ask.
I have a form with two date fields. [StartDate] and [EndDate]. Obviously, Enddate cannot predate Startdate field so I decided to do a validation rule for both fields.
I selected the startdate field and insertedalong with Validation text.Code:[StartDate]<=[EndDate]
Now, the strange thing is that no matter what date I select in... -
Chip & Neo,
Your explanations went beyond what I was hoping to get! Thank you so much for taking the time to explain the structure of how people write/read codes.
Now, I am starting to become pretty good at understanding relatively large chuck of codes. I'm starting to see SQL is a real language, albeit with more strict rules compared to English.
How long do you think it'll take a person to be fluent...Leave a comment:
-
Unsure about a part of a code for a select query
Dudes, you should check this out! I just downloaded a MS Access database titled "Sales Pipeline" and it's a great way of learning codes to do charts on the fly. I'm reading the codes and checking reference books, google, etc to understand what they mean and do. That way I can build my own and actually understand the underlying structure.
I'm trying to find some clarifications that the reference books are not on one code. This... -
DBlearner replied to change a property sheet control depending on the selection selected on a radio fieldin AccessChip,
Can you point me in the right direction regarding writing codes? There's so many different codes, etc. Can you give me the exact code name so I can google it and learn how to write, nest the code properly?
I am so frustrated! I am almost done with the database except for this one ;-) any help would be so appreciated.
MattLeave a comment:
-
DBlearner replied to change a property sheet control depending on the selection selected on a radio fieldin AccessI love Conditional formatting but I only can use up to three conditions. I probably will need at least 5 or 6. Plus I want to turn off/on some property sheet control too.Leave a comment:
-
VBA? I have zero understanding of VBA. I searched .column in Access help and only presented info on column in property sheet.
Do you know of a website focused on VBA for novices?Leave a comment:
-
DBlearner started a topic change a property sheet control depending on the selection selected on a radio fieldin Accesschange a property sheet control depending on the selection selected on a radio field
Hello,
I have been reading thru various questions in the Bytes forum and none really answers this completely so here I am.
I have a radio button field that displays several options and you can only select one.
My goal is to make a certain selection trigger a change in a text box. for example, if I select reject in the radio field then the text box background would go red.
Will that require... -
I looked at the combo Box property sheet and learned everything about column count and Bound Column. Dont see how it can help me in this situation.
I am trying to figure out how to get the text field to automatically select the corresponding data in the second column depending on the selection in the drop down field.
Example:
I would select Hamburger in the combo box and then the text field would check...Leave a comment:
-
It worked perfectly. Thank you so much for the help. I'm learning and loving it. Thanks man!Leave a comment:
-
synchronizing one text field based on the selection of a drop down list
Hello folks,
I'm building a nutrition database to keep track of my eating habit. I know there's ton out there but I want to do it on my own you know?
Anyway there's a tiny issue that I cant seem to find the answer anywhere. Google is great but I cant seem to figure out the right key word to use to find the answer. Argh!
Ok, I have a table [food_by_calorie s] that has two columns which are [food] and [calories].... -
I decided to do a different tack and used a different funtion for a query table. I think this may be more efficient and easier to do than doing "If Then Else" statement in VBA. However, this one seem not to be working properly because of syntax issue.
...Code:CAR_Revision_1: IIf(Not IsNull([CAR EVMC Response Comment (1)]),"1", or (Not IsNull([CAR CMO Response Comment (1)]), "2", or (Not IsNull([CAR CMO Response
Leave a comment:
-
I'm getting better
Neo,
I didnt know about Switch, etc and I just learned several new functions, thx. I dont see how Switch() would be a good solution...
I ended up finding out about If-Then-Else statement and it's perfect for what I wanted to do.
I wrote this VBA code since this one can only work in VBA and not in Query. However, nothing happened and I am scratching my head.
...Leave a comment:
-
Thank you for the quick response.
This is not for grade but my personal attempt to understand expressions and how to properly nest functions. Anyway, I understand your code and it makes sense. But there's a problem... I need to use Isnull function at the beginning but cant find another function that is the opposite of Isnull for the subsequent nesting in the expression.
I would use IsNull at the beginning to tell the...Leave a comment:
-
Combining IsNull and IIf in an Expression
Good afternoon folks, I'm a total novice at this game.
I'm a student at an University in DC and is taking a basic course in Access and database. I need some help writing a nesting expression using Isnull and iff functions.
I have a field titled "Revision_b ox" that would display either 0,1,2, or 3 depending if certain fields are empty or has been inputted in.
So,
If Round 1 field...
No activity results to display
Leave a comment: