Recent content by GJC

Yeah, I know its a lot of work but the end users are going to need it as simple as possible to use. I changed a few things, The Combo box control source is now pointing to !Table!Field, the remainder of the code in both the calendar and the combo box point to the combo box. I get the message...

Basically, as a novice, I am following the exact instruction on the MS Support site (url a couple of postings ago) however thier referencing does not appear to differentiate between field names in the table and the name of the combo box (as they have named them identically) As such I can get the...

Well I got it working in the "Northwind" test but I am having a couple of problems in the live database. I guess I am using the incorrect "names" when writing the code for the Mousedown and Click events. Probably cofusing the combobox and table field names (as in the example given in the...

GOT IT WORKING !! See thread "Calendars" for the URL to the Microsoft Solution Page. Any probs let me know and we can sort it beginner to beginner.

My thread "Calendar" is struggling to establish the same thing. I will read this one with interest [This message has been edited by GJC (edited 03-20-2002).]

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q190194 has a solution I followed it diligently and get an error on the line >>Calendar.Value = IIf(IsNull(OrderDate), Date, OrderDate.Value)<< my line is calendar.Value = IIf(IsNull(effectdate), Date, effectdate.Value) Where...

Just got this from the MS support site >>ACC97: ActiveX Controls Do Not Appear in the Expression Builder (Q170494) -------------------------------------------- The information in this article applies to: Microsoft Access 97 ---------------------------------------- Novice: Requires knowledge of...

Thanks Rich, I am rather new to all this, How would I get the unbound text box to recognise the mscal object ? Thanks again G

I had changed the names of the table to refect my form etc. It the query is not picking up any values I am putting in, just the wildcard *. Would it be in any of the properties settings ? Sorry but I am quite new to all this G

I have a similar problem, I copied the exact string as suggested but now when I select something from my dropdown I still get prompted for a value in the field. It does not appear to be recognising the "picked" data

I am designing a form and wish to use calendar (MSCAL) to pick a date. As I have a number of date selection required, I have embedded 4 calendars into a 4 page tabed form. Unforunately I cannot get the query to recognise the calendar in build criteria it spots the tabbed worksheet ok but not...