Search results

I have code that is supposed to make a file path (on the local drive) and put a file there. The code checks to see if the file path exists and if it doesn't, it creates it and then dumps the file there (excel format via transfer spreadsheet).. The next time they run the program, the part of...

We use Lotus Notes at my work, so I have to use the "send email" code as posted..therefore it appears I cannot use the code per the link you posted.. Any other suggestions? Thanks..

I am using some code that allows me to send via email an excel attachment. The excel file is created using the transferspreadsheet method and is created from a table. What I want to know is, is it possible to save the table as an excel file but as a variable only (so the file is saved in...

OK, now it works. What was that all about? I have no idea why the error messages I got were there before. The same code was used. Must have been a bug or something.. Thanks for all your assistance!

I put in Kill, but this time got a: File Not Found error msg. I went to debug and hovered my cursor over str_dir and it did show the directory that I just created.. any suggestions? btw, when i looked up kill, it said: An error occurs if you try to use RmDir on a directory or folder...

Cool, thanks.. One other question. When making the directory, I wrote some code to delete it (see full code below). However, I get an error when trying to delete the directory. The error is: Run Time Error '75' Path/File access error. Also, if I open IE and try to delete it manually, I get...

Using: Access 97.. I would like to export data (in Excel format) to a users c:\ drive. I want to be able to create the folder with my own designation (name) and then export the table data as an excel file. I know how to export the table as an excel file, but not how to create the folder...

Your code worked..:) I looked up the above link, but there was nothing denoting the constant values for DoMenuItem. It appears, though, I should probably just use the Run Command as that does everything the DoMenuItem does and more? Thanks for your help..

I used the (msaccess 97 ) wizard to create a delete button placed on a form. The button works fine; however, When I click the button and select no to deleting the record, I get what appears to be a standard MS msgbox that says "The DoMenuItem was canceled.." and some other stuff that would...

Here is my code. Note, it is not finished yet. There are still some procedures to add. The dlookup is used prior to saving the record to the temp table. It takes the value of the associate id entry and checks it against what's already in the table. If its there, a msg box returns and says...

I am using a temp table so as to avoid having multiple people save to the same table. So each time a user selects their id, the code creates a temp table that accepts all their data and their data only (it is a unique table name based on their id and the date/time). When done the data from that...

I have SQL code that appends data to a table. The table has an associate id as a primary key so that two identical associate id's cannot be appended to the table. However, when the append code is run, Access doesn't provide an error message I can use in code to inform the user that they...

I could try that. What are the advantages of using Dcount over the method I was trying? Is one or the other a better practice due to memory or speed of processing? Thanks..

Access 97.. I am trying to write code that will count the number of records in table, but it appears that I'm getting the syntax incorrect as I keep getting a Type Mismatch error. The code is: Dim d As Database Dim tdf As TableDef str_obj_name = "table_data" Set tdf =...

Ok, thanks, I'll give it a try..

Would like some help on how to output my Access report to a PDF file.. When I do it manually, I select Preview Report, then change the Printer Name to Adobe PDF (as I have had the version of ADOBE that allows for this).. and then click OK. I am then prompted for a location which I enter and it...

ok, thanks..

ok, I'll try that. Have a question though. Why count backwards (via the "Step -1" code)? Why not "0 to dbCurr.TableDefs.Count -1" and count forwards? Oh, and why the $ sign after the left? Does that force a string? Thanks..

I would like to delete tables using code where part of the table names have a certain value. So the table have as their first 13 characters the following string tbl_req_tmp_a.. I would like code to iterate through the tables collection and delete all tables that have this as the first 13...

Thanks, the indexing issue is something I haven't thought of. Probably because there will be so little data in my database that indexing won't be a huge issue. But its good to keep in mind for the future and a good practice I suppose even in a small database in case the amount of data ever...