Search results

That's because a list box has only one value. If your original query is named qryPayroll a query that shows the three fields in your list box source would look like SELECT * FROM qryPayroll WHERE PayNo = [forms]![searchform]![mylistbox] (To make this work: (1) change qryPayroll to the correct...

Adrianna- Looking at the code, and considering the other comments, I'm afraid I don't have any revelations to offer. A couple of things I looked at that didn't pan out were -The name of your main table, MastSysTbl looked something like an Access system table, but the Access system tables in my...

Sorry I have been out of it as well - daughter & granddaughter visiting. I did notice you set a value to "" (empty string) and test the field against Null somewhere. Don't know if that might be causing SOME problem, maybe not THE problem.... I will try to look at this later but grandkid has...

Adrianna, You could copy 'n' paste the code to the forum so we could take a look...? Jim

Dave- Beautiful! Thanks! Jim PS - Another "doh" moment.

Adrianna, Have you tried the simpler expression DoCmd.Close ? Jim

Liam, You can also use the AfterUpdate event on the text box to examine the value entered in the text box and change its font, "boldness" (weight), italics, underline, color, etc. If it's not a user-entered field, you can do the same on the form's OnCurrent event. There is also a type of...

TJ (We've GOT to stop meeting like this! :)) Since you're building the query in code you can call a function that replaces each single-quote by two single-quotes. The function would look like: ---Code Below--- Public Function Quote2(strText As String) ' Returns the input string with any...

TJ, I think the trick is to select the entire control, not just a tab page in the control. When the whole control is selected the usual font name, font size, etc., properties are available. HTH, Jim

Here's what I do in the form's BeforeUpdate event: (ID is an Autonumber primary key of my People table) If Nz(Dlookup("ID","tblPeople","FirstName = '" & Me.tbxFirstName _ & "' AND LastName = '" & Me.tbxLastName & "'"),0) = 0 then MsgBox "Cannot save record with duplicate name",,"Save...

Dave, I was suggesting that one could build any kind of a rectangular structure (text box, rectangle, label, or graphic) and superimpose a transparent command button over it to make it seem like the underlying structure had the attributes of a command button. Even though the button is...

Just a suggestion: You can overlay any rectangular design with a Command Button, make its Transparent property True, and have its OnClick event do what you want. Using this technique, the text on your rectangles needn't fill the rectangle to "catch" the click. Nice buttons, though! :) Jim

Make sure the Scroll Bars property for the text box displaying the text is set to "Vertical". If you set the focus in the box, the scroll bar should appear, allowing the user to see all the text.

I have found this to be a useful reference to bookmark: http://www.mvps.org/access/forms/frm0031.htm

Microsoft Date and Time Picker Control, version 6.0 on my system.

1. Your list box (call it lstList1) has a Row Source, for example a field called List1 in a table called tblList1Values. So maybe the Row Source property (Properties window, Data tab) looks like SELECT List1 FROM tblList1Values To eliminate the duplicates change the Row Source to SELECT...

I expect it's already done, esp. if you put the subform in the main form with a wizard. With the subform selected, look at the properties' Data tab and you ought to see the parent=child relationship. I don't think the solution is to unlink the subform, but instead, to find a way to populate it...

What I would do is write something like this: DLookup("GrantAmount","tblFundingSource", _ "ID = " & SourceID) - DSum("chequeAmount","tblProjects", _ "ProjectID = " & SourceID) Terms used are: tblFundingSource - the table you described GrantAmount - the field in this table containing the...

The duplicate record button duplicates the record on the main (parent) form, right? And the child (sub) form is linked to the parent form perhaps using a foreign key in the child form? If this is the case, then when you type something in the duplicated record, I expect a new index, or key...

Is anyone aware of he existence of a text box control that displays HTML-formatted text in forms and reports? I know of 3rd party RTF text box controls but haven't seen (and maybe could use) an HTML text box. Thanks, Jim