Search results for query: *

Hi everyone, I've already pulled 1DMF's wonderful code on FTPing files with Access (particularly liked the error handling routines, btw). But my problem is this: my company requires that we use SECURE FTP (SFTP) rathter than plain FTP. I've been searching all over the place, but cannot find any...

I've an Access frontend connected to a SQL backend. The SQL server prompts the user for their ID/password at log in. I need to write a function to capture the UID out of the ODBC connection string, and store it to a variable. For the life of me I can't figure out how to even get started on this...

Putting this one out there in the hopes someone can help. I've been through forums and faqs, msdn and microsoft support, all to no avail. Bare with me as I explain what's up. I am developing this db in Access 2003, but with default file format set to 2000. My users (mostly) are on 2000. This...

Hi, I have a function from a command button, that opens another database from within my current db, runs a module there, and then closes it. The function itself works fine. Here's the problem: if the active user already has an instance of the reference db open, the function throws an error, and...

I have a situation where I need to update an archive table several times through out the day. To do this, I need to generate some temp tables to populate aggregate data to the archive. Basically, the user enters a bunch of new records, or alternatively, closes a bunch of existing records as a...

I have an append query that I use to create an archive table. The SQL is below: INSERT INTO tbl_RecallArchive ( [Report Date], [Item Type], [Age Category], [#Items], [Current Value] ) SELECT Date() AS [Report Date], smry_RecallsAging.[Item Type], smry_RecallsAging.[Age Category]...

Does anyone know how I might be able to capture the Description of a table or report from the Database window? There doesn't seem to be anything in AccessObjects that refers directly (or even indirectly) to the Description placed in the Database window properties for a form, report, table, etc...

I'm trying to write a form-load function, which will read the property of a table in my db, and display on the form the date the table in question was last updated (sort of a systems check to be sure things are working correctly.) I have this piece of code, which my brain suggests should work...

Ok, here's the problem. I have one form, Details, which has a boat load of buttons on it. I created a "help" file, which gives descriptions for each button, and what it does. I have everything else working OK, but now comes the fun part. I am trying to read the button name from a...

Its just too late on Friday before the holiday, and for the life of me, I cannot figure out what is wrong with this piece of code. Any thoughts? Even if its just to tell me what a schmuck I am? Private Sub Form_Load() Dim dtDate As Date dtDate = Now() If DatePart("h:mm:ss", dtDate) >...