Search results

Exactly -- This is the approach I am taking (only with two tables, but one will be much cleaner), but I still run into the problem that if someone doesn't use the "exit" button, the TimeOff field isn't populated by the query and it skews my system (query on Null returns logged in users + users...

Can I use type -32758 to count the number of users in the linked tables? --------------------- tblObjectTypeCodes: Type TypeDesc -32768 Form -32766 Macro -32764 Reports -32761 Module -32758 Users -32757 Database Document -32756 Data Access Pages 1 Table - Local Access Tables 2 Access Object -...

Okay, I created a table tblUserlogin and tblUserlogoff which seems to track the usage fairly well, but if someone doesn't exit the proper way, it skews the system. I'm not quite sure how to go about hard coding a limit (perhaps reading the LDB file directly -- which I may be able to tool around...

Perfect - Thanks again Pat!

Pat -- Perfect, I've been able to see the Backend path and filename in a query: SELECT MSysObjects.Database FROM MSysObjects GROUP BY MSysObjects.Database HAVING (((First(MSysObjects.Type))=6)); However, is there a way to hardcode this into the form code and assign to a string so I don't...

Is there a way to resolve the backend path via code instead of the frontend path? I'm trying to put something together to check who's logged into the backend, but cannot resolve the path. When I use Current.db, it always gives me the frontend path. Thanks in advance, Pat

Perfect -- now, I've got an append query ready to run, but I need to import just one table from the other Access DB. With the Common File Dialog, how can I select the database to import from and then have it only import "Table 1" instead of "Tables 1 - 13" then, I'll run the append query once...

I'm looking to build a button on my app that will allow the user to select the file they wish to import via common file dialog, but that will also re-arrange the data each time into the correct order for the Access Table (from another differently arranged Access Table). What's the best approach...

I'm looking at this same exact situation -- Pat, can I get a copy of the link you mention below. Thanks again, Pat

Thanks FoFa - worked like a charm. It was something that needed to run everytime the app was launched. Thanks again

Sounds good - but if I put the DoCmd.RunMacro "blah" code in the OnTimer event, don't I need to set it to 15000 to run after 15 seconds. I just don't want to to keep running every 15seconds -- just to run once and then stop.

What's the best way to initiate a macro 15 seconds after a form is loaded, only once instead of the loop from the OnTimer form event. TimerInterval = 15000 DoCmd.RunMacro "MacroName" ? Is there a better way to do this? What's the best way to break the loop out so it only runs once? TIA :) Pat

Great code ghudson! Thanks for the assist, Pat

Pat -- Sounds like that would be the best way to do it. After setting my fe.mde to link to tables via the Linked Table Manager, where is that code located to hard code a UNC link? Also, do you run into problems giving a //server/path/ that people have to follow? Or do they just map a drive...

I agree, hard coding the number into the be.mdb and then checking connections to it seems the best way to do this. I'll do some searching for some sample code to point me in the right direction of accomplishing this -- or if someone has a link. Thanks again :) Pat

I was quite surprised too, except when I saw the XP package (since I had only worked on the 2003 version). The XP package puts the original MDE straight into the directory of your choosing -- whereas the 2003 version does not have anything resembling an MDE/MDB file (I just checked the files...

BTW - in reading my question I realize I may not have made this point clear. I'm mainly interested in the difference between the two packages (2003 and XP), if need be, I'll simply disable the left-shift key with a password or alternate key combo. I was just curious about the difference between...

Just curious what methods you have all employed for distributing a package with networking option. Once the MDE is packaged, is there a way to launch the linked table manager in a way so that it's inclusive to the program feel, i.e. without going to Access main program, within the runtime...

Actually, I was looking at this recently. The Copyright laws have changed slightly and after talking with the office, they pointed me to their website. More or less, unless you are involved in litigation or dispute, your works are copyrighted as soon as you have them in a tangible form (i.e. on...

Okay, some of you have read my ongoing issue with Office 2003 Developer. Well, I went ahead and purchased Office XP Developer also, to alleviate those issues. It works like a charm, except the packaging wizard is slightly different than the Office 2003 packaging wizard. Mainly, when the Office...