Search results

I would like to know the function that would return the computer name that is currently running the database. Any and all held is greatly appreciated. TIA, Erik

Is there any way to search through SQL statements and/or VBA code without having to open the actual form or query?? TIA, Erik

An easy way to get around this is to simply create a recordset based on the record source of the report. then use an if statement like the following: Dim rst as DAO.recordset Dim db as Database set db = CurrentDB() set rst = db.OpenRecordset("The reports record source",dbOpenDynaset) if...

I would like to open an instance of Excel, but no workbook in particular, therefore, by default, Book1 would be the worksheet to open up. Upon opening excel, I would like to run an excel macro, and then close excel. I've searched for this but haven't found a way to open up excel. Any and all...

If you had read my original post, I mentioned that this post was "a little off topic", I figured I'd post this in the "General" forum, even though it really wasn't an Access issue. I didn't think it would really pose a problem. I like this forum a lot, and I get most of my questions replied...

I know this is probably redundant, but hopefully you are aware of the "compact and repair database" feature in Access.

What format is your EDI file? I'm not sure what you are asking here, as I import EDI files into Access all the time, coming from different companies.

The problem is probably with you network, and not with Access itself. What does you database do? And what version of Access are you currently using?

Simply try using VBA code to get the proper file name to help, if you are not sure how to do this, I will gladly help...

Thanks, I was able to modify the code and make it work to the way I wanted. I was really hoping to avoid using Access to perform this, as the procedure will be running on a server using Windows 95 and does not currently have Access installed on it.

Sorry, I failed to mention, that this will be a daily procedure, therefore a batch file will be run every night renaming all the files in the specified directory. The date will always be the current date.

I know that command, but how can you do that for 400 files (that have the same filename length), without hardcoding the filename, or the date itself?? Any ideas?

I know this is a little off topic, but you guys have all the answers!! I need to rename a file as such: current file name: puro.88344 to be renamed to: puro.20031015.88344 Does anyone know the command line to execute this renaming? Also, I have about 300 files like that eg.(puro.94323...

Thanks a million Calvin, you are truly a lifesaver. Have a beer on me, Erik

PROBLEM Actually, there seems to be a problem when the directory of the source file has spaces eg. strSourcePath = "C:\Program Files\Sfiler\Cft\Upload\" It crashes because of the space between 'Program' and 'Files', any ideas?? Thanks Erik

Thanks GHudson, worked like a charm. I was able to modify the code to fit my need and everything works as planned, thanx a bunch Erik

Is there a way, I'm sure there is cuz Access can do it all, to automatically zip a specified file. I would like to zip it as soon as I export it. Any help would be greatly appreciated Thanks, Erik

Are you trying to change the background of a form??

use the now() function to get the current date

All I can really think of off hand, is to ensure that your code is not currently running when you select Tools --> References.