Search results

Hi, You would have to apply the same Conditional Formatting to all fields, use the "expression" setting in Conditional Formatting and type expression = <Boolean>. Keith.

Hi, I think Access is evaluating the expression Me.Boolean for only the first row in your result set, so all controls in all rows are either bold or not bold. To achieve what you want, you need to use Conditional Formatting on each control, you can access this through the Format > Conditional...

Hi, Upgrading an Access 2000 database to Access 2003, integrating with Outlook 2003. I get the message: A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No". This interrupts the...

Hi, Start by creating a table called Person with the following fields: FIELD NAME TYPE PersonId Autonumber HeadOfFamilyId Integer FirstName Text LastName Text Date Of Birth Date etc. Create a form to add / edit person details. The...

Hi, Yes, I get the same error whether linking the library version 9 or version 11. Sorry, I gave the wrong name of the file for version 9, it is MSOUTL9.OLB, as compared with MSOUTL.OLB for version 11. I am pretty sure version 11 is the one I should be running, but still getting the error...

Hi, Sorry, that was my mistake. Corrected the syntax and I still get the same error! Keith.

Hi again, OK, I tried declaring: Public olAppWide As Outlook.Application in a class module, then instantiating: olAppWide = New Outlook.Application but on the latter line, I get the same error 48. At least its consistent! I hope you may have a suggestion. Thanks, Keith.

Hi, I attempt to get an existing Outlook instance to avoid the situation where every time the user starts the application, they get a new instance of Outlook. If the GetObject() fails, I call: Shell("outlook", vbHide) to create a new, hidden instance of Outlook. What used to happen is the...

Hi, I am running the following code: Dim objOutlook As Outlook.Application Set objOutlook = GetObject(, "Outlook.Application") I get the error number 48: "Error in loading DLL" I am running MS Access 2000 SP-3. On this version I have the Microsoft Outlook 11.0 Object Library (MSOUTL.OLB )...

Hi, I've attached a screen shot from a form containing a subform in my database. My boss now wants to see section headers to break the rows up into sections, with headings "Objective 1", "Objective 2" etc. So at the top, just below the column headings "Apr 05" etc, would be the heading...

Thanks for the suggestion, I should have explained, I need the user to be able to open more than one instance of the same form using this method. If you call DoCmd.OpenForm and the named form is already open, the form is just brought into focus and the new WHERE clause applied, rather than a...

Hi, Have a look at the Help topic "When can I update data from a query?" You might be able to make the record source updateable by including more fields from the other table, i.e. its primary key fields. An alternative way is to make the field unbound, and set it to a value using VBA code on...

Change the record source to reference both tables. You can click on the (...) symbol beside the record source to open a graphical view of the table you set as the record source. Add your other table to the record source. If your database is well designed, there will probably be one or more...

Hi, Set the form's Record Source to the table. Then open the Field List on the form, and drag the field(s) you want onto the form. Or, create a text box control on the form, and set its Control Source to the name of the field you want, from the table. HTH, Keith.

Hi, I build the WHERE clause in my form's record source dynamically, depending on the context in which the user opens the form. I can't put the WHERE predicates in the record source and refer to fields on another form, as the context will determine which predicates are required. So I have code...

Hi, Since you only get one value for each case in the Select, sounds like txtStartupTemperature is evaluating to 0. You can easily check this by running the code in Debug mode. (Press F9 on a line of code at the start of the function code to put a debug stop). Perhaps you should be using...

Hi again, I'm using Access 2000. I tried: Dim Graph_Object As Object Graph_Object = Me.Graph_Data but this produces a runtime error 91: "object variable or with block variable not set". I also tried data types Graph and Chart, to no avail. I have developed an SQL query that does...

Hi, I found the following article in the MS Knowledge Base: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/grobjdatasheet.asp That is what I need to do in my Access 2000 form: populate the data in a Chart (MS Graph object) by VBA. I tried the following code...

Hi, May I suggest you put a breakpoint in the first line of yous sub, and step through the code line by line. Check what the tab index is set to before and after each of your assignment statements. You may find that the function is not being called at all, or you may get a clue as to why it is...

Hi, Try: Me.Recordset.MoveLast Me.Recordset.Edit Me.Recordset.Value = NextProductCode Me.Recordset.Update Keith.