Search results

Please Please try to help I am having real problems trying to create a form with a subform (which will display every entry from a location table as a tick completion list) There are basically two tables tblStaff and tblLocation and what I am trying to do is for every member of staff I want to...

I am trying to design a staffing matrix contingency plan database whereby I can have staff identity details as the top part of the form based on a table (tblStaff) with StaffID, Surname, Forename and Office as entities At the bottom part of the form I want to display every location entry from...

Thanks for the response Sean but perhaps I didn't explain it too well. What I am trying to do is attach the list box to the Outlook Address book so that I can select the persons e-mail address as an input to the form to be saved in the table. This will then allow me to do customer surveys on...

This discussion group is extremely useful and I wondered if anyone out there had any idea as to how to put an e-mail address list box on a form and have the equivalent of a To:- button that you can select from the contacts list to input the e-mail address to that particular field. It must be...

I am having difficulty in importing records to a database which although it was created some time ago has not been brought into operation because of problems. We are now at the stage where we would like to use it but testing has shown that there is a flaw in the importing/exporting procedures...

Can anyone point me to any good articles on calling files, creating files and path problems due to network configuration. I am delving into automating quite a few tasks in Excel 2000 and Access 2000 and finding that creating a file and then pointing to the path never seems to work. this is al...

I am relatively new to Access 2000 but I keep on coming across the same problems with the date formatting. When using SQL or exporting information from a database to a spreadsheet or using VBA it constantly loses the UK formatting. Can anyone point me in the direction of any resources on the...

Is it possible to display two copies of the same form but with different records on the screen at the same time. If this is possible - Can it be done if the form has a sub form. I have a problem with duplicate records - not in the normal sense but because (females in particular keep on...

I have a query that produces about 90 results which I want to list with 10 to a page and a total for that page in the page footer – not a running total for the report and not grouped. Can anyone advise me of the easiest method. The report is basis on a payform and will only accept 10 lines of...