Recent content by dunnma

I have a subform that has a cell on it and when you click on the cell, it will tell another subform to display data based upon the unique id. At the same time I want the second subform (call it data) to display an image if an image exists. I have a function that is called updatePath, that if...

Just to be even more clear, I pointed out the line continuation characters, but since we are all family here, it is all good. :)

Did you copy and paste exactly? Queries in VBA cannot span more than one line unless you "join" the lines, i.e. strSQL = "SELECT field1, field2 " & _ "FROM table1, table2 " & _ "WHERE condition;

Well, lets call this thread "closed". I used the Kill command to delete the file. Thanks for all of your help guys!

I figured it out. It works like a charm. Basically all it does is rename the file, import it, and then I rename it back to what it was (for appearances sake). I will do research to see if it is possible to delete the file, or erase the data in the file.

Does your query work in the normal query screen? I am pretty sure the problem is with how you are "linking" all of your INNER JOINS with (.

I think that will work. My problem now is that part of the data is being set in the Form_Load() (and this is the part that is actually being updated in the "pop-up"). Is there something else other than ReQuery that will ReLoad the entire form (with the current query and stuff in form_load())?

So change this: DoCmd.OpenForm stDocName, , , stLinkCriteria to this: DoCmd.OpenForm stDocName, acModal, , stLinkCriteria and add this: Me!.form.Requery

I have a command button that opens a "pop-up" form for the user to make changes to. I have everything working perfectly, except that when a user completes the tasks on the "pop-up" and it closes, the original "opener" does not reflect the new data. Is it possible that when the user closes the...

I receive "file not found" and the debugger points to the first row below Name CurrentProject.Path & "\import.csv" As CurrentProject.Path & "\import.imp" 'Load offline data CSV DoCmd.TransferText acImportDelim, , "tblImport", CurrentProject.Path & "\import.imp", True

I added this: Name CurrentProject.Path & "\import.csv" As CurrentProject.Path & "\import.imp" Above this: DoCmd.TransferText acImportDelim, , "tblImport", CurrentProject.Path & "\import.csv", True And I receive an error that the file was not found. Do I need to set it as a variable? Thank...

Thank you for your help. This actually turned out easier than I had thought. I created a command button called import and it will look for a predetermined file that is stored in the same folder as the Access database. It will import it into one table, then spread it accross the other tables...

I have my import function successfully importing a CSV file. I would like to modify it so that there is no need for a CSV file and it will get the data from a html file from the Internet (if connected) and just dump it into one table as-is. The first step is to get my database to load data...

Oh, I am sorry. I want to design this so that the user does not have to go through the import wizard. I would like for me to put a "browse" link for them to just find the downloaded file and then the programming work from there, or better yet, just when the database is opened it automatically...

That looks like what I am looking for. 2 questions though, 1 - How do I "link" my Excel file to the database? 2 - How does the code above know where to get the artist_id and artist_name?