Recent content by MatthewDavis

This might be to simple, but you could set up a table in the back end for number of users. Then in the opening form of the frontend database, check the value in the number of users table. If the value equals 5 then give the user a message box and quit the database. I hope this helps. Matthew

Look on the site: http://www.mvps.org/access/api/api0019.htm I have been using this for splash screens. It works very well.

Try this: forms![frm name]![subfrm namej].allowedits = True. If that's not correct, search the help files on subfrm and addressing it from another form. This syntax is close, if not correct.

When you change the allowedits = true, do you also have a second line of code to address the subfrm? The syntax should be the same, but include the subfrm name. What syntax are you using? Matthew

I tried using the same format myself, with no luck. Do you have the book, Access 97 Developers Handbook? Great book. The authors have provided a great calendar program, that is easy to use, and very effective. Also, check this web site: http://www.mvps.org/access/ mvps.org has a great...

Thanks Trevor. I tried an append query from a temp table with a memo field to my real table with a hyperlink field. Still did not work. But, this did. In the append query, I put Q100025# in front of the path string, now it works. The only down side, I cannot edit the hyperlink. Thanks

After reading a posting from Trevor at www.accesswatch.co.uk, I started to build a storage location for files, base on hyperlinks. I'm using an active X Common dialog control to capture the path to the file. I then place this path into a field, the field is a hyperlink formatted field. The...

If I have a field, that has the value of; Green, Yellow, or Red. Can I change the font color when displaying it, to the matching color? And Can I do this in a list box? Or Do I need to do it in a Sub form? Thanks

Thanks for the ideas. The filecopy function is what I was looking for. The catch to filecopy though, is you cannot copy a file that is open, it errors. But, on the Microsoft knowledge database is a function, CopyFile. This will let you copy a open file.

How do you make a complete backup copy of your backend database? Can you call a windows function, that can copy the backend mdb file and rename the copy with a date? Is a DOS macro the only way to do that?