Search results for query: *

Thanks for the detailed instructions, foolio12! When I go back to that computer tomorrow morning, I will try what you said. Of course, after having re-joined the default system.mdw yesterday, I didn't attempt to open the file on my desktop with the /wrkgrp parameter shortcut. I understand that...

Thanks foolio. Right now I am at the other office on a different computer -- my Access files or new ones open fine without bringing up a user name/password combo on this computer. I will try your advice. Yesterday, I did copy (not move) my backed-up system-bak.mdw and, using the Workgroup...

I tried following the steps for creating a secure database in Access using a 12-step instruction sheet from a link on Access Security Methods. I backed up the "system.mdw" as "system-bak.mdw" in another folder. I created a new .mdw and named it secure.mdw using Workgroup...

Because I changed the default menu in Tools | Startup for my current database project, and I changed the Menu bar to my own, I am not able to use Tools | Options and check off "compact database on exit". I want to be able to perform this function on exiting, but now I can't access...

I was trying to import an Excel datasheet with an EmployeeID column formatted as Text in Excel, and I want it to remain a text field in Access, because some of the EmployeeIDs have leading zeros that should not be truncated, e.g. 0023335. It imports EmployeeID as datatype double. But since the...

Yes, I understand about your desire to see how many times a user logged in; it's not so important here, just as long as we know they logged in 3 or 4 times and need to backup the db. I will bookmark the link you sent and read it very, very carefully!! Thanks.

Seaport, I'd like to run a similar batch file like the one you listed above in Access but just not at Startup. Maybe just run it when people exit the database. What line of code could I use in VBA that would execute this batch file? Thanks. -- Michel

Thanks again, Paul. I had actually "joined" my new .MDW via a shortcut but only to 1 specific database. Later, however, whenever anyone tried to run Access for any reason, it looked for that .MDW, even when trying to create a brand new database. I was forced to "rejoin" the...

Thanks for your code snippet, Paul. I am going to revise it slightly since I don't use the CurrentUser and this database is not a secured one yet. I saved my user names in a public variable called gUserName. I had so many issues implementing Access security that I ended up corrupting the...

Thanks, Paul! Someone at another Access forum suggested basically the same thing, but how would I store the value in CountOfLogins so it's remembered each time after Access is exited? Should I use an update query on this field that adds 1? Also, might I need some kind of For ... Next loop that...

I created backup data queries on my db, but I'd like to have a variable that stores the number of times the db was accessed, and tell that user, as when using Quicken/Money for example, that data should be backed up. As long as the program is open, I can create a static variable, for example...

I didn't mean giving the fields arbitrary names like Field1 or Field2. I was just wondering if, based on the field names, it might help in developing a possible new table or tables, that's all.

Is there any "formula-like" way of resolving the issue of a many-to-many table relationship? If, for example, I had two tables, 1 called PASSENGERS and another called FLIGHTS, I might be in quandary because a passenger could have many flights, and flights could have many passengers...

Thanks, Cirrus9, for all your input. I did read something before about creating a boot diskette, but Win2K came pre-installed on this Dell computer, so I never fooled around with it. Anyway, I will read your message and see if I am able to do this myself. I am a bit hesitant, though, as I want...

Thanks for your feedback, Cirrus9, but I had these hourglass problems with recent document history and dial-up logon/logoff dialog before I ever installed Zone Alarm. What updates do I download from Microsoft that might help resolve this, and how would I otherwise configure NAV? This...

I recently had my Win 2000 Professional PC de-virused and have both Norton's LiveUpdate on when I'm online and Zone Alarm's firewall runs whenever I boot the computer. One problem that they didn't resolve, because I forgot to mention it to the techs who de-virused it, was a problem with the...

You also need to check the options you set under Tools | Options, and one of the tabs allows you to set the behavior certain keys like ENTER and TAB. By default, though, when you reach the last field in a record on a form and tab, it will take you to the next record. Go the Options menu.

Ok, Thanks TPetersonFlorida. I will recode it and hope it solves the problem. -- Michael

In the general declaration of my form I Dim Rs as DAO.Recordset. In the form's load event, I Set Rs = Me.RecordSetClone Why do I get an error message in the form's close event that an object variable is not set, when I put the following code into the form's close event: Set rs = Nothing...

Ok, thanks. I will try to build a form like that one, let the warnings be turned off, and see if appends just those that records that are new. This might in fact work. I just thought it could be done in query by setting this criterion. :)