Search results

Finally manage to open the link. Methinks my computers having a day. This is my 3rd attempt to submit this post. I'm gonna Ctl C it this time. I make BE changes about once or twice a year and have anywhere between , depending on the client, 20 - 100 concurrent users. So I need to make sure...

I had another thought which I'll share in case others searching this post also follow the above. In my BE TblCurrentUsers I'm going to add a field to hold a marker for the current form the user has open. (down side is that I have to remember to add update code to every open form event) That way...

Thanks HiTechCoach, for some reason I can't open your link. I get the message; "Oops! Google Chrome could not connect to www.hitechcoach.com" Anyhow, if the link shows me how to spilt my app to FE BE, then I've already done that a while back. I also take your point about idle users and will...

Thank for the replies I wasn't overly worried about users staying logged on for long periods. In fact I expect every user to stay logged on for at least 7 hours a day. It was just for updates to the back end and also ensuring users always have the most up to date front end (latest version is...

Using 2010 How do I go about logging off remote users? I'm absolutely lost with this and don't even know where to start. The only thing I have is a table holding names of logged on user which I'm pretty sure will be needed. Other then that nothing. Any pointers on how I go about this would be...

If you're going to update the numbers then definitely don't use Autonumber. once a number's been used it can't be reused so merging later on wont be an option. I'd run Dmax immediately BEFORE saving the new record. If there's multiple users, this'll reduce the possibility of more then one user...

Thanks guys, Looks like a third party solution might well be the painless answer. I'll be taking a closer look tonight to see there's an interface with something like skype (might be useful) I've got about 2000 daily users so might be able to do a deal with a service provider. You never know...

Just bouncing this around. I'm in the throws of re-developing a database I wrote 11 years ago and want to take the opportunity to add some additional functionality. One of the changes I'd like to add is the ability to send SMS messages to users. I haven't started anything yet, it's just a...

and such a detailed reply. wow

Depends what it is and what it's used for. If it handles financial (credit card) transactions there's a whole host of regulations that you have to take into account. If it's for a statutory body then you also have to look at the freedom of information act (well maybe not have to but certainly...

As always, Bob's spot-on. Thanks

I've been using something similar to Bob's suggestion for a while and it works really well, just don't forget to disable the tab stop for the underlying textbox otherwise the illusion might be rumbled. SmallTime

In case someone else wants to do the same, my quick and dirty solution for the time being is to put the startup property changes (above) into the OnClose event on my main menu so that any changes made by the user are overwritten/reset on closure. BE AWARE that you HAVE to implement a way of...

Hi You could set the field in the table to autonumber and ensure new values are set to Increment. With regards to starting at 500; past this into the sql view of a blank query and change 'YourTableName' and "YourAutoNumberField" appropriately. run the query (The exclamation mark in...

Using 2010 Is there a way of disabling the file tab on the Ribbon or alternatively the ‘Privacy Options’ button in the file tab as this allows the end user to change various settings. I’ve already disabled quite few start-up properties as follows: Dim iRetVal As Integer...

So sorry to hear this. It's stopped me in my tracks. My thoughts are with David's family and friends and hope they find some solace in the knowledge that he helped a great deal of people (including myself). David will surely be missed and our community will be much poorer for the loss...

Not sure if this may help but; OfficerNumber_AfterUpdate() Me.EDWNumber = vbNullString However, OfficerNumber in EDWNumber.Rowsource Criteria =[Forms]![ReportDetails]![OfficerNumber] Isn't this causing a conflict? It's a little late here so I could be barking up the wrong tree, let me know...

Does anyone know where I can get a definitive list of access 2010 startup property names. Did Google search for the last 2 hours but think I'm looking in all wrong places In case some else wants what I have so far: Text in Startup dialog box Property name Application Title AppTitle...

Thank you so much Bob Changing from 2000 to 2010 sometimes make me feel like an absolute nitwit Kind Regards SmallTime

This code in the onformat of a report header previously worked fine in A2K but 2010 throws an error message if the date field in the form is empty. If IsNull(Forms![FrmAccounts]![TxtStartDate]) Or Forms![FrmAccounts]![TxtStartDate] = "" Then Me.LblHeader.Caption = "Order Data" Else...