Search results for query: *

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...

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...

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...

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...

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.

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...

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.

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.

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...

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...

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.)...

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.