Search results for query: *

Just a suggestion: Try defragging your hard drive(s). I have seen performance issues with users running databases on their hard drive have problems just like you are describing. In almost every case, once they defragged, time to open improved dramatically, and errors on load reduced. Remember...

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...

thanks everyone for your feedback. it's begining to look like I am going to need to figure out how to make that API call work... unfortunately, I don't know to do that. [purpleface] So I guess I'm back where I started, unless anyone has some advice where I might go to teach myself API in a...

thanks for the genomon, but I don't know enough about api calls to make use of this. I was hoping for an ADO solution to the problem, if you've any thoughts along that line? Melanie ~Tazcat2k~

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...

That was it!!! It even had the code to close the window if found. Thank you so much, Remou!!

Thanks Remou, those are all great threads. Unfortunately, they don't cover what I need. I need something that a) rather than working on a timer, works on command and b) checks to see if the active user currently has the other db open on the same system. It doesn't throw an error if...

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...

BLESS YOU! You saved my bacon again. I can't believe I missed something that obvious... Stars for you! Melanie

Hi Golom, I structure the query according to your suggestions, and it has been working great. Now however, I need to change how I am doing this, and run it not from a stored procedure, but from VBA. When I created the stored procedure, the SQL looked like this: INSERT INTO tbl_RecallArchive (...

Examples 3 and 4 aren't anything I am currently using, but something I was considering, if it would save time. Since they don't actually exist, I was writting them of the top of my head, and probably referenced the wrong tables, or copied something else that I was using elsewhere. In any event...

Thanks rac2. Perhaps I should have been a bit more specific regarding what I need to know. I should have said that I am referring to how to execute this from my code, not how to structure the query itself. Therefore, from a code perspective, which is the better method, performance wise? I will...

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...

Golom, can't thank you enough for the help! Worked like a charm. I had to add the additional columns to the table with blank values, but it still worked perfectly! Melanie

Nice idea, thanks! I'll give it a try in the morning and let you know how it works. Melanie

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]...

bless you both... solved my problem!

hey there. not to beat a dead horse, but this thread is right on target with an issue I am having... I've read through this thread and tried several ways of getting this function to run, but my problem is I am playing with one property not mentioned above. I would appreciate any feedback at all...

I modified the procedure, but now I'm getting an error "item not found in this collection"? Set con = DBa.Containers("Tables") 'read selected container objects and add to table For Each doc In con.Documents 'check if its a table Set tbl = DBa.TableDefs(doc.Name) On Error Resume...