Search results

I want to create a button that adds as many records to a table as you want. So I would have - a text field where the user would input the number of records - the code of the button having a for loop or while statement to add that many records as the user typed in This is my code of a button...

Is it possible to modify data values in a cross tab query? I tried and it won't let me delete or type anything. Thanks.

I am trying to link Primary Key (autonumber) to a double field in another table as a FK. I get this error. Relationship must be on the same number of fields with the same data types What is the problem? There is no problem with the data itself...it should work. But is it a problem with the...

Is this possible? I want to have a combo box with a listing of names from a table. Once you choose a name, a textbox in the same form (not subform) populates with the corresponding ID. Thanks.

I just recently noticed that the database that I have been working on has changed from around 60 mb to 430 mb. I added a few queries and forms. But could that really add to the size that much?

Without using a cross-tab query, is there anyway I can display the rows as columns on a report...ie printing them horizontally, instead of vertically? Thanks.

In a cross-tab query, I want to hardcode the column names in the properties. But I want only those columns that contain data to show up when queried. Can I somehow put and IIF statement inside the PIVOT command? Something like: if a column containes data based on my query pivot on that column...

I have created a crosstab query based on this table. VALUES __________ Oil_ID (PK) Property_ID (PK) Col_Heading (PK) (*112 distinct values) Row_Heading (PK) Col_HeadingUnit Row_HeadingUnit Values Oil Name Property Name The crosstab query looks like this so far. PARAMETERS [Forms]![Values...

This is my first time posting here and I hope you guys can help me. I have a problem with using a crosstab query. My original table looks something like this VALUES Oil_ID (PK) Property_ID (PK) Col_Heading (PK) Row_Heading (PK) Values Oil Name Property Name I made a crosstab query with...