Recent content by tsosiel

All... Thank you for the input!! I will try the code supplied by FancyPrairie.... and I skimmed the link - good one! If I have any problems, I'm coming back to this link! Thanks again.... -Lorentz

Greetings all... I am developing a front-end app in Access2000 and I'd like to set up the main window (Access itself) to be a certain dimension - regardless of user screen resolution. I'm not sure if this is possible... ??? I have users who's resolution is as low as 680 X 480 and high as...

zevw... Thanks for the input. And yes, I hadn't thought about corruption or other admin duties. I agree with you. Thanks again... - Lorentz!

Greetings All, I'm trying to do the following in my application. I have an external Access2000 db for my backend and an Access2000 db for my frontend (w/plans of migrating in the future). I'm having difficulties trying to perform the following (after much reading from...

Okay... got assistance from Microsoft... Microsoft Knowledge Base Article - 198571 HOW TO: Call Excell Functions from Within Microsoft Access 2000 <http://support.microsoft.com/default.aspx?scid=kb;en-us;198571> Good luck. - Lorentz

Thanks. I will consider my options. I'm that much closer to using Excel's functions... - Lorentz

Thanks for the input Skip; however, I cannot seem to reference the file APTVBAEN - and when I Browse to the file, it returns an error that it cannot reference the file. (It might be due to the Administrative access to my pc - which I donot have???) Also, the call is from a module within...

Good day... I hope someone can assist me in resolving my problem in executing a function within Excel's Analysis Toolpak for VBA Add-In in my Access database (2000 using ADO). I've followed some examples from the net, but I end up with the following problem/error: Cannot find DEC2BIN macro...

Good day... I have the following problem with Excel's Analysis ToolPak functions. I am trying to use the functions within Access2000. I've look on the net for assistance and thus far, I can't seem to reference the Add-In excel file that contains these functions. I do not have Admin...

Thanks for the assistance Bob. But I figured this problem out a couple of days ago; I forgot to up date this thread! Basically, I was trying to run a query on a table that didn't exist AND verify that the table existed... normally, Access would return an error... but not so for Make-table...

Greetings. I'm new to ADO and I'm trying to implement the following function which will determine if TName exists as a table. The function crashes in one of my database; works well in all others!! Does anyone have a clue/idea/comment to my problem? I've tried creating a new db and importing...

Thanks for the input. I will look into the suggestions. - Lorentz

Greetings.... I have the following problem. I have an account on a UNIX server that has SQL (SQL-PLUS); I created a front end using VB.net... But I cannot connect to the UNIX/SQL server to access the data!!! I'm not sure what information I need in my connection string... but I'm open to...

Thanks for the reply... I'm still getting my feet wet with the forums. - Lorentz

Greetings.... I have the following problem. I have an account on a UNIX server that has SQL (SQL-PLUS); I created a front end using VB.net... But I cannot connect to the UNIX/SQL server to access the data!!! I'm not sure what information I need in my connection string... but I'm open to...