Recent content by bdj

Unfortuntely I never did get to the bottom of it. Brian

Thanks for your help If I crack the problem I will certainly give you an e-mail Thanks again Brian

HELP - Going off my Rocker Yes it is exactly the same type of problem. It really shouldn't be that difficult to display all records in a subform - even blank ones but I have worked my way through all my Access and VBA manuals to no effect. Brian Jermain

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...

Form Design I realise this would be a solution but what I am trying to do is get all locations (in the location table) to appear in the input form with the tick boxes against each of the entries and not have to use a combo box to select up to 30 sites individually for inclusion in the subform...

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...

US/UK formatting I have tried Rich's suggestion and it didn't work unfortunately. However rather than use Format dd/mm/yyyy I decided to go the whole hog and use mm/dd/yyyy in exactly the same way as he described two posts ago and low and behold it works. Does anyone know why? I have now...

US /UK Date Formatting Unfortunately I did not write the code. I just inherited the database and have been trying to sort out the problem. I have never heard of the transfer text methodology but I will certainly investigate and thanks for the advice for the date field - that certainly makes...

Us/UK Date formatting Thanks for all your help but it really does not explain why when it is exported from one copy of the database in the correct format it changes the records when it is imported into the master copy of the same database. The tables that are being imported to are all set for...

US / UK Date Formatting The UK format is dd/mm/yyyy Unfortunately a date like 3/10/2003 becomes the 10th March 2003 but 31/10/2003 stays as 31st October 2003 because there is no US alternative. This is what creates the problem Brian Jermain Scotland

US/UK formatting I wish it were as simple as this. What I am trying to find out is if you create a table is it beneficial to retain the US format and only use the UK format when you are displaying in a form or report. In this way the base table will always be OK so that when the information is...