Search results

I have the following code: VarEntity = DLookup("[Entity_ID]", "PITTagEvent", "PITTag_Code = " & InString) Where: VarEntity is a variant variable; Entity_ID is the field I would like returned; PITTagEvent is the table to be searched; PITTag_Code is the field to be searched, and; InString is a...

Did you use the wizard to create the "Find" button? I think that the wizard sends menu commands, and intentionally brings up the dialog box. Instead, you'll probably have to create a command button manually, and use a statement like: Dim rs as object Set rs = Me.Recordset.Clone rs.FindFirst...

I knew I was out of the loop again. Matt

You could use the gotfocus and lostfocus events of the subform to temporarily allow editing. Edits would be allowed everywhere, but only while focus is within the subform, hopefully within any field in the subform. The user would not be aware that editing is allowed in the main form, because...

From Access help: CurrentUser Method You can use the CurrentUser method to return the name of the current user of the database. For example, use the CurrentUser method in a procedure that keeps track of the users who modify the database. Syntax CurrentUser Remarks The CurrentUser...

Where is the article? thanks, Matt

Situation: Item One: Combo box on form, used for lookup. Works great. First column bound and invisible, stores a code in the field. Second column used to select a value from the first column in the underlying query. When I type an entry into the box, it retrieves a record and stores the...

Thanks, though, for the code! It's nice to see how other folks think. Matt

Can you list: Tables in the underlying query, with fields in each, and; The query itself, and fields included? The error suggests that the field necessary is in the table but not the query. Matt

In MSDN I found something under "ToolsCustomizeKeyboard" which is actually a function in VB. It lists the value of F1 as 112. From help: Syntax Private Sub Form_KeyPress(KeyAscii As Integer) or Private Sub controlname_KeyPress(KeyAscii As Integer) KeyAscii Returns a numeric ANSI key...

See the other recent discussion: http://www.access-programmers.co.uk/ubb/Forum4/HTML/003064.html I think it's what you're looking for... Matt

Somehow it has cut off the end of the statement! This is at least a lead... A couple more questions: Is [job] a number or text? and; I was assuming that the bound column of the cboJob was the first,(column(0)), and that the visible field is column(1). Is that correct? I'm thinking that...

Sorry, I'm at a loss. I tried misspelling each of the components in turn, and I get other errors but not that one. It sure looks just like what I did. Now I'm wondering, are the records on the form itself or in a subform? The example I gave you is sorting records on the form itself, not on a...

OK, I wrote a similar form for a table that I have with some frog location data. At first, it was giving me the same behavior as you had noticed, ie.; when I clicked the funnel button to remove the filter, the form would no longer respond when the ComboBox selection was made. Once I got the...

I have used the "Locked" and "Enabled" properties of various controls to do something similar. In the "click" event of your button, put Me!ControlName.Enabled = False or Me!ControlName.Locked = True to lock the named controls, or the opposite to unlock them. If you use just the "enabled"...

I've never used the sendobject command, so I can't answer your question. So I'll offer another: did you try using the hyperlink properties on the field that holds the e-mail address? That will open up the default mail app and address it appropriately. Matt

Instead of the macro, you'll have something like this in the update event: Sub ComboBox_AfterUpdate() Me.Filter = "[SearchField] = " & [ComboBox] Me.FilterOn = True End Sub I'm not certain of the syntax, but the setup should work. Matt

Along with ApplyFilter (just before it, actually), set the "Filter" property of the form right there in the afterupdate event of the box. Apparently it is erased when the filter is disabled. Matt

This is a super source. The TechnoWeenie web site: http://www3.sympatico.ca/qaissuper/Index.html Check out the zip file for "ComboBoxes" and there's a sample for limiting a combo box based on another. Matt

On my wish list: A friend of mine with the Forest Service uses Delphi, and they have a cool control. A dual list box with the ability to doubleclick or drag records (called into the first box with a query) into the second box, where the new selection of records can then be processed further...