Search results

code DoCmd.TransferText acExportDelim, ,republicanQUERY,st.txt,Yes, , , This is the code I am trying to run and I can't even get this to work, does anyone have any ideas?

I have a form uses a bunch of different filters that are saved into the (Me.Filter). I need to transfer certain fields to a comma delimited file based on the (Me.Filter) criteria. Does anyone know how I can do this. You can't do it using the (Transfer Text) Macro because you have to define a...

I have a split database in a folder on my c: drive. I want to move the database to another folder, but it keeps trying to find the data from the other folder. Can anyone tell me how I can change the data source to point to the new folder?? Thanks so much.

transfer text I tried the transfer text and it worked perfectly except for one thing. How do I get the "field names" to be the first row of the newly created .txt file? Thanks

I tried the transfer text and it worked perfectly except for one thing. How do I get the "field names" to be the first row of the newly created .txt file? Thanks

macro I am running a macro with my command button. The macro uses the "outputTo" function with the ms-dos .txt format. Would it be better to just use VBA. If so , how do I go about doing that.?? Thanks

When I export out of Access, it doesn't export it the way I have to have it to import it into my other program. Here is the way it looks when Access exports it. ------------------------------------------------------------------------ | NCSSTATUS | ATDOOR | HOWMANY...

I have a form. On this form a user clicks a command button which runs a macro. The macro has an OutputTo action. For the "output format" I have tried both .rft and .txt. Neither one of these formats output the records to a comma delimited file. I have to import the records into another program...

OK!! your right You are definitely right. But right now I don't have time to change it, so I will within the next week. Thanks

Thanks I would have never thought of a bug being the problem.! Thanks

Reasoning I also have a field called "PRECINCT". This stands for the precinct number. Each candidate probably has 10 to 20 precincts in a "district". So lets say that a candidate wants to pull all the democratic and republican voters from a specific precinct but doesn't want the independents...

I use a command button on a form to open a report. You can't see all the fields on the report because it always opens up in "portrait." Is there any way I can specify to open up the report in "landscape?"

Thanks Thanks Rich, that was exactly the piece of code I was looking for!! Pat, you are right, but you would have to look at my whole setup of things to see why I did it that way.

Thanks, but that didn't work The only filter you can use on a report is a "query" or a filter "saved as a query". Is there any way I can save the filter that the form has using VISUAL BASIC??

here is my code and I was wanting to know how to attach this filter that I have make called 'josh' to the report i'm opening because I want the report to only have the records that are on the form. Private Sub Command50_Click() josh = "VOTERID>' '" If Me.PrimaryButton.Value = True Then josh =...

I need to generate a report using only the filtered records a user has filtered on a form. How do I go about doing this? Thanks for all the help!

Can you open two forms, on 1 form put a command button to save the other form which is going to be a "filter by form"???

Thanks to everyone for all the help, especially Alexandre. Can I set up a command button that will open the current form into a "filter by form" mode. and if so Can I take everything that the user defines in the "filter by form" and save it as a query? I have generated a report off of the...

Thanks Thanks for all the help Paul!!!

Can I set up a command button that will run another filter on a form that is already filtered. When I do a second filter, it filters all the records instead of just the records that are already filtered. any ideas?? Josh