Search results

How would I do this on a report? I want to group by a set of numbers, including negative, but ignore the negative number... Like this... 123 123 123 -123 46 -46 46 2 2 2 14 -14 etc...

Bob, I found this in another of your posts and it is exactly what I'm looking for... However, how does it know what the file name is? I guess you pass it to the sub from the form when you call the sub? Public Sub ConvertTextFile(strInputFile As String, strOutputFile As String) Dim...

Thanks for that. I tried it...bombs out here... rst.Open "TextImportTest", CurrentProject.Connection, adOpenDynamic, adLockOptimistic Says "Invalid SQL statement; expected 'DELETE'....etc"

I have an objective that I need to do and I thought, at first, that it was just to import in a text file using VBA...but now I'm not sure. Here's the objective: Write a program (do not use DoCmd.TransferText) to convert "test.txt" to a tab delimited file. All fields must be trimmed of extra...

I got to thinking about it a bit and couldn't I actually do something like this? First, define my column variables as text and then store the text fields into those variables. Then... SQL = "SELECT ColName1 As " & ColVar1 & ", ColName2 As " & ColVar2 & " etc...

How in the world can I accomplish this? I have a set of dates on a form that change from week to week. I'd like to reference these text boxes in a query as column names. How can I do this?

As stated already, compacts just fine on my local drive.

bumping it up

bumping it up

bump.......

I am currently building a process in Access that creates a report in Excel consisting of multiple tabs of data. The building of this Excel file is not a problem for me. Here's the issue I'm having... There is a sheet in another Excel file that is created by someone else that I need to use in...

No one knows, I guess.

Bump........

I'm still on 2003 and this is happening... :(

Sure can. I go in and delete all the copies. Just to properly compact, I have to copy to my local and then compact. Then I replace the compacted file on the network.

That might be likely if it wasn't EVERY database that I have on the network doing the same thing. Besides, it would give it the original name and stick "_Backup" on the end of it. It doesn't do that.

It's only me that is using them. I have them on the network because the network gets backed up every night.

I tried the search and while I found some things related to my issue, I couldn't really come to a conclusion on my issue. I have all the databases on the network set to compact on close. This is resulting in a new copy of the compacted database with the generic "db1.mdb" file name every time...

I'm working on some data in Excel. I have a couple of data sets that I want to chart but I want to be able to control which data set is charted on the chart with a combo box. Anyone have any ideas?

Yeah, I knew about the cell thing. I was just trying to get around it. Thanks, though. :)