Recent content by mikehoot

For those wishing to do this via code, I added the following lines to my startup form's Form_Open event. The WindowsInTaskBar line is not related to this thread, but I do find it useful! Private Sub Form_Open(Cancel As Integer) Application.SetOption "ShowWindowsInTaskbar", False...

Fantastic Tip!!! I have spent weeks looking at performance tips for access and have not come across this one before. My current project is a multiuser project database. I have shortened the network path, used a smaller filename for the BE, and optimised queries/indexes, but nothing came close...

Create a record with a blank entry. Then set your combo's default value to the key (bound value). Then if a user selects a record and changes their mind, they can select the blank record or delete the entry. Either way the blank entry is selected. :-)

It is possible, but you need to follow some steps. Go to Microsoft KnowledgeBase website as they have an article on this.

Go to the Properties of your combo, and change Format to Yes/No. :-9

I wouldn't change the bound column value as this is the value stored in your table, usually the foreign key (Primary Key of other table.) You could place a text box next to you bound combo-box which displays column 2 from you combo-box.

I agree, a good idea, and can be customised as required. For example, I have implemented Access Security and therefore can record CurrentUser() as a text field in each new record, including records re-created from existing records. This gives me great control when it comes to audit. Nice One :-9

You could use the forms On_Load event to check for the nimber of records in the qry recordset. If >1 then close form and show msg popup. Sorry, don't have time to write the code but you get the idea.........:-9

"Data Entry" makes the form default to Add New Record. To edit existing records, leave this to NO.

MaggieB You might think the program is pesky, and I would probably agree, but if you copy the system.mdw file then the original has exactly the same properties as your network copy. Even if you apply permissions using your copy, the original system.mdw file retains admin rights. As Access...

You need create a unique .mdw file. Then log into your unsecured db using a shortcut to this mdw. Now go through the securing process and your new secure db will be limited to this mdw file. Again, add a pw to user ADMIN and add another user with ADMINS permissions. Then remove ADMINS...

To convert back to original I would look for 2000 version on their site. I'm sure it is there. Try looking at the 97 page and check out the keywords at the bottom of the document. Then repeat these for a search on Access 2000. :-9

Try these two links below. They may help. One is an FAQ on replication and describes a process to recreate the CONNECT string for your tables. The other is a tool to convert you design master to regular db (Access 97). If you are only making design changes to your front-end forms etc, I would...

Create a module called modMinToTime and paset the following function Function mintotime(myminute) mintotime = myminute \ 60 & ":" & Format((Abs(myminute Mod 60)), "00") End Function You can now call this function from your db. Simple use mintotime(myminutes)...

When you use the Linked Table Manager, what is the path shown for the linked tables? :-9