Search results

Alex, loaded down your db but it contained no table for Hazard Name - only HazardType, Location, and Main tables. HazardName was a Text field in Main. I assume that what you want to do is select HazardType, it will populate the HazardName combo with relevant items - you can select one of these...

Try this solution (provided by Travis) which on opening a form will close all other forms. Private Sub Form_Open(Cancel As Integer) Dim frm As Form For Each frm In Forms If frm.Name <> Me.Name Then DoCmd.Close acForm, frm.Name Next frm End Sub

Alex, You may want to do a search in this forum for the 'NotInList' event. This is commonly used if you are wanting to add an item that is not in the combo box. If this is not what you are after or have further questions - then let us know. Luck .. Peter

Alex.. yes you haven't got anything in the forms RecordSource so it will not be updating anything. Are you wanting to use the form to add new countries and states? Peter

Alex I would suggest you try something like this where you don't have seperate state files for each country. Luck...Peter

Try this: Dim iloop as integer For iloop = 1 to 25 Me("Product" & iloop).ForeColor = 16777215 ' or whatever white is Me("Product" & iloop).BackColor = 255 Me("ProdDescr" & iloop).ForeColor = 16777215 . . Next iloop

Try =IIf([Classification]="Decision Maker" And IsNull[Date Last Contacted], Date(), iif([Classification]"Decision Maker" And IsNotNull[Date Last Contacted], [Date Last Contacted]+30,” ”)) peter

Found the problem - unrelated. Duh! Sorry about that ... Peter

I came across this which was from 'Trevors MS Access' - fairly old, but may be of help. Q...How can I trap a ODBC Error in VBA? All the VBA Err object returns is "ODBC Call Failed" A....Use the DbEngine.Errors collection Sub Update_TempLib() On Error GoTo ErrorTrap ' Executing connect...

No, I am okay there. The reason I am checking for enabled property is that some of the fields are Not Enabled and if I lock them as well then they are greyed out - which I don't want. I have the same problem if I remove the if ctl.enabled statement. Any thoughts?

What do you have in the Master and Child Relations fields in the sub-form on ctlProgramDetails?

I think it will be a combination of the Pop-Up and Modal properties. Check out Help and these settings on FormA and FormB. Peter

I am using the code below to lock fields on a form - user can click a Command Button to unlock and edit. It works fine except where I have an empty Enabled text fields. I can change data in fields that already have data in them, however those that are empty, appear to be Not Enabled - in that...

try Me!Actsubform.Form.RecordSource

Ken, were you thinking of the Choose function?

Phil, Like "*" & [Forms]![frmOrderAnalysisByServiceType]![cmdServiceType] ... We have a solution to the warning message, couresty of Stormin Norm, in a past thread. I don't know how to link you to it but do a search on NoData and it will bring it up. The solution is - change your cmdOK_Click...

Phil, there are a couple of methods you could use. ... Add "ALL" as option in combo box. ... use Like "*" & Forms... in selection criteria. Given that, it may be neater for you to build your query in VBA using QueryDef. If you plan to do that you will want to use something like this:- Dim...

Phil, In your query, put the selection criteria on ServiceID as this is the bound column on your combo box - put ServiceDescription in there as a additional field so that your report has all it wants. Your error is returned when the query does not any matching criteria - the above change will...

Attachment to large. I can either email to you directly or trim down - let me know what you want. Peter

Hi Bonie, haven't had a chance to do much on it but have attached where I am to date. I was having a memory problem yesterday (computer, mine is not an intermittent problem) which I thought was either a virus or access corruption. It turned out to be a problem with your DB relationships which...