Search results

That is all down to how you want to construct your menu system.

You have to tables which have been joined using a common field. one table has 2 records that match and the other table has 13, therefore 2x13 = 26. For every record in table 1 it is being displaed for every record in table 2

Also [StrLoginName] is a variable so it does not need [] around it

are you using the .Caption element? ie Me.Label.Caption = ....

=Trim(Replace([SiteName] & ", " & [SiteAddr1] & ", " & [SiteAddr2] & ", " & [SiteCounty] & ", " & [SitePostCode],", ,", "))

You might be better using a listbox than a combo box. A combo box can get a little bit iscolated whereas a list box can be more intuative and the user has less mouse clicks to perform. Create a table that has two fields FrmName FrmAccessName FrmName contains the name of the form to open that...

Alot easier and quicker way is to use Replace() Address = Replace(Address,",,",",") Thus replacing all intances of ,, with ,

Rs("PlacesAvailable") = Rs("PlacesAvailable") - 1

Do a search on Cartesian Product

Your form eventDelegate does not have TxtDelegate or txtEvent control names Your form CoursesDelegate has a control named txtDelegateID but no control called txteventID but you do have a combo named cmboevent. take a look at the coursesdelegate form

On your form CoursesDelegate do you have controls named DelegateID and EventID? You need to refer to the controls on the form not the fields they are bound to. So if you have a textbox called TxtDelegate that has the DelegateID as its controlSource you need to refer to the TxtDelegate Not...

Dim Rs As DAO.Recordset Set Rs = CurrentDb.OpenRecordset("Select * From TblEventDelegate Where DelegateID = " & Me.DelegateID & " And EventID = " & Me.EventID) If Not Rs.EOF And Not Rs.BOF Then '///Record Exists Else '///New Record End If This will give you the same results

Sundays are quiet. Have you referenced the correct Excel Object in your Tools and References to accommodate 2003?

You cannot use TextBox1.Text unless the control has the focus

When has your assignment to be in by?

Just tried in A2007 and the not in list error fired

Yes exactly that

Try this link for any pointers. Did notice you used >> which was wrong should be =

As 2007 does not support calculated fields that is why I cannot open it. Debs if you remove the field as it is not relevant to your issue and try and reduce it down to either 2007 or 2003 format I will endevour to retry.

If you go to Quick Links and select the bottom menu item Who's Online you can see who's on line and what they are doing. You won't see me as my profile is set to invisible.