Search results for query: *

This is Access 2000. I have a Combo Box control with a select statement in the row source property specifying the contents of the drop down box and the sort order. The lookup is being pulled from a query which is based on one table. In the dropdown box lookup, one of the columns is appearing...

This is Access 2000. I have a form where, if I am editing an existing record, I need to capture the existing value of a control when it gets the focus (GotFocus event) and use that value moments later to perform a calculation during the BeforeUpdate event for the same control. I used a global...

Access 2000. I've encontered Too Few Parameters, Syntax Errors, and Type Mismatch errors on this code. Right now I have worked through the other errors and I am left with Type Mismatch and I know it relates to the syntax after the last "and" condition. I have tried many alternatives but I just...

I am opening a recordset based on a match of the BatchID field between a form and a query. It works fine until I add the Expr1 < 0 condition, with the error indicating I need to define a variable for Expr1. I suspect this might also be a syntax issue. Expr1 is a calculated value in the query...

This is Outlook 2003. A hard drive has been replaced in a machine and the pst file was restored from a backup. Previously, when creating a new email, once a letter was typed in the "To" box, a drop down box would appear with all addresses beginning with that letter. After the restore, the drop...

I do most of my posting here, and I looked through the forums list, but I just don't know where to post this so perhaps a moderator can move it if appropriate. I have a Point of Sale software application that produces customer receipts which require an XML format in order to enable the...

I have a string variable declared. What syntax would I use in the body of a MsgBox statement if I want to incorporate the value of the string variable into the middle of the message?

I have a public function which opens a form and assigns the OpenArgs string to the title area on the form. I am wanting to use the tag property to identify each particular occurence of this form being opened. Can I add another argument to this public variable and somehow get it to populate the...

I have a calendar pop up form which I am using in 3 or 4 different forms for date selection. It is a single form which is called up by a button and makes use of global variables. Short of creating a different popup form for each main form where it is used, is there a way for having this popup...

I have a an application which does not ever have any toolbars showing. All menu options are generated with form menus and command buttons. I have a Reports menu that shows a list of reports with a command button to print the report. As soon as the command button is clicked the report immediately...

I have this code which is producing a 'too few parameters Expected 1' error. Thanks for any help! Dim CurDB As Database Dim rs As recordset Dim Resp As Integer Set CurDB = CurrentDb Set rs = CurDB.OpenRecordset("SELECT * from BatchMasterTemplateTable WHERE" & _ " ItemProduced =" &...