Search results

Thanks a million, this works.

I have tried many instances of the DoCmd.OutputTo syntax, this one gets me the closest. I don't understand why it is saying that it can't find this report, it definately exists!

I get the following error when attempting to export a report to excel via vba: The Microsoft Jet Database engine could not find the object 'over view report'. Make sure it exists and that you spell its name and the path name correctly. This is really driving me nuts. Below is my command...

I have implemented the method (code) used at this thread: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=7463 Is there a way to specify only specific queries and reports? Thanks.

I posted my sub routine and sql below. I used the caption property in my alias query to set headings. SELECT test.Field1, test.Field2, test.Field3, test.Field4, test.Field5, test.Field6, test.Field7, test.Field8, test.Field9, test.Field10, test.Field11, test.Field12, test.Field13...

I have an alias query set up, to get rid of generic field names. When I export the query to excel via Access or via VBA code, the alias field names are rest to the generic ones. Is there any way to retain the alias headings when exporting? thanks.

I have a monumental task at hand. I have a table with a field that needs merged. Below is a sample of my data: ID ListID ContactID ProfileQ Response Description 1 22403 1110 02 1 Cosmetic Surgery 2 22404 1110 03 5 Office Nurse 3 22405 1110 04 2 Physician's Office 4 22406 1110 05 2...

mike's code Mike, This looks like exactly the code that I need. I have a column of data that I need to define as a string, I suppose and then call up this code. How would I set this code to fucntion on a particular column of data (save as string?). If you could give me an example, that would...

PROBLEM I am familiar with creating import specs, they are a real life saver. The reason that I was converting to excel first is because the first line or row of my csv file contains consistent erroneous data. The field headings appear on row 2. I have no idea how to manipulate the csv file...

problems in code Fornation, The code that you provided is troublesome in two ways. For one, apparently the csv and excel files are not being properly "shut down" after the code executes. If I try to delete thes files, I get a sharing violation. Also, I get a data type mis-match on this...

registry Is there any way I could change the registry to include *.report files? I have already attempted to do this with no luck. Is iteven possible to get the Jet engine to recognize *.report files?

I am making use of code that I found here to manipulate the windows open/save as dialog. So, with that in mind, the user is being prompted to select a file from the network, and when they do a new form opens with this code behind my "import file button": Private Sub ReadDoc_Click() Dim...

I have a variety of modules set up that allow the user to browse for a file and import it. The name of my string is Me.FileName. I have a macro that I use to import a specific excel spread sheet. How would I define the string in the file name field in Access' macro design view? Thanks in...

I have been toying with this, but no luck as of yet. That code I posted has many problems when executed.

I have the following code below, but there are 2 issues. 1) for some reason, you have to click open twice for the dialog box to close. 2) The program tries to overwrite *csv ant the end of execution instead of renaming it to *.xls Private Sub Command148_Click() Dim strFilter As String Dim...

thanks I have already been making use of that code you posted and I have been toying with it to make it work for what I need. I can't figure out how to use it to simply browse for a file name, then save it in a string so that I can use the string as a file path in this first piece of code...

I have code set up that takes a *.csv file and converts it to .xls among other things. The name of the *.csv file will change, and I would like the user to be able to browse for the file, then have the file name and path saved to a string which in turn will be identified when this command is...

taking this a step further This code works great. I need to take it one step further, though. When the user clicks this button, I would like them prompted (browse) for the file to convert. I have made use of the module at this link to open and export files...

I figured it out. This is my code for importing using the same module. Private Sub Command190_Click() Dim strFilter As String Dim strSaveFileName As String On Error GoTo Error_exit strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.xls)", "*.xls") strSaveFileName = ahtCommonFileOpenSave(...

How are you today? I am looking into how to incorporate this code in browsing for files and importing them. I have already made some progress. Current code: Private Sub Command190_Click() Dim strFilter As String Dim strSaveFileName As String On Error GoTo Error_exit strFilter =...