Search results

Thanks DCrake for looking into this. I will look to do as you have advised. Thanks Once Again SpiritedAway

Hi DCrake I've tried the code - Me.SearchResults.RowSource = Me.SearchResults.Tag & " WHERE [Status]='" & Me![cbostatusfilter] & "'" But listview is still going blank on selection of combo box. I have uploaded an mdb version of the db so you can see the problem. Also i seem to get a...

Hi DCrake, I've used on the combo Afterupdate - Private Sub cbostatusfilter_AfterUpdate() Me.SearchResults.RowSource = Me.SearchResults.Tag & "Me![cbostatusfilter] & " '" End Sub But the data in the listbox goes blank when i select from the combo. Can you advise me where i'm going wrong...

Hi, On FrmTrack I have a listbox called [SearchResults] - the row source is: SELECT [QRYTrack].[TrackID], [QRYTrack].[Status], [QRYTrack].[Percent], [QRYTrack].[System], [QRYTrack].[SystemID], [QRYTrack].[Title], [QRYTrack].[VNumber], [QRYTrack].[Protocol], [QRYTrack].[VersionN]...

Hi, I pasted the rowsource SQL of QRYTRACK into the tag property of my list box as suggested and it does work updating changes i make to existing records in the listbox. But when I want to add a new record from FRMData the listbox does not update with the new record, nor is the new record...

Thanks DCrake for responding I will try what you suggested - and let you know how I get on. Thanks SpiritedAway

Thanks missingling for responding, Could you give me some ideas about how I would do this? Thanks SpiritedAway

Update a Listbox Hi, I have a form, FRMTrack that holds a Listbox called [Documents] - the data is drawn from a query, QRYTRACK - When I double click an entry in the Listbox it takes me to the correct record where I can then modify the existing record or add a new record. This form is...

I don't see any point to simply copy and paste code without at least trying the understand the physics of it. It's much rewarding to know what your code is actually doing and why. How it fits together is the best part. That way, at least I can share what I've learnt with other people along the...

Done some research on the subject, I understand it much clearly now. Thanks for pointing me in the right direction.

Hi vBaInet, Thanks for responding. Could you tell me, how and where to add the Round () function

Shieriel on your textbox, 'txtpassword' where you type in the password, if you go to properties on 'txtpassword', on the data tab click the InputMask and you can select password function which will then turn any text you type in 'txtpassword' as *****

I have an unbound text box on my form - the control source is =DAvg("PercentComplete","tblProgress","ProgressID > 0") It calculates the average of a set of numeric values in "PercentComplete" column. At present it's returning an average 49.1666666666667 How can I get it to simply...

Thanks MrsGorilla for the response, Regards the combo box, I will definitely try what you suggest… As for the running average, you mention setting the control source in an unbound text box equal to a DAvg function that polls directly from my recordset. So from tblProgress, if I want the...

Hi, I have a form, in which there are two drop down combo boxs. comboStatus comboAverage Draft In-Progress 10% Draft Complete 15% Draft Review 20% Update In-Progress 30% Update Complete 35% Approval In-Progress 40% Approved 50% Execution In-Progress 60% Execution complete 70% Review...

Hi, I've come across a great sample db of a drag n' drop treeview from Brent Spaulding, however, I was wondering if it is possible that whichever node I click on will display the relevant data of the Employee in a form next to it. I have uploaded the sample db and wondered if anyone could...

I have a "hide" button with an embedded macro - the action is RunCommand and Argument is UnhideColumns. It displays a dialog box with all the columns in my split form and I tick the ones I want visible and it hides the rest.

Still doesn't explain why it's doing that?

Hi Having problems with the autonumber unique ID- When I usually add new records the autonumber is sequential as you would expect. Currently I'm on record 15762 - which is so far, so sequential but this morning I added a new record and autonumber has given it as 1304357 (I don't have that...

Yes, very big fan of Miyazaki - he is the master of simplicity but beneath which lies a whole other world. You make an interesting point about automation between Project and Access, there is a ton of information about automation between Access and Excel, Word and Outlook but very little about...