Recent content by meadt

Hi Guys, I've been playing around with this all day and can't seem to get it to work. I am filtering a column of numbers for anything greater than the value of a variable. The code works when I write in the number itself, but can't write a version that uses the variable (strDate) I'm...

Hi Chergh, Thanks for replying. Basically I have a large amount of data in a spreadsheet that needs to be filtered. One of the filtering steps is to go down a date column and when the program finds a predefined date, it will add a new row above it. I then need to add some text into this row...

Hi Guys, I need some code that will merge a cell and the one next to it. Problem is this cell could be anywhere and uses code to find its location so it will never be in a difinitive location. Any suggestions? Cheers, T.

Thanks for your suggestion, it worked. Cheers, T.

Hi Brian, Thanks for helping me, I've attached a test file that Ive been playing around with. The format of the date is generated by a VBA function that I dont have access to so I would need to stick to the current date format. cheers, T.

Hi Guys, I am trying to use the custom option on the autofilter tool to filter a column of dates. I need it to filter every entry that equals or is more recent than a date that I put in. The date format is dd.mm.yyyy. The filter doenst seem to filter them correctly or filters them all out...

No thats it, its linked to a command button on a form.

Hi Guys, I'm trying to export the results of a query to a text file using the code below: DoCmd.TransferText acExportDelim, "DE16 Import Specification", "Query1", "c:\winnt\PROFILES\mead_t\Desktop\testing.txt" But when I run it I get the error: The Microsoft Jet database engine could not...

It seems the option is avaliable when you select delimited, but not fixed fixed width, any ideas how to add field names with fixed width?

Hi guys, Simple question, can't figure this out. I want to include headings when exporting a query to a txt file but I can't find an option to do this. I use a saved export specification to do this. Any suggestions? T.

Thanks SOS, Yep that solved it, i didn't have the table highlighted! Cheers guys, T.

Yeah, Im changing the file type to a text document. Thanks for helping me with this guys, it's been driving me mad for a few days now! T

No its 2003, It doesnt make any sense, i can set up Import specifications fine, but the Export Spec. Wizard doesn't come up when its supposed to. Maybe i've innadvertantly switched a setting or something? T

Hi Guys, I'm trying to create an export specification by doing File - Export... - choosing text file - Export All. At which point the Export Specification window should pop up, but it doesn't. It just goes straight ahead and exports the table data to a text file, but in the wrong format...

Sorry DCrake, Just found it. Thanks for your help!