Search results

Works great, thanks a million!

I have a combo box called 'Status' of which there are 6 values to choose from. What I'm trying to do is have a report that will display results based on a query that takes the combo boxes value in as criteria. This is no problem for a single combo box. However, I want to be able to select up to...

Im trying to create some code which will open a form, filtered to specific query criteria and then copy each resulting record to a new record while a field called 'Complete' has a value of True. Can someone please suggest some ways of doing this? I have a query which selects the records...

So there's no way of getting what I have to work? I inherited this mess

But I have 30 other component fields, such as [Component 1], [Component 2] etc My plan was to use the same SQL statement with a few tweaks.

It's a textbox

Yes its with the SQL statement

Thanks for the suggestions but still the same problem. Strange

I'm trying to write a SQL statement on a form called frmForm1 but when I run it, I get a Type Mismatch error message. All the relevant fields are set to text on their tables so I'm out of ideas. Can someone please help? Many thanks DoCmd.RunSQL "SELECT tblCollateralPurchasingGroups.[Purchasing...

I've finished testing my one and couldnt find any issues so I'll go with that. Your method opens up other doors for me though so thanks!

Here's what I've come up with. Still needs a bit more testing but looks good so far: Private Sub FIND_Click() On Error GoTo Err_FIND_Click Dim ctlCurrentControl As Control Set ctlCurrentControl = Screen.PreviousControl If (ctlCurrentControl.ControlType <> acTextBox) And...

Thanks dan-cat Nice idea and it works beautifully but my users use double-click to select a word for copying.

Sounds good to me. But being a novice programmer I dont know where to start. Remember I need check whether any textbox has the focus, not just 1 or 2. Thats where I'm stuck. Can you pleaeeeese advise?

I have a 'cmdFind' command button which can be used to search any field, depending on which textbox the user has the focus on. But if another object such as a command button has the focus instead and the user doesnt notice this, a message appears: The control 'cmdFIND' the macro is attempting...

Done and thanks

I finally managed to come up with a neater fix for this problem. Put this behind a save command button: ******************************************** If Me.Dirty = True Then DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Else MsgBox "No changes have been made to...

Among other things I'm trying to give users visibility of who is locking the record and a textbox with the 'lockers' username in it would do the trick. I'll admit it is proving really tough, especially trying to work it around the brilliant 'Mousetrap' code. Also, for some reason my users...

Do the experts among you think it would be bad practice to trap error number 13 with a record-locking message considering that the VB Help gives 6 other possible causes?

Thanks Jack, I'm going to start working on this method now.

Hi, I know I'll probably have to wait until Access 2015 is released but has anyone ever come across a way of hiding record selectors on a form and handling it through code instead? I'd like to test if a record is locked when it's made current and if so, produce a message box. I thought it...