Search results

I wonder wether it is possible to copy elements from one database to another. I have two copies of the same database. One for development and one for user access. If i for instance would like to copy a form from the development database to the other, how can this be done?

Thanks! - that was exactly the info i was missing.

I want to modify some of the fields in the datasheet after Access has populated it with data. It would be possible if i could process the datasheet as if it was a recordset, but i don't know how to do it.

I would like to be able to process a datasheet as if it was a recordset produced by an ordinary tablequery, thus gaining access to its fields.

How do i access the fields in a datasheet? The fieldnames refer to a complete column in datasheet mode.

Solution. Found a simple solution: Simply add 'SORTED BY fieldname DESC' (or whatever wanted) to the select statement that populates the datasheet.

I have defined a combobox on a form that shows a list of values from a query on a table. I can show the list, but i can't select a value from it - it is somehow locked. What is wrong

I have set up a combobox on a form that reads values from a table. Have can i select wich column of the table it reads from. At present i always get the first.

Thanks. Unfortunately i am not running it from a query. It is a subform in datasheet mode.

Thanks. Unfortunately i can't find the runcode command. I am using another language than english.

I have set a datasheet to be sorted descending on a date in the sorted by field of the Data tab, but the sort isn't performed when i open the form. What can be wrong?

I would like to run a module (procedure) from within a macro. So far i have only found a command that opens it in designmode.

Thanks alot for the quick reply :)

I would like to know whteher it is possible to close or minimize the database window from within a form. The common user has no need for it, and it only confuses the projects interface.

LOL - to many sources can mess up you're dinner. Controlsource it is. Got it - Thanks for you'r help.

Thanks for you're reply. I think what i need to know then, is how to access the Recordsource field or row. Tried Me.Recordsource!Fieldname but that didn't work.

I have added af field to a subform where i would like to place some calculations. How do i access this field in datasheet mode. Since i need to loop through the column i also need to know how many rows the datasheet contains. Hope you can help!