Recent content by Former

This is happening because Access cannot find the field and therefore thinks that it is a parameter. Check the syntax on the form very carefully. It's probably wise to delete the control that is causing you a problem and recreate it from the field list. Hope this helps

Would it be possible to send either of you a copy of the database. My sanity is at stack. Thanks in Advance Former

I'm using Access 2000. I open a form in design mode and place a combo (or list) box on the form, the wizard appears and I go through the necessary steps to display what I want. I then view the form and it's perfect. I then close the form saving my changes thinking what a wonderful job I have...

Thank you both very much for your input in this matter. Please accept my sincere apologies for wasting your time.

I've declared a Global date variable and given it a value. Does anyone know how I can then reference this Global in a query ? Thanks in advance

Iryder, you need to use .value .... Me.TextName.Value Hope this helps

If you create a form, with a button on it you should be able to use the Docmd.SendObject from the button and e-mail the report directly, without having to move it to excel first.

Instead of just saying... =Sum([myField]) How about... =Iif(Count([myField])>1,Sum([myField]),"") And set the can shrink property of the field to True. I haven't tested this but I reckon it'll work

Create a Table called tblForms with three fields... FormID Autonumber Form_Name Text Form_Friendly_Name Text Create some records with the actual name of the forms you would like to open in the Form_Name field, and a description for the users to read from your combo...

If your fields are called Time_1, Time_2 etc place this formula in the 'Field:' row of the query window and it should calculated the working day for you. Working_Day: (DateDiff('n',[Time_1],[Time_2])+DateDiff('n',[Time_3],[Time_4]))/60 Hope this helps. Cheers, Former

What kind of control is SeatsAvailable ? Has the SeatsAvailable control got any code associated with it ?

In my database I have created a button and put this code on it Private Sub cmdSend_Click() Dim db As Database Dim rs As Recordset Dim strEmailAddress As String Dim strSQL As String On Error GoTo Err_cmdSend_Click strSQL = "SELECT Members.E_mail " & _ "FROM Members " & _...

That took a little thinking about to get correct. Right then, we have to trap for the down key being pressed when a combo has focus - set a boolean to say that it has been pressed - don't trap any subsequent down key presses - and lastly reset the boolean to False on loss of focus of the combo...

Flattery will get you everywhere - thanks for you comments on another posting - however I'm certainly no guru. I'm working on the down key problem I'll get back shortly. For the other problem with updating the values on a form. I would place the combo on a 'Main' form, and have the rest of...

Actually trap on the key down event... Private Sub myTextBox_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 9 Then Me.myOtherTextBox.SetFocus End If End Sub This traps for the Tab key being pressed and sets focus somewhere else once it is. I hope this helps.