Search results

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.

Talismanic, Hopefully my answer in the forms section should help. Former

Sorry for not being more helpful before you will need this code Private Sub myTextBox_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 9 Then KeyCode = 0 End If End Sub Basically when a key is pressed when the text control has focus this sub will run. It checks to see if the key...

Chris - what you want to do is use the command DoEvents, at critical points in your code, i.e. after the call for each query, report etc. Hope this helps

If you put some code on the Key Press event of the control, a catch for the press of the Tab button, and cancel the action.

You'll need to put some code on the OnExit event of the last control on each tab, so that when the OnExit event is fired the first control on the next tab is given focus. Do you want the code ?