Search results for query: *

I have a report that uses data that was brought into a table containing name & addresses all in upper case. I found an old thread where this was addressed... but I'm too much of a novice to even figure out where that code would go. my question is where do I put this code LegalName =...

I have a date field named OrderDate in a form. I have this vba code to get the just the year. Cur_YR = DatePart("yyyy", [OrderDate]) In the table the field is defined as a Date/Time Datatype and the default value is =Date() Can anyone help with getting the year to be 04 instead of 2004...

I have a Check box name ReSupply in a form that is to be checked if new supply is needed. The problem is when it is checked all records in the DB become Checked... If I uncheck it then they all become unchecked. I went back and double checked the settings and realize that the controlsource was...

Did anyone close my thread? I am not able to add any reply because that section of the screen is all blue and not editable. the subject is : Textbox update from combobox value.

Hello again ScriVerb & PHV I'm back with another question... This time I have a Textbox (named SponsorName) that is a calculated field which is updated in the after_update event procedure of a combobox field (named StudyNum). In the after_update of that field I have the following: Private Sub...

I have a combobox which list contact names (ie. Title,First,Middle,Last). How can I get the row selected to be saved as a concatenated version of Title & First & Midldle & last. I'm not sure where to put the code... should this go to ON Click and the correct syntax here would it be possibly...

I have a form with a combobox that displays info from a query. It's a list of Companies from the Company table and and their various locations from the Locations table. I have the row source as CompanyLocations which is a query. When a user makes a selection(i.e. Company and location) I'd like...