Search results

Thank you everyone for your help after stepping through the code when logged in as one of the users I discovered that the code was trying to access a file in a folder that no longer existed. Due to a crypto virus getting into our system 4 weeks ago and in the rebuild we deleted a lot of...

Thanks for your responses everyone. On reflection my login to the access application is purely a check on the user name and password against an access table entry. Has nothing to do with permissions etc. I'm sure my problem lies in the differences in terminal server profiles across users. Our...

I have a relatively large application accessed by 14 - 16 users. I have created a module that allows the user to select an action plan. An Action Plan represents a list of word templates with Book Marks so the system can perform a merge and fill in the details of the current Client into all of...

Thanks arnelgp will that effect any of the calculations etc Atrium

The field format is set to currency eg $0.00) the user moves to the field by clicking on it or users the Tab key. When the user enters a fugure int the field I want the field to loose the formatting and allow them to put in (eg 2387.09 or 560 and when they leave the field I want it to appear as...

Do I have to go sharepoint if we use Access 2016. Watching the video was a bit scary as I have about 96 tables in the database and heaps of VBA I have some files with 50k+ records Or should I go to sharepoint in 2010 and then go to 2016?? Atrium

We are considering upgrading to Office 365. At the moment our major database application is written in access 2010, therefore I need to look at the process of upgrading the database to access 2016. I'm sure many have been through the process I just want some tips and tricks to make the...

I keep on getting this error after I have gone back to an open form and close it. Form A displays the fields from Table DdSchedules Form B launched from Form A displays the fields from Table DdSchedules and a subform displays related records from another Table DdSchedTrans in a query When I...

Our terminal server at work is managed by a third party, it's our equipment housed at our site and remotely maintained by the third party. When I log in from home I'm logging in to the terminal server so my profile should be exactly the same as if I was at work logging in from my desktop. The...

A very simple error BUT the highlighted field is declared as an unbound field. Private Sub CopiesOKButt_Click() 'MsgBox "PCopiesFld = " & Me.PCopiesFld If Me.SourceFormFld = "Clients" Then Forms![ViewPrintSendClientFrm]![CopiesReqFld] = Me.PCopiesFld Else...

We run Access 2010 on a MS Small Business Server over a Terminal server. I have written an extensive project in Access that looks after all of our operational functions within the company. Clients, Debtors, Matters, Financial transactions, Payments receipts etc, Trust and General Account...

Thanks again for your suggestions. I read the link details and decided against the multiple subforms - I have too many records. I overcome the problem by not trying to set the tick box to enabled=False when the user tried to set the tick box on with the trigger set I set the tick box...

The tick box is bound and the value is ok for different records but when it is enabled = false all of them are greyed out Thanks for you help guys. I will have a go at your suggestions and also lookup the link you mentioned. Thanks again

My form displays multiple records (2 rows each) and I have specific fields across the record that I want to update by clicking on a tickBox or entering info in a text field. As a result of a comboBox field changing in record I need to change the tickbox to Enabled = false. My problem is...

In answer to CJ_London YES When I login remotely I log into my normal account on the server

Yes both folders are trusted folders in the trust centre

AH just had a thought. I have two versions of the project. A development version and a LIVE version. I make all changes in the development version, test and then copy the new version into the LIVE site. I must check if the both the Live and Development directories are trusted folders on the...

Thanks guys, logging in to the terminal server from home. Sounds like missimglinq might be on the money. How can I fix that? Thanks for your help

I do a lot of development after hours from home. I log into the network (terminal server) via login and password. I can update forms, reports, queries, tables etc and have no problem running them from home. When I get into work some of the forms will not work. The event button on one form can...

Thanks Arnelgp for your help. I keep on getting compile errors on the set rs = db.QueryDefs(strQryFileSQL).OpenRecordset(dbOpenDy naset) do I need to declare dbOpenDy naset or initialise them ?? atrium