Recent content by mooredk

Hey Lucy! I think I did. I'm annoyed at myself for this taking so much of my time. Seriously how did I miss it. Oh well it is done now:). Now on to cascading combo boxes:) Debbie

Hey Lucy, I did the show actions and see the import/export action. I thought i had done that already. I knew it still had to be there! I ran it and it worked but I iwll have to create a delete query for that table b/c it is appending and not overwriting. I"m not sure which is better code or...

Thanks for the advice. I may try this. I didn't really think it mattered b/c it said optional. I will get back to you if it works. Thanks, Debbie

Ha ha ha..you make me laugh!! I will defnitely try this. Unfortunately my other job duties are taking priority at the moment so it may not happen until Monday. I will definitely try though and let you know. THE delete query is a good idea! Thanks again!!!

Hey Lucy Believe me..I've been limping too. I know a little vb but probably enough to hurt myself:). The file will be overwritten each day. The number of records will vary from day to day. I have tried everything and so frustrated b/c this was a VERY simple task before. And I AM NOT A...

Hey Lucy:)..I thank you for getting back to me!! And I'm a very detailed person so it didn't bother me however, I didn't need the excel explanation:). Basically I want an automated way to import a daily excel file into Access w/ a command button. In previous versions of Access (pre-2010) I...

Did you ever get this to work? I'm trying the same thing and using the following code (called by pressing a command button) and can't get it to work to save my life! No compile errors but when I hit hte button, it opens the vb code window. Public Sub UseTransferSpreadsheet(strTableName As...

Can anyone tell me how to create a command button to automatically import an excel file. The table and file location remain the same. I used to create a macro to perform this but cannot find it in Access 2010. I know how to "manually" import but this database is going to be for users that...

I have created 2 tables. 1 for the upload and 1 for the data to be entered. I have updated this table with the "unique id" we have created out of the download. I created a query linking these 2 tables and making it a make table. I have built my form off of this make table. My concern is the...

The daily import would be from the system. There would be no updates from the user at that point for the "new" records. I guess I need to compare the new import to the ongoing data extract table to see what records are new and then append them to this table? And then when the users go on...

Thanks for all of the suggestions. The daily upload will be the exact data fields as the "initial" table we will update. They are supposed to be modifying the extract to include a field we will use as our primary key. THis field will be a concatenation of several fields from the extract. My...

THe file is to be uploaded daily. We do not want duplicates though. So, we are in the process of creating a primary key concatenating multiple fields. The only way I can think of not have duplicates append to the table is to compare the new file to the existing file (table) and pulling out...

Thanks. Some more questions though: 1.) I should create another table that would contain all of the fields from the imported table and the "user" entered fields? Or should the "new" table should only contain the "new" fields entered by user and a "primary key" that will link the 2 tables...

I'm trying to build a form based on a table where the user can also enter data to update the table but with data fields not originally in the table. Below is a summary of what I have and what I need:rolleyes:: 1.) A file that will be uploaded daily into a Table (ie name Denials extract...

Oh my gosh!! I have searched forums and read this book. I thought me.filteron = false would work...I would have never figure of me.filter = vbnullstring! I tried some other code with me.filter but not that! Thanks so much. Frustrating not figuring out on my own what seems to be the simplest...