Recent content by jrjr

Read the readme.... this should be pretty much self explanatory I am not sure where the original came from but I added the listbox to make changing BE's faster and easier. Enjoy :D

The last line of instructions: All of your forms will need to be set to modal- yes and pop up- yes

Delete your duplicate posts!! Did you see this post? http://www.access-programmers.co.uk/forums/showthread.php?t=97578 What I use: make a new function: Function fSetAccessWindow(nCmdShow As Long) Dim loX As Long Dim loForm As Form On Error Resume Next Set loForm = Screen.ActiveForm If Err...

Well, thanks anyway.... it sure is a puzzler and I appreciate you taking some of your time to think about my issues. As it stands now I am blaming permissions. If anyone else has an idea or something for me to try, please let me know. Any ideas are welcome at this point. Edit: OR if you can...

Yes this is true, however, it has been working fine for almost 2 years and still works fine for a lot of people.

Yes that is correct. The original form that saves to the original BE is the one that stops saving when the new form and it's linked tables are added to the FE. This only happens with some users though. Thats the strange part, and the same setup works fine for everyone in other deployment areas...

Just closing the form or advancing to the next record has always saved the record in the past just fine and this is the way it normally works. I did place this code in the submit button just before the close form statement but it made no difference: RunCommand acCmdSaveRecord As far as...

Ok, here is my scenario. I have several FE's each saving in their own BE. They are all the same but for different areas of our business. Each has around 20-30 users. I recently introduced another form into the FE that has linked tables to another different BE in another folder. Each FE out...

Just a thought, you could use Windows task manager to run the DB at a predetermined time and have Access shut itself down after the mail is sent. Add yourself to the mailing list to check that it is working.

1st time.... 9 years 2nd time... 9 months Presently... 5 years (I got it right this time :D )

Not a pick up line but I always liked this: C:/dos C:/dos/run run/dos/run :D

Check this: http://www.access-programmers.co.uk/forums/showthread.php?t=98368 There are many other exapmles on this site too... try the search

As a NY state resident I can attest to this. The law has been in place for a couple of years. Sadly though it is still VERY common to see drivers using the hand held phone. I rarely talk on my cell and I still think the law is a waste. Someone somewhere made some $$$ on it or it would have not...

Check out my sample database: http://www.access-programmers.co.uk/forums/showthread.php?p=443575#post443575

Caveat Emptor If the business has interest in staying in business than they would certainly let you return them. Bad press via word of mouth should be a powerful advantage for you if they have any experience under their belt. I bet the business is fairly new?