tabledef

  1. MacroAlan

    Build query from Defs

    I think I've seen what I'm looking for but cannot find it again! I have this huge Crosstab query that shows columns for each month from Year minus 1 through Year plus 2; i.e. 01/01/2017 thru 12/1/2020. I want to gather all the field names into a new query that writes to a new table. I...
  2. J

    Reassign the table to which a TableDef object refers

    Hello all. Thank you for reading. I am running some code that creates new tables in my database (based on records in a table: one new table for each record), and then subsequently I am trying to iterate through the newly created tables to add new fields (once again based on records in another...
  3. M

    Setting Default Values for all fields in a table

    I recently learned how to set default values for all fields in a table using VB (DAO). Public Sub Make_defs() Dim x As Integer For x = 1 To CurrentDb.TableDefs("import_format").Fields.Count CurrentDb.TableDefs("import_format").Fields(x - 1).DefaultValue = "=null" Next End Sub I had a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top