Search results

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

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...

I have been asked to change present forms so that there is a"Background" form with no connection to any table and that only contains a few Command buttons. Then showing always, three smaller forms, each derived from it's own query and always placed on the background form in the same position...

Thanks all will work on it