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 =...

Thanks for the tip Roy.

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...

Thanks Stephen and Roy ... I changed the field to YES/NO and now the table actually has the check box in it (Checked or unchecked) depending on the value that I picked. I thought I'd see a Yes or No but I guess 2000 doesn't save the data that way. I want to try the combobox but I do have a...

Thank you Stephen.. changing the value as Numeric did allow me to check and uncheck the box. If you don't mind however I have 2 more questions 1.)Is there another type of control that I could've used to say Yes/NO and that would be stored as YES/NO 2.)How can I specify positive numbers only in...

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...

Thanks PHV ... Is this happening because of the tables that I included above?... In any case... Can you help with the above problem?.. I've tried taking out the Me.Refresh as suggested and still get nothing printed...

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.

Randy700, - A value for SponsorName is Blimpie. Here is a sample of the table ProjectLog: ID Company Project DateStarted Study JobWithinYear Sponsor Description DateCreated 10 6 WRAP 6/3/2004 BLT 1 BLIMPIE * 6/30/2004 11 6 WRAP 6/4/2004 CLUB 2 SUBWAY * 6/30/2004 Note that I...

Is anyone else available to answer my question posted above? Scriverb? ... PHV? ... Anybody else?

I'm not sure what your question means?..but SponsorName is supposed to be the value saved in the projectlog table. It is the Sponsor associated with the Company selected in ReceivingCompany and the Study selected in StudyNum. This is calculated in the after_update od StudyNum which is when I...

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 another question concerning combo boxes and forms. In my form I have 6 combo boxes. (2groups of 3) Group 1 Shipping Company Ship Co location Ship CO Contact Group2 Billing Company Bill Co Location Bill CO Contact. Those combo boxes work as I'd like them ... (ie. Ship Co location...

I just tried that ... and it also worked...so you know I have to ask Is one method better than the other? Thanks

NEVER MIND MY LAST POST!... Thanks PHV... I just tried the "" "" and it worked...

Ooops I meant to put LocID instead of LocationID in the code for the rowsource... The compile error still shows up highlighting the entire select statement. P.S>...As if things weren't strange enough...now the concatenated value show up in the combo box but I get thrown into the VB editor with...

Scriverb, I've had the following code in the Rowsource ... SELECT [locationID], [Suffix] & " " & Trim([FirstName]) & " " & Trim([MiddleName]) & " " & Trim([LastName]) AS Name FROM Contact WHERE LocationID=[FORMS]![Order]![ShipingLocationID] ORDER BY [LastName]; Column count=2...

Is Name in your select a variable that will actually be the Rowsource value or the combobox name or just a variable to hold the value of the concatenation?... because it still shows the LastName which is what I had before...I want the result to be the value saved in the combobox field ... right...

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...

Thanks for the explanation... This is now very clear. I've since then fixed my problem and got all my combo boxes to correctly display what they should. I needed to fully understand how the Bound column relates to the combobox and now that I do... I'm able to fix my forms. Thanks again for all...