Recent content by highland

I have managed to get it to display the record. I didn't design the database myself but I am now the person who has to maintain it. When data is inserted into the title field they should use the lookup provided, but someone had entered a value which was not available on the lookup. I have...

Thanks for your reply. I have had another look and have found the record which is not being displayed in the form, I have done a search for it on the form and cannot find it. There doesn't appear to be any filters on the form to prevent this record from displaying.

I have a database which has one main form linked to a table which has 325 records in it. The problem is when you open the form it says there are only 324 records :confused: I have gone through the table comparing the records with the form records, I found what I thought was the 'missing'...

SJ McAbney, works a treat!!!! thanks also for the prompt response Cheers Mate Tel

Done that The following is displayed MISSING: Microsoft Outlook 10.0 Object Library is ticked. Location D:\OfficeXP\Office10\msoutl.olb any ideas?

Hi I have created a database in which an appointment sends to the default outlook calander. When I use Access/Outklook 2002 the database works, however when I try it on Access/Outlook 2000 the database does not work. I attach the code: On Error GoTo Err_cmdCreateAppt_Click Dim outobj As...

Thankyou both for your reply ;) I've got it working thanks to looking at both your examples - really appreciate your time and quick reply. Thanks :D

I'm trying to create a command button which will print a Report from a list. I have seven different reports all contained in a listbox. The listbox is called Report_List. I would like the user to select a Report from the list and by using a command Button (CmdPrintReport) print the selected...

Thanks for your reply. ;) I've had a go at putting your code in the database (looks alot less messy than mine) but I've been getting an error message. When I click the button I get an error message saying 'Compile Error: End If without block If' It highlights the End If in red below. But if...

Problem solved - took a while and a wee bit of a search. I've managed to use a button to act as a default when pressed. Theres probably a better way of doing this but it works. ;) Private Sub Cmd_X_Click() ''Cmd-X is the name of the default button for inputting details in fields On Error GoTo...

Thanks for your reply. ;) Its not filling the field in - but now its saying it can't find a macro, which isn't surprising because I haven't built one (and I'm not sure how)

I'm creating a small database which holds information about Grants. I have built a form and created reports which act as confirmation letters. The Reports use Communication fields as their address. I would like to populate the Communication fields with data already on the form in other fields...