Search results

I have setup a form with 3 fields from 3 related tables I am able to enter in the first two: Comment_type and processes However, I am not able to enter anything in field Comments. (this is a Memo field) (see attachments)

I have made one table with id, purchaser, seller, Then I have a table called entities: id, entityname The purchaser and seller fields reference an entity id How can I setup a query where I now gets the purchasing entity name and the selling entity name. Which relations do I need to setup.

How can I setup that when opening a new record in a form - that one of the fields by default opens up with the current date...

I have created a lookup in a field in a table: select id, bike from tblbikes. Column count 2 Width 0,3 When I try to sort the table by bike: I receive the following error: Type mismatch in expression. Is there some way to sort a field with a lookup.

Hi, I have created a table1, with 3 fields: A, B and C, with 500 rows. I want to copy this data over to table2 starting at row 700. What is the sql for this. Additionally I would like to in the 4th column to write November in the same copy over of the 500 rows.

Hi, I have added a delete button to my form but now I cannot save the form. I get the error message: "In order to save your changes you must remove any layouts that have empthy cells in them and/or set the hasmodule property for the form to no." How do I locate empthy cells.

Hi, I have created a form taking in Data from a query. On the form I have created a combo box. The selected value is used in an criteria of the query. The criteria in the query is: [Forms].[frmMyPortfolio]![cbodep] How can I ensure that all values in query are generated, if their is no...