Search results

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

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

If you go into www.microsoft.com and then go into the knowledge base and do a search on any problems or use the Q series number then if a problem has been resolved or it is a known problem details will be displayed

HELP _ GREMLINS ABOUT After having completed the instructions in Q132017 I found that everything worked perfectly - ON THE SCREEN. Each page was added correctly and seemed to be the perfect solution until I went to print it out and found a grossly distorted negative number as the sum of the...

thanks for the help BJ