Search results

Is there any way to delete a Table column programtically? I have a table with a column that I would like to be deleted as part of a series of task executed by command button form a form. Every time the table is created the column is used to process data, but I would like to remove it after it...

I have three pass through queries set up in my Access database that are processed on a MSSQL server. All three queries function properly and process the data as expected. My problem is that the parameters (FromDate and ToDate) are being entered via three different forms--one form for each...

Thanks that worked!

I am trying to create a button that will open a a form and insert the Customer ID into the newly opened form. the customer table is the datasource for the customber form and when the button is clicked, I would like to open the Odrers form and auto insert the cutomer number of the record in the...

Worked Great Thanks, that worked well for me.

Recent 10 years How would I query the table if I wanted the easier option of the 10 most recent years?

I have atable the is storing ID, attendance_year and meeting code. Iw ould like to query the table and identify the IDs that have 10 consecutive attendance years no matter when it may have occured. So IDs have more than 10 row of data but not necassrily 10 years in a row. How can I do this...