Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Micah68

    Database corruption - loss of forms, reports

    The database is not split. Yes, I had a backup and was able to import all of the objects into a new, clean database, a process which I believe rebuilds all of the system tables. But I am trying to figure out the source of this problem. So does anyone have specific information on the...
  2. Micah68

    Database corruption - loss of forms, reports

    None of my tables or data were corrupted, fortunately! But approximately 50 objects (mostly forms and reports) were simply deleted from the database. One user was merely entering records in an unrelated table when this happened. I am wondering if the mSysObjects table somehow became...
  3. Micah68

    Database corruption - loss of forms, reports

    Has anyone ever experienced an Access crash that has caused forms, reports, macros, and module objects to be deleted? I would be grateful to hear any thoughts on the matter. I have a database with approximately 60 tables, 60 queries, 50 forms, and 20 reports. Upon opening it after some sort of...
  4. Micah68

    convert text field to date/time field using VBA

    Skip, Thanks, but see my two earlier postings -- I'm "from one Access database to another (File|Get External Data|Import)." Importing a table from one Access database to another does not start the wizard which does not allow me to save the import specification. Your idea had merit, but it just...
  5. Micah68

    convert text field to date/time field using VBA

    Sorry, but for this specific type of import "the Import Wizard doesn't start" But that's ok, I've already worked through this. Thanks all, for the help.
  6. Micah68

    convert text field to date/time field using VBA

    ok, I'm with you, but I do not konw how to save an import specification under menu system when importing objects from one Access database to another (File|Get External Data|Import). In this case the Import Wizard doesn't start (which is where I believe I've seen the option to save the import...
  7. Micah68

    convert text field to date/time field using VBA

    But see my earlier posting -- "Right now the import happens through a macro TransferDatabase action which works slick -- no user interaction required." But this import process provides no options for modification.
  8. Micah68

    convert text field to date/time field using VBA

    Skip, There is no manual decision here. I already know what field I need to convert. The trick is only how to convert a field to a new data type programmatically. pbaldy - I think that's exactly what I was looking for. Thanks.
  9. Micah68

    convert text field to date/time field using VBA

    If I was manually importing the table, yes, I could adjust the data types as I go, but I need to keep this process automated. Right now the import happens through a macro TransferDatabase action which works slick -- no user interaction required. I just need a programmatic -- VBA -- way to...
  10. Micah68

    convert text field to date/time field using VBA

    I used this calculated field in a query: CalcDate: iif([ImportedDate]="",Null, DateSerial(Mid([ImportedDate],7,4), (Mid([ImportedDate],1,2), (Mid([ImportedDate],4,2))) ...and it worked. I still don't know how to programmatically change a field's data type using VBA, but I can base the rest of...
  11. Micah68

    convert text field to date/time field using VBA

    Thanks. The data always comes in like this: mm/dd/yyyy -- there is always 2 digits on the month and day, so that part is good. So far, all I've had to do is change the data type of the field to Date/Time in Table Design View of the table and all is well. (I haven't seen any bogus dates yet.)...
  12. Micah68

    convert text field to date/time field using VBA

    I need to use VBA to convert a field in an imported table from a text data type to a date/time data type. Any suggestions greatly are appreciated.

Part and Inventory Search

Back
Top