Search results

Afternoon all, I am trying to create a very simple progress bar that just continually scrolls and resets to show something is working, I have a query that runs off sqlserver that takes around 5 mins to run and make the table, what i wanted to do was just to show that something was happening...

Hi all, I have on a form a text box where the Default Value =Environ("Computername"). Now this has previously worked just fine, but for some reason for the last couple of times i have gone into the form the text is displayed as "#Name?" not the computer name which is expected. ...However if...

Hi all, I have been trying to adapt a piece of code I found on this forum some while ago which checks a fields value before updating to check for duplicates for both new and existing records. The first part of the code works fine for new records. It is the second part which i am struggling...

I have a listbox which is populated by a query, however i have been asked by our Commissioning department if it would be possible to search contract values, with more than, less then etc. I added an option group to my form with the following afterupdate Select Case Me.opt_FinanceOption Case...

Hi all, I am looking for a way to have a check on a continuous form, I have a subform which allows me to select a number of areas (localities) to which a service is provided to, I have been asked to add in an apportionment split field which i have done - no problem there. But what i would like...

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...

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 - 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...

Hi - I am working on a database where i need to update a table with a "UniquePersonID" I have a master table which stores: UniquePersonID Surname Forename DOB SEX Postcode This table is approx 600k records, now the problem i have is that i have further tables which contain Surname, Forename...

Hi All, I wonder if anyone out there can help with a huge headache i am getting - We have a database which logs patient contacts & requests and have a reminder system within which requires users to run a report to see if they have any actions that are required. What I would like to do is when...

Hi, I have just been having a look at the XShortcutBAR in sample databases by Dom DXecutioner - an excellent outlook style menu bar, I would like to use something very similar - or indeed start with this very sample - but i am struggling getting my head around the menu changes, for example when...