Recent content by dopedealer

One way to do this would be the Auto Dialer, make a new command button and choose miscelaneous from the Command Button Wizard and then select Auto Dialer. Once you get the Dialer you can attempt to modify the code to your liking. Make Sure the Previous Control is the Textbox with the phonenumber...

On the AfterUpdate Event of the ComboBox in question Code in VBA along the lines of: Private Sub ComboSomeCombo_AfterUpdate() If ComboSomeCombo.Value = "SomeValueinthelist" Then DoCmd.OpenForm "frmSomeForm" End If End Sub hth Chris

Easy way (other ways are there): Create a button call it HLink. Paste this in the Click Event: Private Sub hlink_Click() hlink.HyperlinkAddress = Link.Value End Sub Where Link is the Textbox in which you store the returned value from the query(your C:\MyEbooks\....) When you click the button...

So just to elaborate, if you had a frame with 3 options say called Confidentiality levels: option 1 - everything option 2 - name option 3 - address you would have your frame rowsource as Confidentiality in your Main form with a relationship between Details_Id in tblConfidentiality and...

Use Me.Syntax and Me.SubformName.Syntax example: Me.AllowAdditions = False Me.AllowEdits = False Me.AllowDeletions = False or Me.MySubform.AllowAdditions = False Me.MySubform.AllowEdits = False Me.MySubform.AllowDeletions = False hth Chris

As far as i know this is not possible, Instead just use a form and make it look like an inputbox(Get rid of the control box and tweak it about to get the effect) hth Chris

Me.subformname.Requery hth Chris

Hello Max!!! Long time no see, we should continue the story thread! To answer your question, No. you will have to set the subform to continous and then add the command button like you have said. Datasheet view is tabular in format so even though in design view you can add buttons you won't see...

To be on the safer side , if you have navigation buttons like next, previous etc. make sure you put the code in them as well. Also as jrjr mentioned put the code in the oncurrent event of the form as well as the onload. Chris

If you have deleted the Form called "Switchboard" then it is gone. Use the Switchboard manager to delete the old switchboard and re-make it. Make sure you also delete the table Switchboard items. Chris

Sorry for the late reply, busy at work, the only way i can think of is using continuous forms with default values. hth Chris

You will need a continous subform linked via the master/child PK ID fields. Make the default value of the final date as =Date() and create a button on the sub form next to the field called change final date or something which once clicked will empty final date and allow the user to input the...

As Col as explained, however, if you don't want to use a sub form , make a query and use D Lookup for the "oil" field. Chris

Attached is an example i just made, have a look, it should guide you to what you want to achieve. hth chris

what is your Primary Key then?? chris