Recent content by ncook

That is good, I have updated it but the format is still in America even though I have changed the format.

Thankyou, but I have tried that, I also have a different problem that the performance monitors date format has three extra digits at the end for an ID which I can not find how to remove so I can not change the format to Date/Time otherwise it does notimport any data. e.g. 02/25/2004 16:01:11.062...

I have rolled up a performance monitor history log into a csv report. The key field is the date and they are shown in American date format (mm/dd/yyyy) I want to import the report into Access and want to find a way of converting tha dates to English format dd/mm/yyyy. I have tried changing that...

I have inherited a semi completed database, which i have to complete! The designer is unavailable and i have no notes. Everything on the database revolves around a main form, upon which there is a command button labelled @reports'. This command opens a form with three unbound text boxes called...

That worked. thankyou.

I do not want to import the whole table into the new database i need only the data to go into a table that has been created. I have a table called tblTestAsset which has data in it. I want only the data from this table to be imported into the new database into a table called tblDevices, this...

I have created a test database. Then someone sent me a similar database that was almost fully developed. I want to import the data that i had in the test database into a table in the newly developed table. I do not have a clue how to do this. Can someone help me please? Thanks

Don't worry ignore that, i just needed to change it to sum i forgot. Thankyou for your help! Cheers.

i have just tried to create the crosstab query but, all the values come out as 1, and not the total number of equipment for the depot. Do you have any idea what i have done wrong?

I am trying to create a report that is viewed as a colum, and not down the page. I am not explaining it very well so if you look at this: I want a product summary that looks like this: PC Laptop Printer Bristol 1 5...

Thankyou for your help, I just have one further request. The IsNull event works, it removes the label and by using the Can Grow/CanShrink function this removes the text box, but I still get a huge blank space where the null values were. If i make the size of the text box to 0 and then decrease...

There is data in some fields, and no data in others. And when i set the can Shrink to Yes, it removes the data, but keeps the labels, so i still have a blank space. I want to be able to keep the label and the text box when there is data in that field, and i want the label to disapear when there...

I have been working on a report which contains a lot of fields. But many fields do not contain any data, and i want to remove the space. I have tried many methods but i NEED to keep the bound labels in line when the fields do shrink. How can i do this? Please, Please Please Help!!