Search results

  1. C

    Setting default value in a column

    I'll give it a shot but it kind of opens up a whole other 'can of worms' I'm unfamiliar with. But at this point everything is pretty new :D
  2. C

    Setting default value in a column

    Or are you talking about just setting up all of my tables and then removing/adding/updating data?
  3. C

    Setting default value in a column

    Automation. Or maybe I'm not following what you mean. I can do all of this in Excel manually which takes several hours or I can experiment with some code and have a one-click solution.
  4. C

    Setting default value in a column

    So if I take what I have and scrap it, replace it with the following code, how would I then go about setting default values? Public Sub Create_tblSears() Dim db As Database, tbl As TableDef, fld As Field Set db = CurrentDb() Set tbl = db.CreateTableDef("tblSears")...
  5. C

    Setting default value in a column

    Lol, again I'm very new at this and my biggest resource is the web. Most of this is snippets of code I've found that I've managed to get to work for me.
  6. C

    Setting default value in a column

    Also, I am aware of the fact I'm removing and replacing my data daily. We run a db here but I'm not allowed access to it. I just get a spreadsheet emailed to me daily so I figured I'd start fresh each day.
  7. C

    Setting default value in a column

    My inventory spreadsheet has these columns: ItemNumber, UPC, Type(discon/active), Size, Width, Price, Available The output has: FileType, VendorSKU, Available, QTY, NextShipQty, NextShipDate, Manufacturer, ManufacturerSKU, Description, UnitCost, UnitCost2, UnitCost3, UnitCost4, Deactivated...
  8. C

    Setting default value in a column

    O.k. it did run, here's the problem. I need it to update for each row already in the table, not just new entries. Let me post the whole code and let you see what I'm doing.
  9. C

    Setting default value in a column

    The above listed code errors out. DoCmd.RunSQL "ALTER TABLE tblSears ADD FileType Text NOT NULL CONSTRAINT [DF)tblSears_FileType] DEFAULT ('IN');" This code runs but doesn't even add the FileType field. I'll try modifying the field after it has already been added.
  10. C

    Setting default value in a column

    BTW I'm a complete access noob, I tinkered with it years ago. I'm probably doing it all wrong but its working . . . thus far =D
  11. C

    Setting default value in a column

    The inventory reporting I do has about 16 columns in an Excel template. Of which I only populate about 6 fields from data I have others contain info such as date, filetype ("IN" for inventory), etc. So I'm importing the data in, running a make table query and adding columns with the default...
  12. C

    Setting default value in a column

    I'll give this a shot and let you know, in the middle of running the reports manually atm. =)
  13. C

    Setting default value in a column

    Using a DoCmd.RunSQL to create a column in a table, now I need to set the default value and I'm unsure how to do that. Is it in the syntax? What I've found thus far hasn't worked for me. DoCmd.RunSQL "ALTER TABLE tblSears ADD COLUMN [FileType] Text;" Thanks in advance,
  14. C

    Been awhile, tell me if I'm missing something.

    It's been a long time since I've had anything to do with Access, but I'm back at it again. I am currently using Excel to do a number of inventory reports on a daily basis. I would like to condense these into Access. There is a daily report of all of our stock in Excel. I would like to be able...
View older results
Back
Top Bottom