Search results for query: *

I have a database of which there are many forms which i would like to fit to the size of my monitor. I have tried putting the docmd.maximise control on the open form property but everytime i close a form it shrinks down to its original size. Any help on this would be grateful.

I have a query assigned to a subform which is not displaying all records. I know that i have two records created that match the right criteria to be displayed and yet it only displays one of those records. I have checked the information thoroughly and cannot see what the problem is. Any help...

I am running an update query and i keep getting an error message saying 'the table TBLE_compositions_copy is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.' I am the only person with the database so no-one...

Yes. I am absolutely positive. As i said it has only just started happening. Well, in the code it happens just after the query has been run and i refresh the form with the information that is being updated.

Every time i run an update query i keep getting an error saying 'write conflict' and asks me to copy the information to the clipboard. I am the only user of the database and this has only started happening recently as it was working perfectly before.

I am trying to compact and repair my Access 2000 database but every time i run it from the tools menu it keeps coming back saying Table 'TempMSysAccessObjects' already exists! but this table does not exist. Any help would be great.

No. I am the only person with the database. It has not been split yet.

Whenever i run a particular update query, it comes back with a message saying write conflict and asks me if i want to copy it to the clipboard, save changes or drop changes. I then once i have copied it to the clipboard have to run the query again for it to work. Anyone got any solutions?

I have a form which contains a list box with a figure but I would like it to be selected when the form opens so it gets the focus and the first line in the list is selected. Any help.

Tried it but with no joy. I need to set a parameter inside a query which is tied to a table to update. Any other suggestions.

I have a query where it gives me quantities of materials. In it, the quantity might say i need 2.5 of a certain material, but I only deal in whole numbers. I need something where it will round up to the next whole number. Any help would be appreciated.

I have tried this before but to no avail. I would like to colour a record line in a list box by selecting and clicking a button (colour could be any). Is there any way to do this using Access 2002.

I have a list box which contains a number of records and I want to be able to select a record in this list and change the colour of that item only. Is there any way to do this as I can only get it where it changes the entire list colour.

I have a list box on a form and it contains a value column. I need to extract the Sum of this column into an unbound field but i keep getting an error no matter what I try. Can this be done?

I have roughly around 10 fields in this query, showing criteria for a selected month on loading. The total group just comes back with an error saying I can't have "*" in the query, but I never inserted it in. Any other ideas?

I have created a report which gets its data from a query. I have inputted around 100 records of which some of them have the same reference number, but the revision is different. In this report I would like it to show only one copy of the records with the same reference number, but it has to be...

Is there any way that you can export information from a query or other source to Microsoft Project. Thanks

I want to obtain code whereby if the quantity field is not a whole number e.g. 2.4, 4.8, etc. then it will round up the number to the next highest whole number e.g. 2.1 would become 3. I would be grateful if anyone can help.

Does anyone know how to round up a number to the nearest whole number eg. if 2.1 it will round up to 3, it cannot round down which is what is happening to me.

I have a query which is hiding the duplicates of a record no, which are all revisions e.g 1000 Rev A, 1000 Rev B, etc. I would like the query to be able to show the latest revision created because at present it is showing the first record created and hiding all the rest.