Recent content by Bobp3114

Thanks rst.FindFirst "[StationID] = " & Me.txtStationID Thanks..will try that also as i was also trying something like that...this has been bugging me for days...Oh well I'm nearing 85 and still an amateur!

Hi Plog..Full marks used your last line...all Ok

My code: Private Sub cboOpportunity_GotFocus() Dim rst As DAO.Recordset 'Get the database and Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("tblPipeLineInput") 'Search for the first matching record rst.FindFirst "[StationID]...

I have a combo box "cboOpportunity", run by a query :qryActivityOpportunity" which simply looks to find records linked to the value of "cboCompany" cboOpportunity is set to Limit to List and is a bound combo I wish to add the phrase "No Opportunity" when the query finds no records

I am using the following code to set the recordsource of a form depending on which form is used to open it. If CurrentProject.AllForms("frmSalesDashboard").IsLoaded = True Then DoCmd.OpenForm "frmActivitiesEdit", acDesign Forms!frmActivitiesEdit.RecordSource = qryActivitiesEdit...

Thanks, looks off putting but Hey gets the result wanted

User picks from the date picker. The format is set for each control, and set in the Tables, The weird thing I am getting now is that the date stored in the text box shows medium date but if edited to a different date via the picker, it reverts to short date momentarily, then changes to the...

Your advise is sarcastic and not helpful. I do not claim to be a "Programmer" but a learner who finds the forum helpful

Customer asks for the dates on the forms to be in Medium format instead of short format. I have changed to this in the tables used and on each of the forms controls The tables look as expected When I change the a date on the form it reverts back to the short format?????? What have i missed?

Yes Thanks

Thanks Pat

Thanks, I have done almost exactly this as advised by fellow advisers

WOW! At a loss as to how to answer everybody but here goes. Ken, Pat helpful as usual. bbfromgb thanks, I have visited that article and will study it. Appears that my statement was not sufficient for some, so I am attaching an image. I am at a loss as to how I have subforms on a form that is...