Recent content by Bobp3114

Thanks MajP, I feel like a fool looking for a difficult answer and I was not seeing the obvious. lesson learnt Bob

This is what I get when I create a check box in one database This is what i am getting in the current database I cannot enter anything into the "NAME" area to change the name????

When I create a checkbox it automatically gives it an unwanted name and I cannot find a way to rename it eg it creates Check150 I need to change it to say "chkConditionOne" This behavior is not what usually happens and I am sure I must have changed some property inadvertently I am unable to...

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