Search results

Sorry - thats the only way i know how, I would imagine you would have to sign up to the google maps API to be able to customise to that degree. Regards - Ian

I do something similar where I have a combo box with SiteCode, SiteName & Postcode and use a button with the following on the on_click event If (Not IsNull(ReferringTrust)) Then strSearch = Replace(Me.ReferringTrust.Column(2), " ", "+") Application.FollowHyperlink...

We have a few databases that have been ported over. You need to set up your odbc links and add a User DSN connection to the database in the first place. 1) Go to Control Panel, Administrative Tools, Data Sources (ODBC)... Click add select SQL Server Driver and follow the prompts.. 2) Right...

Thanks for the quick response regarding this... however i feel i may have to beg and get networking to map all users to a common drive as an interim measure until we can get this onto the SQL Server. for some reason when using paths they only work when using drive letter: will work as it...

Thank DCrake, I will have a look into the DSN option and see if i can get that to work. Thinking about your initial suggestion, I think i could get the splash screen to check a registry value and compare it, but how would i programatically get it to relink the BE? Regards -- Ian

Hi All, I have a database with FE/BE split, and our IT Networking dept are moving all data onto a new server, the problem lies with the policies that are being implented alongside this, where users are no longer able to browse top level folders - and users have now had the ability to map drives...

The plot thicken's - when looking in ODBC Drivers - I notice i have 2 MS Access Drivers... v4.00.xxx and v12.00.xxx - I guess the latter must have been installed after i had to install the 2007 compatibility pack. - I have since removed the compatibility pack but the drivers remain - If i can...

I asked our IT department to come and re-install office, so I am now running Office 2003 without any Service Packs.... and it still doesnt work, so I guess my problem was not with SP3. Could it be Microsoft Query?

This is what I use (although you must use 24hr clock format) and displays the total minutes: ((B2-A2)*24)*60 Where: B2 = Time Out A2 = Time In Hope this helps - Ian

Afternoon all, I am wondering if anyone else has come accross a problem that I am encountering when creating a PivotTable from an External Data Source? I am running WinXP SP2, Office 2003 SP3 I need to run a pivot in excel based on a query in Access (there are in excess of 130,000 rows, so I...

Hi - could be as simple as on close, I have a similar thing in one of my databases where i have a close button to close the form and return to the previous form, which uses the following code Dim stMessage As String stMessage = "" If Nz(Me![cboCondition], "") = "" Then stMessage =...

ReadOnly FullData FullPermission etc.... are groups which i have set up in my security file so you would need to amend these to reflect your groups, I think the defaults are users & admins I think also that the Microsoft DAO 3.6 Object Library needs to be referenced if you dont already have it...

Hi i did find a function that gets the user names when using access' user level security as follows: Function GetUserNames(ctl As Control, varID As Variant, varRow As Variant, varCol As Variant, varCode As Variant) As Variant Static swrk As Workspace Static sastrUsr() As String...

Thanks Dennis & Doco, I did not understand fully how the function worked and how to tell the function what field to use as below ValidateNHSNumber(Me!NHSNumber) After seeing your posts the obvious hit me and i understand what to do, I have just tried this on my database and it works...

Thanks Dennis, I will have a go at putting this into action after lunch. Thanks again Ian

Hi doco, I am trying to evaluate whether the number entered is a valid NHS number using the Modulus11 algorithm, so if the number entered into the field has been incorrectly entered (eg typo) a warning is triggered that prompts the user the number is invalid. I can get the message box to pop...

Hi Guys, After thinking the hard work was finally over and being given the solution, I thought i had struck gold, unfortunatley i am still unable to resolve this and am asking for your help once again. I have attached a sample form with a valid NHS Number on the form as data to check, I would...

Many thanks to all who have responded to this thread, i cant begin to tell you how appreciative i am - was almost at the end of line with this. RG - yes NHS Numbers are created by the Department of Health as far as i am aware. & as suggested i just need to run a validity check when users enter...

I use this on my database and it works exactly as you want... Private Sub btnDeleteRecord_Click() On Error GoTo Err_btnDeleteRecord_Click Dim Answer As Integer Answer = MsgBox("Are you sure you wish to delete this record?", vbYesNo + vbExclamation + vbDefaultButton2, "Delete Confirmation")...

Hi - I am trying to get to grips with validating an NHS number using the modulus11 algorithm on a form prior to saving the record. So far i have managed to find some code and adapt to what i want to do but cannot get this to work fully - ideally i need this to work on an on_click or on_dirty...